Diagram w. fixed X-Axis and Data Y-Axis
Hi, I need a diagram serie which show ALL the days in a month on the X-axis (1-31),
AND bars for the days where there is data.
How do I do that?
My simplyfied query looks a like this:
Select datePart( d, s.thedate ), TotalSaleThisDay
From Sales_Table
Where S.thedate between '01-oct-2005' and '31-oct-2005'
AND bars for the days where there is data.
How do I do that?
My simplyfied query looks a like this:
Select datePart( d, s.thedate ), TotalSaleThisDay
From Sales_Table
Where S.thedate between '01-oct-2005' and '31-oct-2005'