Add a vertical line on the chart between actual and forecast dates

newbee · 2022-10-19T13:38:09+00:00

There was an error rendering this rich post.

I have a chart with x-axis = dates and y-axis= sales. Want to add a line between actual date and forecast date to show the left part belongs to actuals and the right part belongs to the forecast. Additionally, if I can label the left space as actuals and right space as forecast that would be great. Any suggestions?

Find more posts tagged with

Accepted answers

ST_Superman

This can be done with "Trellis/Tiered Date Settings" in the chart properties section of a card. First you will need a field that defines the two (or more) categories. In your example, "Actuals" vs "Forecast". This could even be a beastmode:

CASE WHEN `DATE_FIELD` < CURDATE() THEN 'Actuals' ELSE 'Forecast' END

You would then use this field as "Category 2".

All comments

ST_Superman

CASE WHEN `DATE_FIELD` < CURDATE() THEN 'Actuals' ELSE 'Forecast' END

You would then use this field as "Category 2".

newbee

@ST_-Superman-_ Thank you so much! Works like a charm!! Save me so much time of manual work.