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?
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.
Retrieving data ...