Limiting Dimensions Values

[Anonymous]

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:

• Dimension: Monthname(date)
• Messure: Count(date)

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

[Anonymous]

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

[Anonymous]

Hi,

the problem was with the date format:

instead of DD/MM/YYYY, it was MM/DD/YYYY

thanks!