topic Re: Add Reference Line to Chart based on formula in App Development

Add Reference Line to Chart based on formula

CB308 — Mon, 25 Oct 2021 16:01:14 GMT

I am trying to add Reference Lines to my Line Chart.

My chart is by Date, and I want to show a reference line on dates where the visit ended as in my image below.

When I use formula If (Field = 1, %Date) nothing shows.

How do I display the date for the date the visit ended?

Re: Add Reference Line to Chart based on formula

anthonyj — Tue, 26 Oct 2021 03:01:33 GMT

Hi @CB308 ,

The reference line needs to resolve to one value which your code may not be doing. If "Field = 1" is the condition for the allocation of the date, can I suggest:

max({$<Field={1}>}%Date)

I hope this helps.

Thanks

Anthony