Defining data in chart

[Seven777]

newbie alert.........

Using CR8 I am trying to create a chart that will graph machine downtime grouped by hours of the day. The end result is that I want to be able to see visually, at what time of day the equipment is not active. I have been trying different items for about 2 days but have not been able to figure this out myself.

database records contain info on how long the equipment was down and at what time it went down. the time is stored in military format but is not rounded to the nearest hour. it may contain values like 07:04 or 17:23. the downtime is stored as a whole number such as 15.

how do i create a chart that will graph the downtime in 1 hour groups?

for example,

over the past month, we had these figures....

7:00am - 8:00am 200 minutes downtime
8:00am - 9:00am 7 minutes downtime
9:00am - 10:00am 13 minutes downtime
etc....

this would indicate that we have the most downtime between 7:00am and 8:00am (i.e. at shift startup) and we can react accordingly, possibly justify additional manpower during these peak hours of downtime.

any help would be greatly appreciated.
Seven

 

[HowardHammerman]

I assume you are selecting data for a particular day. if your date and time are in the datetime format you could create a formula using:

DatePart ("h",{table.field} ) to extract the hour and then use that as one axis.

Or, if it is a string field you could use:

{table.field}[1 to 2] to extract the hour.




Howard Hammerman,
Crystal Reports training, consulting, books, training material,support. HammerLauch program runs reports without Crystal
howard@hammerman.com

http://www.hammerman.com

800-783-2269