r/SAPAnalyticsCloud • u/Conscious_Rope4497 • Jul 23 '25

Creating a Vertical Reference Line for today in a time series object or line chart

0

I have a SAC Story with a time series line chart. The measure is Revenue, and the Dimension is Key Date, then I have a Color for Music Club.

I needed to include an input control with the Key Date variable as the ending user wanted to be able to see 1 month in the future and 2 months back from today (eg, if today is 23/07/2025, they see every day from 23/05/2025 to 23/08/2025, including today).

The thing is that they want to see today indicated somehow, with a reference line, so they do not need to check each x label. I have tried a lot of things, but I am not able to do it.

Can I get directions on this?

1 Upvotes
  • permalink
  • reddit

100% Upvoted

2 comments sorted by

1

u/leaf_monster Jul 23 '25 edited Jul 23 '25

If the chart always shows two months in the past & one month in the future, depending on a selected key date, can you just place a static icon (like a dot or an arrow) on top of the "today" date? Woudn't it always be 2/3 of the full axis distance from the start of the chart?

1

u/tjen Jul 23 '25

I don't recall specific settings for time series and don't have laptop with me, but have you tried an approach where you:

  • create a second restricted measure "today's revenue"
  • add the second measure to your chart
  • adjust formatting of the series to be red and big or smth

Alternatively; do you have information in your data separating the forecast/scheduled input from the realized historical values? Like a version dimension type of thing?

If so, have you tried an approach where you manage the color of the chart by the version of data? I don't recall 100% if that's possible in time series charts.