Reference line that changes based on what dimension is chosen
Hello all,
so I have a chart with three alternative dimensions (Year/Month/Week), where I want to have a reference line that changes based on what dimension is currently active in the chart. For year i want to show 10 000, for month 800 and for week 200.
Not sure this is possible when using alternative dimensions. It would be easier if you use an variable dimension with : pick(match(YourVariable, 'Year', 'Month', 'Week'), Year,Month, Week). You could used the pick line formula : pick(match(YourVariable, 'Year', 'Month', 'Week'), 1000 , 800, 200)
Let me know if you need more precise description. And if this answer is fittting your requirement, you can tick it as a solution.
