I'm asked to make a Timeline Bar Chart with SSRS 2012. There should be 1 chart per day/employee, and this chart should have a x-axis of 1440 minutes (or 24 hours). The bar should have 2 different colors, which represent the 2 different status of the employee (working / not working).
The table from which I get the data has following columns:
Starttime_working (datetime), Endtime_Working (datetime), Duration_worktime (int), Duration_till_next_worktime(int)
There could be many of this entries per day for one employee. The duration columns are seconds.
I think I have to transform this data to get a result like:
2013-03-02 16:52:00 - working 2013-03-02 16:53:00 - working 2013-03-02 16:54:00 - working 2013-03-02 16:55:00 - working 2013-03-02 16:56:00 - not working 2013-03-02 16:57:00 - not working
Is this the right data format for generating a Timeline Chart? Are there other ways to get what I want? Any general tips for creating a timeline-chart with ssrs?