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: [1] |- align="left" valign="top" | style="border: 1px solid #010101" width="171" | Question - Multi | style="border: 1px solid #010101" width="171" | Same as data cache column name | style="border: 1px solid #010101" width="171" | The corresponding question’s text in the default language | style="border: 1px solid #010101" width="171" | Same as data cache column name | style="border: 1px solid #010101" width="171" | Column_name != empty | style="border: 1px solid #010101" width="171" | 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] |- align="left" valign="top" | style="border: 1px solid #010101" width="171" | Question - MultiGrid | style="border: 1px solid #010101" width="171" | Same as data cache column name | style="border: 1px solid #010101" width="171" | The question’s text concatenated with the sub question’s text in the default language | style="border: 1px solid #010101" width="171" | Same as data cache column name | style="border: 1px solid #010101" width="171" | Column_name != empty | style="border: 1px solid #010101" width="171" | 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] |- align="left" valign="top" | style="border: 1px solid #010101" width="171" | Question - SingleGrid | style="border: 1px solid #010101" width="171" | Same as data cache column name | style="border: 1px solid #010101" width="171" | The question’s text concatenated with the sub question’s text in the default language | style="border: 1px solid #010101" width="171" | Same as data cache column name | style="border: 1px solid #010101" width="171" | Column_name != empty | style="border: 1px solid #010101" width="171" | 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] |- align="left" valign="top" | style="border: 1px solid #010101" width="171" | Question - Scale | style="border: 1px solid #010101" width="171" | Same as data cache column name | style="border: 1px solid #010101" width="171" | Same as data cache column name | style="border: 1px solid #010101" width="171" | Same as data cache column name | style="border: 1px solid #010101" width="171" | Column_name != empty | style="border: 1px solid #010101" width="171" |
|- align="left" valign="top" | style="border: 1px solid #010101" width="171" | Question - ScaleGrid | style="border: 1px solid #010101" width="171" | Same as data cache column name | style="border: 1px solid #010101" width="171" | Same as data cache column name | style="border: 1px solid #010101" width="171" | Same as data cache column name | style="border: 1px solid #010101" width="171" | Column_name != empty | style="border: 1px solid #010101" width="171" |
|- align="left" valign="top" | style="border: 1px solid #010101" width="171" | Question - Number | style="border: 1px solid #010101" width="171" | Same as data cache column name | style="border: 1px solid #010101" width="171" | Same as data cache column name | style="border: 1px solid #010101" width="171" | Same as data cache column name | style="border: 1px solid #010101" width="171" | Column_name != empty | style="border: 1px solid #010101" width="171" |
|- align="left" valign="top" | style="border: 1px solid #010101" width="171" | 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) | style="border: 1px solid #010101" width="171" | “Groups” | style="border: 1px solid #010101" width="171" | “Groups” | style="border: 1px solid #010101" width="171" | First group column’s name in data cache | style="border: 1px solid #010101" width="171" | First group column’s name in data cache | style="border: 1px solid #010101" width="171" | 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) |- align="left" valign="top" | style="border: 1px solid #010101" width="171" | 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) | style="border: 1px solid #010101" width="171" | “Samples” | style="border: 1px solid #010101" width="171" | “Samples” | style="border: 1px solid #010101" width="171" | First samples column’s name in data cache | style="border: 1px solid #010101" width="171" | First samples column’s name in data cache | style="border: 1px solid #010101" width="171" | 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).