Mapping Aggregation Functions from Data Sources to Report Studio |
The summary functions available in Report Studio reflect summary functions supported by relational and dimensional data sources. The following table shows how summary functions in data sources are mapped to Report Studio.
|
Data source |
Report Studio |
|
None specified, or none |
None |
|
average (avg) |
Average |
|
count |
Count |
|
count distinct |
Count distinct |
|
maximum (max) |
Maximum |
|
minimum (min) |
Minimum |
|
median |
Median |
|
standard deviation (stddev) |
Standard Deviation |
|
sum |
Total |
|
variance (var) |
Variance |
|
count non zero |
Automatic |
|
average non zero |
Automatic |
|
external |
Automatic |
|
any |
Automatic |
|
calculated |
Automatic |
|
unknown |
Automatic |
|
first_period |
Automatic |
|
last_period |
Automatic |
The following summary functions exist only in Report Studio. There is no corresponding summary function in data sources.
|
Report Studio |
|
Automatic |
|
Calculated |
|
Summarize |
|
Not Applicable |
Related Topics: