Basically I have the following columns on the table feeding this graph (DeviceID=151, 152, 153, 154, 155, 156, 157, 158 total of Eight Line Series, one per device)
[TimeStamp] [DeviceId] [Volume]
Graph works nicely when lots of data is in the graph, even when one single data point is in the graph I see no problem, the graph breaks when I have TWO data points as shown in two_dp.jpg. So why is that? it works for one (one_dp.jpg), it works for three (three_dp.jpg), four (four_dp.jpg), five (five_dp.jpg), and so on, BUT NOT FOR TWO data points(8 per device, 16 total). what's going on?.
The Sample Data is given by:
Data shown in one_dp.jpg includes records whose timestamps are in [9:30am ... 9:31am> (doesn't include 9:31am)
Data shown in two_dp.jpg includes records whose timestamps are in [9:30am ... 9:32am> (doesn't include 9:32am)
Data shown in three_dp.jpg includes records whose timestamps are in [9:30am ... 9:33am> (doesn't include 9:33am)
Data shown in four_dp.jpg includes records whose timestamps are in [9:30am ... 9:34am> (doesn't include 9:34am)
Data shown in five_dp.jpg includes records whose timestamps are in [9:30am ... 9:35am> (doesn't include 9:35am)
The full graph (with lots of data point) is shown in lots-dp.jpg
This is how I built the graph: created data source with the fields mentioned above, dragged Graph wizard onto the detail
Section, dragged DeviceId on Series,
Dragged Volume on Values, Dragged TimeStamp on Categories. Clicked on Series, and set X = (Fields.TimeStamp)
Clicked on the horizontal Axis and change Scale from "Category Scale" to "DateTimeScale".
Hope you can help. I have been dealing with this issue for the last week. without any success.
[TimeStamp] [DeviceId] [Volume]
Graph works nicely when lots of data is in the graph, even when one single data point is in the graph I see no problem, the graph breaks when I have TWO data points as shown in two_dp.jpg. So why is that? it works for one (one_dp.jpg), it works for three (three_dp.jpg), four (four_dp.jpg), five (five_dp.jpg), and so on, BUT NOT FOR TWO data points(8 per device, 16 total). what's going on?.
The Sample Data is given by:
TimeStamp | DeviceId | Volume |
9/9/2013 9:30 | 151 | 19 |
9/9/2013 9:30 | 152 | 20 |
9/9/2013 9:30 | 153 | 20 |
9/9/2013 9:30 | 154 | 19 |
9/9/2013 9:30 | 155 | 0 |
9/9/2013 9:30 | 156 | 0 |
9/9/2013 9:30 | 157 | 0 |
9/9/2013 9:30 | 158 | 0 |
9/9/2013 9:31 | 151 | 22 |
9/9/2013 9:31 | 152 | 24 |
9/9/2013 9:31 | 153 | 24 |
9/9/2013 9:31 | 154 | 18 |
9/9/2013 9:31 | 155 | 0 |
9/9/2013 9:31 | 156 | 0 |
9/9/2013 9:31 | 157 | 0 |
9/9/2013 9:31 | 158 | 0 |
9/9/2013 9:32 | 151 | 21 |
9/9/2013 9:32 | 152 | 22 |
9/9/2013 9:32 | 153 | 21 |
9/9/2013 9:32 | 154 | 24 |
9/9/2013 9:32 | 155 | 0 |
9/9/2013 9:32 | 156 | 0 |
9/9/2013 9:32 | 157 | 0 |
9/9/2013 9:32 | 158 | 0 |
9/9/2013 9:33 | 151 | 25 |
9/9/2013 9:33 | 152 | 22 |
9/9/2013 9:33 | 153 | 21 |
9/9/2013 9:33 | 154 | 23 |
9/9/2013 9:33 | 155 | 0 |
9/9/2013 9:33 | 156 | 0 |
9/9/2013 9:33 | 157 | 0 |
9/9/2013 9:33 | 158 | 0 |
9/9/2013 9:34 | 151 | 22 |
9/9/2013 9:34 | 152 | 20 |
9/9/2013 9:34 | 153 | 21 |
9/9/2013 9:34 | 154 | 20 |
9/9/2013 9:34 | 155 | 0 |
9/9/2013 9:34 | 156 | 0 |
9/9/2013 9:34 | 157 | 0 |
9/9/2013 9:34 | 158 | 0 |
Data shown in one_dp.jpg includes records whose timestamps are in [9:30am ... 9:31am> (doesn't include 9:31am)
Data shown in two_dp.jpg includes records whose timestamps are in [9:30am ... 9:32am> (doesn't include 9:32am)
Data shown in three_dp.jpg includes records whose timestamps are in [9:30am ... 9:33am> (doesn't include 9:33am)
Data shown in four_dp.jpg includes records whose timestamps are in [9:30am ... 9:34am> (doesn't include 9:34am)
Data shown in five_dp.jpg includes records whose timestamps are in [9:30am ... 9:35am> (doesn't include 9:35am)
The full graph (with lots of data point) is shown in lots-dp.jpg
This is how I built the graph: created data source with the fields mentioned above, dragged Graph wizard onto the detail
Section, dragged DeviceId on Series,
Dragged Volume on Values, Dragged TimeStamp on Categories. Clicked on Series, and set X = (Fields.TimeStamp)
Clicked on the horizontal Axis and change Scale from "Category Scale" to "DateTimeScale".
Hope you can help. I have been dealing with this issue for the last week. without any success.