I am having a report which contains a line chart. I have tried different alternatives, but i could not get it solved.
There are many line in the charts representing Baseline,Actaul Weight, Gas Usage and so on.
Intially the report was having just a weeks data and everything was working great.Now the requirement is, to also display another line representing 16 weeks of prior data. I got the dataset prepared by doing the Union on the intially query with the 16 weeks of data.But, when i plot the graph it looks seperated as the lines are representing different years.
What i want to display is One line over the another.
Current week data and over the same line i want to represent the 16 week data (So it will be easy to look for comparision).
So i realised i have to group by week number inorder to get one line over the other[ As years are different]. But the lines don't get displayed at all, if i group by weeknumber.So, can you please help me on figuring out ,how to do this?
Line Chart with
Drop Category Fields : WeekNumber
Drop Data Fields : Different Calculated sum columns.
Please help me if anyone can.