Hi,
I'm not sure if this is the right forum, anyway here goes:
I have created reports in crystal reports. I use a line graph to show the Time vs. Usage report.
Ideally, the database should look something like this,
TimeStamp (x-axis) Usage (y-axis)
09-01-03 00:00 10329887
09-01-03 01:00 90097777
09-01-03 02:00 83893444
09-01-03 03:00 12334445
09-01-03 04:00 23234994
..
The data is collected through an agent. Sometimes the agent does not collect certain time periods. Observe the TimeStamp field.
TimeStamp Bytes
09-01-03 00:00 10329887
09-01-03 02:00 90097777
09-01-03 03:00 83893444
09-01-03 05:00 10323222
09-01-03 08:00 13243445
09-01-03 09:00 83893232
..
Now when I graph these data for a specific time frame (lets say last 12 hours), crystal reports would just skip the missed time periods and connect to the next entry. Which at first glance at the chart, would show a smooth trend (quite deceiving).
From exmaple above, I would also want my chart to automatically show a time period for 1AM data (or other missing entries like 4AM, 6AM, etc.) even though there was no entry in database, basically put a zero value in Usage field (y-axis).
By doing this, I can see which time periods that have no data/entry in database and manually force the agent to upload the data.
How can I format the chart to show a consistent time period even though there were no entries for certain time periods? Or can anyone show a sample formula for a consistent time period? Is there a command in Crystal that would automatically do this?
Feel free to email me for more details. I can send a sample report for a more clear picture. Thanks in advance.
cestonina@yahoo.com
Regards,
Topy
I'm not sure if this is the right forum, anyway here goes:
I have created reports in crystal reports. I use a line graph to show the Time vs. Usage report.
Ideally, the database should look something like this,
TimeStamp (x-axis) Usage (y-axis)
09-01-03 00:00 10329887
09-01-03 01:00 90097777
09-01-03 02:00 83893444
09-01-03 03:00 12334445
09-01-03 04:00 23234994
..
The data is collected through an agent. Sometimes the agent does not collect certain time periods. Observe the TimeStamp field.
TimeStamp Bytes
09-01-03 00:00 10329887
09-01-03 02:00 90097777
09-01-03 03:00 83893444
09-01-03 05:00 10323222
09-01-03 08:00 13243445
09-01-03 09:00 83893232
..
Now when I graph these data for a specific time frame (lets say last 12 hours), crystal reports would just skip the missed time periods and connect to the next entry. Which at first glance at the chart, would show a smooth trend (quite deceiving).
From exmaple above, I would also want my chart to automatically show a time period for 1AM data (or other missing entries like 4AM, 6AM, etc.) even though there was no entry in database, basically put a zero value in Usage field (y-axis).
By doing this, I can see which time periods that have no data/entry in database and manually force the agent to upload the data.
How can I format the chart to show a consistent time period even though there were no entries for certain time periods? Or can anyone show a sample formula for a consistent time period? Is there a command in Crystal that would automatically do this?
Feel free to email me for more details. I can send a sample report for a more clear picture. Thanks in advance.
cestonina@yahoo.com
Regards,
Topy