Aggregation in Dimension

[#1]

I have an CASE_ID which identifies a specific case and some steps, which are made within this case.

STEP:

CASE_ID, FLAG A, STEP_ID

123, A,1

123, B,1

123, A,2

123, C,1

456, A,1

456, A,2

456, B,1

456, A,4

I have one Dimension Field "D1". In Skript I do like:

STEP:

LOAD

CASE_ID,

if(FLAG='A', "Group1") AS D1

From STEP;

concatenate(STEP)

LOAD

CASE_ID,

if(FLAG='B', "Group2") AS D1

From STEP;

Now i want to display a Bar-Chart with D1 as Dimension and "distinct count(CASE_ID)" as expression.

When somebody selects one Bar of the Chart, I want the CASE_ID to be selected.

So i did "aggr(D1, CASE_ID)" as dimension.

It seems that if a CASE_ID belongs to more than one flag, it will be thrown out and not included in calculation.

Can someone tell me if it is the right way to handle this?

Thanks

[yduval75]

Hello,

You can use a hierarchic group to make a drill down from the group "D1" to the CASE_ID

i think this .qvw will help you.

Best Regards,

Yoann

[#3]

Thank you.

But what I want is to get only the CASE_IDs selected which are within one group, by selection a unique bar. I do not want to get the STEPs selected. The Step Table is only to "mark" a CASE_ID and bind it to a group.