Percentage calc >100%

[cbaqir]

I have what I thought was a simple chart to calculate % of Override Reasons but several are exceeding 100% and I don't know why.

Any ideas?

Dim 1: RULE

Dim 2: ALERT_OVERRIDE_REASON

Exp 1: count( distinct DLG_EVENT_ID)

Exp 2: Count (DISTINCT FIRING_RECORD)

% Calc: count( distinct DLG_EVENT_ID)/Count (DISTINCT FIRING_RECORD)

[sunny_talwar · Accepted solution]

Not sure, but may be you need this

Count(DISTINCT DLG_EVENT_ID)/Count(TOTAL <RULE> DISTINCT FIRING_RECORD)

[cbaqir]

Thanks!

[cbaqir]

If I am just calculating the counts individually, would I use Count(TOTAL <RULE> DISTINCT DLG_EVENT_ID) for the first expression?

[sunny_talwar]

Not sure I understand what you mean?

[cbaqir]

I'm not sure I fully understand when to use TOTAL.

If I am trying to show only the Rules that have been overridden more than 50% of the time, how would I adapt: for example:

Override count: Count( distinct DLG_EVENT_ID)

Total fired count: Count(TOTAL <RULE> DISTINCT FIRING_RECORD) 

Show only those overridden more than 50%: count( distinct {$<USER_POSITION_FLAG={'y'},RULE = {"=Count(DISTINCT{$<USER_POSITION_FLAG = {'y'}>} DLG_EVENT_ID)