Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Hope the following will make sense.
I am using a line chart in order to present count of actions by their Monthname, current definition:
but the full range of dates is not relevant, i am interesting that the visualization will contain only the last 6 months.
i want to limit this already in the set of the visualization.
imagine that i have the following column:
date
03/02/2016
06/05/2016
09/05/2016
02/03/2016
06/01/2016
22/05/2015
15/11/2015
since today is 09/05/2016 i am not interested to see all the values of the dimension, only of the last 6 months (only from November 9th 2015 and afterwards..)
Thanks!
Tal
hi Sunny stalwar1 ,
please check the attached sample file and let me know if this works out using this data set..
=Count({<date = {"$(='>' & Date(AddMonths(Today(), -6), 'DD/MM/YYYY') & '<=' & Date(AddMonths(Today(), 0), 'DD/MM/YYYY'))"}>} date)
Thanks!
Tal
Hi,
the problem was with the date format:
instead of DD/MM/YYYY, it was MM/DD/YYYY
thanks!