The default axis set

From Catglobe Wiki
Jump to: navigation, search



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).