Set Analysis - Graph

[joris_lansdaal]

Hi all,

I've got a challenge that I'm not able to tackle. Below graph shows the volume progress over the month compared with last month and a lineair projection. The challenge is that the the 'Day' axis always shows 31 instead of the number of days in the currenth month.

When I select 'Sep' in the dimension Month the graph obviously will show 30 days. So I tried below set analysis with

=Sum({<CurMTDFlag={1},Month={"=Month(maxDate)"}, Local_Flag={1}>} $(VarFact)), but that doesn't do the trick.

Should I use the Day dimension or is my set analysis incomplete/wrong?

Thanks

[joris_lansdaal]

That's all ok. I doubled checked already.

[sunny_talwar]

Would it be possible for you to share a sample to see the issue?

Preparing examples for Upload - Reduction and Data Scrambling

[joris_lansdaal]

Here's the example. Thanks for the link!