Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
All, I currently have a line chart that uses Date as the Dimension, 01/02/2011, 01/03/2011 etc.
My expression is using set anlaysis =date(Max({$<Date={'>$(vStartDate) <=$(vEndDate)'}>}Date)) which is grabbing for this example 12/31/2010 through 01/26/2011
My issue is that the chart renders all dates at the bottom 01/01/2008 - 01/26/2011 yet the data is only for 12/31/2010 through 01/26/2011
How can i make the dimension know i only want to show those above dates?
So that the chart below is only those dates
Here was the answer ![]()
=if(Date >= '$(vStartDate)',Date)