Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have 3 dimensions Name, Total and used.
In the chart table, im using an expression (Used/total)%
I can get the total as sum of rows for total and used.
But the same logic not working for the expression where i want to fetch the overall %.
Can someone look into the app atatched.
Or may be this:
Where 74.52% = 459761/616973
Expression:
Sum(Aggr(Used, Name))/Sum(Aggr(Total, Name))
Use the same logic for the third expression? If you need Avg then select Avg like this:
Summing up all the %s seems to be a bad logic. but u can do something like avg,max min of the %s.
see attached.
the expression for Total should be :
sum(Total)
the expression for Used should be :
sum(Used)
then in the 3rd column put:
column(2)/column(1)
Then use expression totals for all 3 columns
Or may be this:
Where 74.52% = 459761/616973
Expression:
Sum(Aggr(Used, Name))/Sum(Aggr(Total, Name))
Sorry, forgot to attach the example
Thanq Adrian.
Thanq CHaitanya
Thanq Sunny.
No problem, I am glad I was able to help.
Best,
Sunny