topic Re: Reference lines on chart in % terms in App Development

Reference lines on chart in % terms

jlampard40 — Mon, 20 Jun 2022 12:11:42 GMT

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!

Re: Reference lines on chart in % terms

jlampard40 — Tue, 21 Jun 2022 08:32:52 GMT

@vinieme12 - are you able to help with this at all?

Re: Reference lines on chart in % terms

vinieme12 — Tue, 21 Jun 2022 09:38:31 GMT

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)