Subset of values in Chart Dimensions (Filter Chart dimensions)

[#1]

Hi,

I have a chart that has 3 dimensions. One dimension has to dynamically display values for the next 21 days based on today's date. Today's date is stored in a variable.

Can someone guide me as to how to filter the Time field values (displayed as dimension in charts) based on a variable value?

Sai

[Oleg_Troyansky]

You can replace your Dimension with the calculated Dimension and use IF condition to limit your dates:

if( date <= $(vToday) + 21 and date >= $(vToday), MyDimension, null())

notice that vToday is the variable. You also need to check "Suppress when null" checkbox.

good luck,

Oleg