Crystal Reports:
Time Bands
Use a formula to create time bands for
your Crystal Report.
One of the students on our course was
working with call centre data. They wanted to summarize the data into 15
minute intervals. You can do this with the following formula:
Minute({timefield}) – Remainder (Minute({timefield}),15)
This will return values of 0, 15, 30 and
45. If you require other intervals, replace the 15 in the above formula.
Combine this with additional formulas to extract the date and the hour of the
call, and useful performance statistics can be created.
This article is copyrighted by
Crystalkeen, Mindconnection, and Chelsea Technologies Ltd. It may be
freely copied and distributed as long as the original copyright is
displayed and no modifications are made to this material. Extracts are
permitted. The names Crystal Reports and Seagate Info are trademarks owned
by Business Objects.
|
