Thanks for taking the time to answer.
I have looked at the video link you gave me and its not what I am after.
I am looking to display a horizontal line which shows when a device is on and a gap in the line to show when its off.
The problem I have it that the data I have is not all in one record. its one record for ON and a separate record for OFF.
If the ON and OFF time-stamp is in the same record I would use a datediff and get a duration and the line would represent the duration but I don't have the ON and OFF timestamps in the same record.
Just a couple of slight tweaks to Joe's workbook, which might be helpful. I use this sort of representation extensively - often for exactly what it looks as if you are doing (I assume GPRS means this is cellular data services).
It's worth turning on mark borders to highlight places where two "on" periods occur in quick succession - otherwise you can think you have a continuous "on" period as the marks run together, but with very short bars the borders an end up swamping the mark colours. Here is the same snippet of Joe's chart with no border, a black border and a white border. Note how the white border can completely lose small marks.
It may also be worth grouping all the services for a source together, to highlight concurrent service usage.
state RL.twbx.zip 346.1 KB
Thanks Guys. This seems to be exactly what I am looking for.
I have one more question if that's OK:
I have more sources of data that I would like to add to this chart so I can compare.
This data originated from different equipment and is not formatted like the data I originally attached to this question.
This data has a start date/time and a duration in seconds.
How would I add this to the above as, lets say, a 'service 4' and 'Service 5'.
I have attached an example of the data.
The easy way is to produce a second, equivalent, chart and combine them on a dashboard. The way your additional data is formatted makes it much easier than the original (no need for table calculations to correlate times between rows). The only trick to remember is that the duration needs to be expressed in (fractional) days - since the timeline is a datetime which is represented internally as fractional days. I've attached a quick example.
If you want to combine them both on the same chart then you really need to transform one or other data set so that they are both in the same structure, and then combine the raw data. Depending how you get your data and how it is stored (text file, database, etc) there are a number of ways to do that.
Additional Timeline.twbx.zip 29.8 KB