topic Re: reference line for events uploaded from a table for a time series in App Development

reference line for events uploaded from a table for a time series

charlie03 — Mon, 18 Dec 2023 15:26:09 GMT

Hi,

I have a time series plotted in a line chart with sales over time (on a weekly /monthly basis). Separately, i loaded a table with dates and events (i.e. product launches, campaigns etc.) How can I add ALL the events at once in the time series? So far I can only do it "manually", by adding one event at a time as a dimension reference line.

Thanks!

Re: reference line for events uploaded from a table for a time series

Daniel_Pilla — Mon, 18 Dec 2023 18:54:00 GMT

Hi @charlie03 ,

There is no way to dynamically populate reference lines from the load script via the "Add-ons" panel. That said, you can load them into the chart as a secondary expression then set their representation to "Bar" in a combo chart. With some fiddling, I was able to get the below. Granted, you won't get the labels on top, but it will be cleaner this way if you have a lot of events. Would something like this work for you? Bonus, the events are then selectable as well.

Cheers,

Re: reference line for events uploaded from a table for a time series

charlie03 — Tue, 19 Dec 2023 06:58:40 GMT

Hi,

Thanks for your quick suggestion!

It's not an ideal solution, but somehow it works together with a dual() expression to show the event name.

Thanks again!