Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
PFA
Dim1:A
Dim2:B
Exp1: Count(Total <A> C)
Exp2: Count(C)/ Count(Total <A> C)
Use this expression:
Count(C) / Count(Total <B> C)
Count(C) / Count(Total <A> C)
PFA
Dim1:A
Dim2:B
Exp1: Count(Total <A> C)
Exp2: Count(C)/ Count(Total <A> C)
Hi Jonathan,
Thanks for the prompt reply.
It doesn't give any result.
Just a null.
Cheers,
Naresh
Thanks Tresesco.
It worked like a charm.
Cheers,
Naresh
Hi Tresesco,
Can we use Set Analysis in this expression?
Cheers,
Naresh
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.
I want to use it for a specific date. I wonder if I can add this in set analysis along with this.