7 Replies Latest reply: Nov 17, 2015 4:55 AM by Naresh Guntur

# Count by Dimension

Hi,

Don't mind if it is too simple.

A, B, C

a1, b1, c1

a2, b2, c2

a3, b3, c3

a4, b4, c4

a4, b5, c5

a1, b6, c6

a2, b7, c7

a3, b8, c8

];

I have a table like above and I need a chart with A & B as dimensions

I need the below output.

I want (3rd column)the count of C aggregated at A irrespective of B so that I can (4th column)count the % of B according to the total values of A

 A B Count C at Level A Count B a1 b1 2 0.5 a1 b6 2 0.5 a2 b2 2 0.5 a2 b7 2 0.5 a3 b3 2 0.5 a3 b8 2 0.5 a4 b4 2 0.5 a4 b5 2 0.5

Cheers,

Naresh

• ###### Re: Count by Dimension

Use this expression:

Count(C) / Count(Total <B> C)

Count(C) / Count(Total <A> C)

• ###### Re: Count by Dimension

Hi Jonathan,

It doesn't give any result.

Just a null.

Cheers,

Naresh

• ###### Re: Count by Dimension

PFA

Dim1:A

Dim2:B

Exp1: Count(Total <A> C)

Exp2: Count(C)/ Count(Total <A> C)

• ###### Re: Count by Dimension

Thanks Tresesco.

It worked like a charm.

Cheers,

Naresh

• ###### Re: Count by Dimension

Hi Tresesco,

Can we use Set Analysis in this expression?

Cheers,

Naresh

• ###### Re: Count by Dimension

You can use set analysis with aggregation functions. But you have to specify the purpose why/how you want that. Otherwise, set analysis would not be an ideal one with the requirement you mentioned above.

• ###### Re: Count by Dimension

I want to use it for a specific date. I wonder if I can add this in set analysis along with this.