Forum Discussion
Vertical Line Reference to another table with multiple dates
I'm trying to create a benchmarking visual that can toggle between different location's metrics while showing a vertical "benchmark" based on another table with all of the benchmark dates.
I have a dataset with different metrics and a date field. I have another table with locationsand a benchmark date. How would I go about building a visual to show metric trending and a benchmark that will toggle between locations when I select a different location?
Let me know if any additional information or context is needed. Thank you!
2 Replies
amcgrail , If you have a continuous axis, You can use X-axis constant line, there using fx you can use a measure
That is one part I've been getting stuck on is adding a measure to accurately show the benchmarking dates when selecting a different location. If I had a chart like the one below, what type of measure would I create to insert into the x-axis constant line fx? That way when I select a new location, the benchmark changes on the chart.
Abbreviation Go Live Date ABC 3/1/2023 RED 5/1/2021 DEW 7/1/2022 PLS 7/1/2022 ERS 4/1/2020 WWW 10/1/2023 MLS 6/1/2023 YTD 10/1/2023 RSP 10/1/2022 CCS 6/1/2021 PPW 6/1/2023
