Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all - I have a chart which shows our KPI in % terms, as follows:
=Count([REPKPIData_EventKey])/ Count (TOTAL <REPKPIData_MonthReported> {<[REPKPIData_KPI]>} REPKPIData_EventKey)
There are multiple pathway fields which can be selected (REPKPIData_Pathway) and the data will change on the chart. I need to show different reference lines on the chart, depending on what the user selects using the above pathway field. So, if user selects '2WW' I need it to show a reference line at 90%. If they select 'CT & MRI OP' I need it to show a reference line at 75%...and so on.
I've used the following formula, but it doesn't seem to work. Any ideas?
If(GetCurrentField(REPKPIData_RepPathway) = '2WW', 90)
Many thanks all!
@vinieme12 - are you able to help with this at all?
Add another measure which will act as a trendline instead of adding Trendline to a measure
Try with Pick(Wildmatch(
=pick(wildmatch(REPKPIData_RepPathway,'2WW','CT & MRI OP')+1,DEFAULT%,0.9,0.75)