Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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,
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,
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!