Grouping on selected items

[cardimom]

Hi,

I am figuring out how many backups complete per hour. I am selecting on the completed backup time by between hours, but I have to keep changing the between time for every hour. I have three servers and it is taking me forever. Is there a way to display my results without having to change the time for each hour and have it grouped by the hour like 2pm-3pm, 3pm-4pm etc? I tried
{@lastBackupStatus} = "Completed" and
{machine.lastCompleteBackupTime} in DateTime (2003, 01, 27,12, 00, 00) to DateTime (2003, 01, 27,13, 00, 00)or
{machine.lastCompleteBackupTime} in DateTime (2003, 01, 27,13, 00, 00) to DateTime (2003, 01, 27,14, 00, 00)
etc, it displays the desired data,but I can't get it grouped the way I want.

Thanks,
Cardimom

 

[Reebo99]

You need to group by the value of a field, so i'd create a formula along the lines of :

if {machine.lastCompleteBackupTime} in DateTime (2003, 01, 27,12, 00, 00) to DateTime (2003, 01, 27,12, 59, 59) then "12:00 to 13:00"
if {machine.lastCompleteBackupTime} in DateTime (2003, 01, 27,13, 00, 00) to DateTime (2003, 01, 27,14, 59, 59) then "13:00 to 14:00"
etc

you can do multiple 'if' statements in a single formula.
This will give you a group value.
Juan
Scotland (currently)