Dynamic Vertical Reference Line

milig
New Member

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

 

0 1 1,128
1 REPLY 1
Top Labels in this Space