Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table of Kpi's that each has different values, I need to filter the UnitCd who have different values in each kpi.
For example: I want to get all the UnitCD that have value for Kpi= SC120013 between 20 to 60 and
for Kpi = SC1200141 have a value of between 5 and 16
And for Kpi = SC120051 have equal value 3
Pls Help
Try nested IF statement
=if(KPI>=20 and KPI<60,UNITCD,0)
Hi ofra,
for just one KPI this is "relatively easy": You have to use IntervalMatch().
- Process your data in the script to have the correct values of that KPI for every UnitCD (say, that's a field
>>> KPIvalue <<<
- Load an Inline table with the intervals you want, using >>> IntervalMatch(KPIvalue) <<<
For several KPIs, you would have to use set analysis, specifying a lower_ bound and an upper_bound for both/ all of the KPIs in question and use a simple COUNT() as expression (y-axis) in your chart
=> You can, I guess, replace parts of your set_expression with fields/ variables that the user can select.
HTH
Best regards,
DataNibbler
I have all of the UnitCD that the value of their numerator for each Kpis is different.
Pls see the attachment
I have more than 200 Kpis how can i manage this with variables?