Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a problem. I have a field loaded from an excel file with a list of dates in the following format ----> 12/1/2013
I am using this date field in a Line chart as a calculated dimension and Sales as expression.
Out of all the dates in the field, I only want a selected range of dates to display Sales for that range of dates on the line chart.
The field has dates for the year 2013 and 2014, but I just need the date range of 11/1/2013 - 3/1/2014. Thanx.
Use this in as a set analysis statement in your expression
{<Date = {">=11/1/2013<=3/1/2014"}>}
If the above two dates are dynamic, then probably you need to use two variables which the user can have the ability to select and then you will need something like this:
{<Date = {"$(='<=' & $(vStartDate) & '>=' & $(vEndDate))"}>}
I hope this guides you in the right direction.
Best,
Sunny
calculated dimension
=if(Date<='02/02/2014' and Date>='01/01/2014', Date)
suppress when value is null
Try this one
{<Date = {"$(='<=' & $(vStartDate) & '>=' & $(vEndDate))"}>}