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

[Anonymous]

you Should need to use Date->'DD'as dimension

[sunny_talwar]

Are you trying to get rid of the extra days which doesn't have a bar?

[joris_lansdaal]

September has 30 days and I'm trying to get rid of day 31

[sunny_talwar]

May be try using Day(Date) as your dimension and see what happens

[NickHoff]

Day(MonthEnd(YourDateField))

[joris_lansdaal]

This is the end result I'm looking for. (Don't mind the table and meter...)

[sunny_talwar]

Did you try using Day(Date) as your dimension?

[joris_lansdaal]

Yes, Day(Date) is the used dimension

[sunny_talwar]

Can you check your calendar to check if September somehow have 31 days in the script