Insights in visualizations for aggregation types

Insights in visualizations are generated depending on the type of data aggregation.

The Show average value insight is generated for the following aggregation types:
  • average
  • count
  • max
  • min
  • sum
The Show meaningful differences insight is generated for the following aggregation types:
  • average
  • count
  • sum
No Insights are generated for the following aggregation types:
  • calculated
  • count distinct
  • none

The following table lists statistical analyses that are performed for insight types depending on aggregation function.

Data aggregation function Insight type
Show average value Show meaningful differences
max, min Mean No insight
count, sum Mean One- or two-way Chi-Square
average Weighted mean

One- or two-way ANOVA

Mean-based unusual cell detection

calculated, count distinct, none No insight No insight