Show if expression greater than x

[cbaqir]

I want only the rows to show where Expression 3 >=50%. For some reason, I am having trouble with this. I see all the rows.

Dimension: RULE

Expression 1: count( {$<USER_POSITION_FLAG={'y'}>} DLG_EVENT_ID)

Expression 2:  Count (DISTINCT FIRING_RECORD)

Expression 3: count(DISTINCT{$<USER_POSITION_FLAG={'y'}>} DLG_EVENT_ID)/Count (DISTINCT FIRING_RECORD)

Expression 3 Conditional: if( (count( {$<USER_POSITION_FLAG={'y'}>} DLG_EVENT_ID)/Count (DISTINCT FIRING_RECORD))>=.5, count( {$<USER_POSITION_FLAG={'y'}>} DLG_EVENT_ID)/Count (DISTINCT FIRING_RECORD))

[sunny_talwar · Accepted solution]

Try this

Expression 1:
Count({$<USER_POSITION_FLAG = {'y'}, RULE = {"=Count(DISTINCT{$<USER_POSITION_FLAG = {'y'}>} DLG_EVENT_ID)/Count(DISTINCT FIRING_RECORD) >= 0.50"}>} DLG_EVENT_ID)

Expression 2:
Count(DISTINCT {<RULE = {"=Count(DISTINCT{$<USER_POSITION_FLAG = {'y'}>} DLG_EVENT_ID)/Count(DISTINCT FIRING_RECORD) >= 0.50"}>} FIRING_RECORD)

Expression 3:
Count(DISTINCT {$<USER_POSITION_FLAG = {'y'}, RULE = {"=Count(DISTINCT{$<USER_POSITION_FLAG = {'y'}>} DLG_EVENT_ID)/Count(DISTINCT FIRING_RECORD) >= 0.50"}>} DLG_EVENT_ID)
/
Count(DISTINCT {<RULE = {"=Count(DISTINCT{$<USER_POSITION_FLAG = {'y'}>} DLG_EVENT_ID)/Count(DISTINCT FIRING_RECORD) >= 0.50"}>} FIRING_RECORD)

[cbaqir]

Thanks, my friend!