Hello Experts Exchange
I have a SSRS report where I select a date range and it give me a line chart of the sums for each day.
Here is the query I use to get the data.
Select dateadd(DAY,0, datediff(day,0, Date)) as Date,Sum([Total Lost Hours]) as Total_Lost_Hours
Where date >= @StartDate AND date < @EndDate
Group by dateadd(DAY,0, datediff(day,0, Date))
order by dateadd(DAY,0, datediff(day,0, Date))
I want to be able to set the Interval of the Chart Axis to the start of every month. Please take a look at my attached file.
At the moment the Chart Axis is a bit random I want it so that at the start of every month a new label is shown.
Is this possible to do in SSRS?