User Guide
×
Menu
Index
 

Define Sort Order

 
Define Sort Order
1

Choose a variable that will be sorted

1. Choose a variable that will be sorted
You can create as many sorts as there are variables in your query.
2

First level (obligatory)

2. First level (obligatory)
Every level can be sorted by a different statistic or label. In this sort the first level is "Label", it does not require setting more parameters. It could have been any statistics type calculated for this variable in a given spreadsheet.
3

Second level (added, optional)

3. Second level (added, optional)
The second level will be unweighted count. There is only one Unweighted count in the spreadsheet, but we still have to choose within which of the models the order of sort will be calculated. It is possible to use the sample total.
4

Third level (added, optional)

4. Third level (added, optional)
The third level will be calculated for "%of column, sample base". There is more than one column with this statistic type so it is necessary to determine where the calculations of order sort should take place.
5

Sort order

5. Sort order
It is possible to determine a different sort order for every level.
6

Manage levels

6. Manage levels
Using these buttons you can add, remove and move levels up or down.
 
 

Advanced sorts

 
In some cases sort can be much more advanced. Please see an example spreadsheet below.
 

 
If you want to sort Market Category of New Car in this query by "% column, sample base" you have to define within which of the columns the calculation should take place.
 
 
There might be even more sorting options available with nested questions (see example below):