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
Quote from: inu on 24 Aug 2016 03:35:10 AM
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.
Quote from: MFGF on 25 Aug 2016 03:54:42 AM
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