User Manual
×
Menu
 
 

Define Sort Order

 
Define Sort Order
1

Choose variable which will be sorted

1. Choose variable which will be sorted
You can create as many sorts as there are variables in your query. We are creating a sort for Model of new phone.
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.
 
 

More complicated sorts

 
In some cases sort is more complicated. Please see an example spreadsheet below.
 
 
If you want to sort Make of new phone in this query by "% column, sample base" you have to define within which of the columns the calculation should take place.
 
 
It might be even more complicated with nested questions (see example below):