grouping of Dimension groups

[#1]

Hello all,

I would really appreciate your help with the following!

I want to create a Cyclic group of dimensions in a bar-chart. But I want to group and dimension with another group in this cyclic group.

For example:

I have 3 dimensions:

Weekday -> Monday/Tuesday/Wednesday/etc...

Weekpart -> midweek/weekend

Daypart -> Night/Day/Evening

I want to create a cyclic group with 2 options

1. 1. Weekpart + Daypart
2. 2. Weekpart

Is this possible? is it possible to add a group with the two dimensions in the cyclic group?

[yduval75]

No, it's not possible.

But you can create a new field in the script Weekpart & ' - ' Daypart in the script and a cyclic group wih this new field and Weekpart

[#3]

You mean in the SQL load script? But then you can't influence the two dimensions seperatly?

[#4]

I did however manage to make a 2nd group with the Daypart dimension and a dimension with "= " this dimension counts everything so it's not really a pretty solution but it works.

Thanks for the help!

[#5 · Accepted solution]

I see that there is also a possibility to create an if statement in an dimension. This way I can create an if statement like:

=if(GetCurrentField(GroupName)='Weekpart', Daypart)

This way the dimension Daypart will only be used if I select Weekpart in the group.