Add Reference Line to Chart based on formula

[CB308]

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?

[anthonyj]

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