Creating Ad Hoc Views in MINT: Difference between revisions

From IMSMA Wiki
Jump to navigation Jump to search
Evinek (talk | contribs)
No edit summary
Evinek (talk | contribs)
No edit summary
Line 24: Line 24:
</ol>
</ol>
[[File:MINT_adhoc_options.png|center]]</li>
[[File:MINT_adhoc_options.png|center]]</li>
<li>Finally, choose whether to start with a '''Table''', '''Chart''' or '''Crosstab''' for analysing the data.
<li>Finally, click '''OK''' to validate the selection and proceed to the '''Ad Hoc Editor'''.</li>
[[File:MINT_adhoc_choose_type.png|center]]</li>
</ol>
</ol>



Revision as of 11:16, 21 January 2015

This page is under construction

What is an Ad Hoc View?

The Ad Hoc Editor allows the ad hoc exploration of data - typically the data from a Domain. It is meant for users who would like to explore data, as opposed to running a pre-defined report that allows for only little interactivity.

Create an Ad Hoc View

To create an ad hoc view:

  1. In the top-level menu, choose Create → Ad Hoc View
  2. In the Select Data window, select the data the Ad Hoc View should be based on - this can be either a domain or a topic. In the Select Data window it is possible to switch between a list and a tree view by clicking on the respective icon in the top left corner. The list view provides a list of all available domains and topics in a flat structure (including those from the Public folder, if any), whereas the tree view presents them according to the repository folder structure. Select a domain or topic and click on Choose Data....
    List view:

  3. Tree view:

  4. In the next step, from all the attributes available from the chosen domain/topic, select all those that should be included in the ad hoc view. Attributes can either be double-clicked or dragged and dropped to the right-hand pane named Selected Fields. Of course, if required, all available attributes can be selected.
  5. Additional (optional) options can be specified at this stage:
    1. Pre-Filters: the data for the ad hoc view can be filtered on any available attribute - for example, only accidents that happened in a specified date range could be considered
    2. Display: the order of appearance of the attributes can be changed, for example for ordering them logically
    3. Save as Topic: the specified selection of attributes, pre-filters and displays can be saved as another object type called Topic. A topic can also be the basis for an ad-hoc view.
  6. Finally, click OK to validate the selection and proceed to the Ad Hoc Editor.

Fields and Measures

Tables

Charts

Crosstabs

Save an Ad Hoc View and create a Report

Export data

{{#switch:|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:|child||{{#ifeq:|subgroup||{{#switch:creating ad hoc views in mint

|doc
|sandbox
|testcases =
|#default = {{#switch:hlist
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}