Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Issue: In bar chart,if i select particular dimension it shows 4 values.
Say,
SLC - 1.58
PNC - 2.14
IPQ - 1.4
NM -1.65
Issue Occurs when i select them individually. Values get floated upwards. e.g
This values vary after load.
Note: I am using 1 dimension (ProdName) and only 1 expression (1 expression for reference line, as per my knowledge it wont affect in this scenario)
Expression:
=sum({$<State_Cycle={'Approved'}>}AGGR(MAX({$<State_Cycle={'Approved'}>}Proof_Number), Proof_Number))
/count({$<State_Cycle={'Approved'}>} distinct Proof_Number)
Workaround
i have done workaround like checking expression in text box with hard coded value in above expression (e.g. ProdName={'SLC'}). Returns values after individual selection. (1.69)
Kindly help.
Regards,
Yudi
Can you please explain what your expression doing ?
Hey,
I got business logic for this KPI and i found the issue. Issue is at aggregated level.
Thanks.
Yudi