InSight columns aggregations

[Quali-Community]

In Prism Bi studio each column could be aggregated, based on its type.

The InSight engine generates aggregation for each column.

The possible aggregation types are:

Aggregation	Explanation	Applicable Fields
Sum	Calculates the total of values	Fields containing numeric values
Average	Calculates the average value	Fields containing numeric values
Minimum	Calculates the minimum value	Fields containing numeric values
Maximum	Calculates the maximum value	Fields containing numeric values
Count	Counts the number of unique values	All Fields (date, string, numeric)
Count Duplicates	Counts the number of rows (all values)	All Fields (date, string, numeric)

 

---

 Aharon Shachar (Aharon.S) - 05/28/2013 12:01 PM

·  2749  ·