Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a barchart with a dimension "Hour" and an expression "count({ $ < RecordTRX_D = {1} >}distinct(Key_TRXD))"
Now they would like to see the percentage to the toal of all the hours.
How can I do this in my barchart?
I found something like count(Value1)/ count(total <Hour> Value1)
But how can I use it with set analysis and the distinct?
The total of all the hours is 618.
For the first value it should be (2/618)*100= 0.32%
Regards,
Kris
This
Count({$< RecordTRX_D = {1}>}distinct(Key_TRXD)) /Count({$<RecordTRX_D = {1}>}distinct TOTAL (Key_TRXD))
Or just select relative on the expression tab
This
Count({$< RecordTRX_D = {1}>}distinct(Key_TRXD)) /Count({$<RecordTRX_D = {1}>}distinct TOTAL (Key_TRXD))
Or just select relative on the expression tab
Thanks Sunny,
sometimes it can be this easy...