barchart percentage of total

[kris_vliegen]

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

[sunny_talwar · Accepted solution]

This

Count({$< RecordTRX_D = {1}>}distinct(Key_TRXD)) /Count({$<RecordTRX_D = {1}>}distinct TOTAL (Key_TRXD))

Or just select relative on the expression tab

[kris_vliegen]

Thanks Sunny,

sometimes it can be this easy...