Advanced Report Design
CentreVu CMS Custom Reports
Repeating Aggregate Function Values
6-33
Repeating Aggregate Function Values
6
Normally, a field (or bar) that contains an aggregate function (
sum, max,
min,
or
avg
) displays just one value. This is true no matter what your
“Select rows where” criteria are. Therefore, you would normally select
“discrete” as the field/bar type in the row search ID assigned to aggregate
functions.
However, you may at times want
CentreVu CMS to display multiple values
for an aggregate function. In historical reports only,
CentreVu CMS can
display multiple values for an aggregate function. For
CentreVu CMS to do
this, the aggregate function must share a row search ID with one or more
fields that do not have an aggregate function.
For example, you may want a report (
) that shows the maximum
(max) ACD calls in an interval for each of a variety of splits.
Figure 6-11: Repeated Aggregate Function Report
Date: 07/01/93
Max ACD Calls-
Split
Morning
1
652
2
491
3
297
Summary of Contents for CentreVu
Page 16: ...Preface CentreVu CMS R3V5 Custom Reports Related Documents P 10 ...
Page 44: ...Getting Started CentreVu CMS Custom Reports Deleting a Custom Report 2 10 ...
Page 140: ...Completing Your Custom Report CentreVu CMS Custom Reports Running Custom Reports 5 22 ...
Page 178: ...Database Items and Calculations CentreVu CMS Custom Reports General Information A 2 ...
Page 188: ...Glossary CentreVu CMS Custom Reports GL 10 ...
Page 198: ......