on 09-16-2009 11:34 AM
Hi,
I need to have a cross tab that shows total of checks for every four hour, on its option I could only find for every hours. Any idea on how I could get a row for each 4 hours from 00:00:00 of each day? I use crystal XI
Many thanks,
Andreia
You will need to create your own grouping formula.
For the purpose of this discussion the formula name is for example if hour({DATE-TIME}) in [1,4] then 1 else if hour({DATE-TIME}) in [5,8] then 2 else if hour({DATE-TIME}) in [9,12] then 3 else if hour({DATE-TIME}) in [13,17] then 4 else if hour({DATE-TIME}) in [18,21] then 5 else if hour({DATE-TIME}) in [22,00] then 6 you then group off this formula. Your group names will be 1, 2, 3, 4, 5, 6 if you want those names to be more meaningfull then write a second formula. For the purpose of this discussion the formula name is if = 1 then "00:00 to 04:00" else
if = 2 then "05:00 to 08:00" else (etc....)
you can then change the group, and select options, select use a formula as group name, then select the formula 4hourname
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
8 | |
8 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.