how to display days in x-axis in chart

[inu]

Hi

I have to show 4 weeks in such a manner that

1-9(Week1)
10-16(Week2)
17-23(Week3)
24-end of month(week 4)


In x-axis i have to display 9 days of the selected month.

Can you please tell me the logic how to display 9-days


thanks
inam

[MFGF]

Hi

I have to show 4 weeks in such a manner that

1-9(Week1)
10-16(Week2)
17-23(Week3)
24-end of month(week 4)


In x-axis i have to display 9 days of the selected month.

Can you please tell me the logic how to display 9-days


thanks
inam

I don't understand the question, sorry. What does 9 days have to do with splitting up your data into Weeks 1 to 4?

MF.

[inu]

I don't understand the question, sorry. What does 9 days have to do with splitting up your data into Weeks 1 to 4?

MF.

I attached the mock up..but instead of 7, 9 days should display. i created 4 queries , each for every week. and did union.

Thanks