Adding a line on bar-chart
Hello, I have the following bar chart, it has some metrics and a target line that was defined under the "Scale Marker" section. I would like to add another point of data in the form of a line but I am not sure how to.
Ideally, the card will include this other point as below: (sorry about the ghetto and bad drawing)
The line in question to be added is a Beast Mode calculation, basically an accumulation of a specific metric:
CASE WHEN `Metric` = 'C' THEN sum(sum(`Value`)) over(partition by YEAR(`Date`), `Metric` order by `Date`) ELSE 0 END
Below is a sample of how the raw data looks like for the screenshots.
If anyone has an idea it will be really appreciated. :)