The default axis set
The default axis set
Since creating an axis set is quite a big job then, whenever you create a data cache specification, a default axis set will also be created for it. You can the later go in and modify this default axis set as explained in more detail further down.
First have a look at the logic of how a default axis set is created.
For each column in the column list of the data cache specification of the types question, group and sample-rule, the logic for creating its corresponding default axis is stated as follow:
Column type |
Name |
Text |
Math-base |
Pct-base |
Options |
Question - Single |
Same as data cache column name |
The corresponding question’s text in the default language |
Same as data cache column name |
Column_name != empty |
For each answer option, create a default axis option whose name is the answer option’s text, value is if the data cache column name equals to the answer option’s value Ex: Gender == [1] |
Question - Multi |
Same as data cache column name |
The corresponding question’s text in the default language |
Same as data cache column name |
Column_name != empty |
For each answer option, create a default axis option whose name is the answer option’s text, value is if the data cache column name equals to the answer option’s value Ex: Hobby == [1] |
Question - MultiGrid |
Same as data cache column name |
The question’s text concatenated with the sub question’s text in the default language |
Same as data cache column name |
Column_name != empty |
For each answer option, create a default axis option whose name is the answer option’s text, value is if the data cache column name equals to the answer option’s value Ex: Problem_SQ_1 == [1] |
Question - SingleGrid |
Same as data cache column name |
The question’s text concatenated with the sub question’s text in the default language |
Same as data cache column name |
Column_name != empty |
For each answer option, create a default axis option whose name is the answer option’s text, value is if the data cache column name equals to the answer option’s value Ex: Q_SQ_1 == [1] |
Question - Scale |
Same as data cache column name |
Same as data cache column name |
Same as data cache column name |
Column_name != empty |
|
Question - ScaleGrid |
Same as data cache column name |
Same as data cache column name |
Same as data cache column name |
Column_name != empty |
|
Question - Number |
Same as data cache column name |
Same as data cache column name |
Same as data cache column name |
Column_name != empty |
|
Group (only one is generated for ALL sample columns in the data cache where each sample column gets an axis option in the axis set) |
“Groups” |
“Groups” |
First group column’s name in data cache |
First group column’s name in data cache |
For each group column in the data cache one default axis option will be generated with name of group column and value “Column_Name” (meaning; summarize all rows in data table where user belongs to this group) |
Sample (only one is generated for ALL sample columns in the data cache where each sample column gets an axis option in the axis set) |
“Samples” |
“Samples” |
First samples column’s name in data cache |
First samples column’s name in data cache |
For each sample column in the data cache one default axis option will be generated with name of sample column and value “Column_Name” (meaning; summarize all rows in data table where user belongs to this sample) |
Not stated here is math-base-modifier which by default will always be null (not modification of math-base done).