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

newbee
newbee Member
edited October 2022 in Charting
SKETCH 221019.PNG

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?

Best Answer

  • ST_-Superman-_
    ST_-Superman-_ Coach
    Answer ✓

    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".

    image.png



    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman

Answers

  • ST_-Superman-_
    ST_-Superman-_ Coach
    Answer ✓

    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".

    image.png



    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
  • newbee
    newbee Member

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

Categories