Hi, I want to make a vertical reference line for a specific date in a line graph (pivot) but I want to be able to change this specific date (not inside the code of the table dimension code because I have many graphs). Is there a way to make a dynamic vertical reference line? I used the following to make a vertical line but still need a way to make it dynamic. Maybe with a parameter that I could complete in the filter section?
if(
to_string(${table.date}) = "2021-07-20"
,
max(if(pivot_index(${table.sales},1) > pivot_index(${table.sales},2), pivot_index(${table.sales},1), pivot_index(${table.sales},2))), null
)
Thanks