Filter criteria

[varunreddy]

Hi all,

I have created the calculation dimension.

Calculation Used:

aggr(only({<[As of Date]={'$(vmaxweek)','$(vprevWeek)'}>}[As of Date]),[As of Date])

vmaxweek - =max({1<[Pull Type]= {'W'}>}[As of Date])

This always stores the latest available date

prevWeek - =max({<[As of Date] -= {'$(vmaxweek)'},[Pull Type]= {'W'}>}[As of Date] )

This will pick and store the date on selection and displays the previous date availbale for the most available date by default

When nothing is selected the report  is showing bars for latest date and the previous available date. The problem is, when I select the date filter, the bar is showing only one value. the bar is not showing latest date vailable.

Can anyone guide me through this process?

Thanks in advance!

Regards,

Varun

[varunreddy]

Aggr dimension

[sunny_talwar]

See if adding the Primary dimension to your Aggr() function helps:

Aggr(Only({<[As of Date]={'$(vmaxweek)','$(vprevWeek)'}>}[As of Date]),[As of Date], PrimaryDimension)

[varunreddy]

Sunny I found alternative. I changed the style of the graph. I think it was not showing because of too many values and it was not having sufficient space to display.

Thanks for your help.

Cheers!