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 (+question 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).