How to show 6 months data using the set analysis in the dimension

[varunreddy]

Hi All,

I am trying to create line chart. Two dimensions and one expression.

Dimensions:

Date and GB/GF

Expression

Count(Rule Name)

This is working fine.

Now I am trying to show only 6 months of data out of all dates available. I am using below expression in the dimension to display 6 months data but I am not seeing the dates. Can someone please help?

=Aggr(Only({<Date = {'>= $(=vPrevious5MonthYear) <= $(=vCurMonthYear)'}>}Date),Date)

Below is the graph. I don't see Dates.

Cheers,

Varun

[CarlosAMonroy]

Ok, but Date comes as JAN 2018 or 9/01/2018. Makes sense that you want to convert it, but maybe is not the proper format.