◆ Measuring aggregated data for analysis

Measurement functions and attributes identify how to analyze the data within each aggregate, such as categorical bars, or numeric or time ranges, in aggregated charts. 

The measurement setting is the basis of trend analysis across the dataset including record group comparisons. Keshif automatically adjusts analytics settings according to the measured data features. 


Measurement functions

Count function

  • Count function is the default and basic function for analysis. It counts the number of records (data rows) within each aggregate.

Sum function

  • Sum function can be used with a numeric attribute, for example to measure total people affected, total votes, and total cost.

Average function

  • Average function can be used with a numeric attribute, for example to measure average age, average cost, or average temperature.

Controlling measurements

Selecting aggregate measure function and attribute

  • Learn how to select the measure function (count/sum/average) and the base attribute (for sum/average functions)