Count by Dimension

[NareshGuntur]

Hi,

Don't mind if it is too simple.

LOAD * Inline [

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

[jonathandienst]

Use this expression:

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

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

[tresesco · Accepted solution]

PFA

Dim1:A

Dim2:B

Exp1: Count(Total <A> C)

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

[NareshGuntur]

Hi Jonathan,

Thanks for the prompt reply.

It doesn't give any result.

Just a null.

Cheers,

Naresh

[NareshGuntur]

Thanks Tresesco.

It worked like a charm.

Cheers,

Naresh

[NareshGuntur]

Hi Tresesco,

Can we use Set Analysis in this expression?

Cheers,

Naresh

[tresesco]

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.

[NareshGuntur]

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