Display a dimension based on user selection

[has35526]

I have  a table as a chart and I want show a different dimension based on user selection.

For ex: if a user picks any date before 06/30/23 I want to display dimension A otherwise Dimension B.

[Zapparoli · Accepted solution]

Hi @has35526 

You can do this on your script like:

If(YourDate <= '06/30/23' , DimensionA, DimensionB) as NewDimension

Then use the NewDimension in your chart.

You can do this directly in the Chart as well, but when the user selects a value it will show "If(YourDate <= '06/30/23' , DimensionA, DimensionB)" in the selections filter.

Hope this helps

-Zapparoli

https://www.youtube.com/@ZappaAnalytics