InetSoft Technology: Dashboard Aggregation Measures

Users can produce comprehensive real-time reports from InetSoft's award-winning dashboard software by incoporating specific aggregation measures. View the example below to learn more about the Style Intelligence solution.

BI DemoRegister

The table below shows the crosstab aggregation measures available for table grouping.


Aggregate Measure

 

Description

Sum

Displays the sum of the measure values for the given row and column headings

Average

Displays the average of the measure values for the given row and column headings

Max

Displays the maximum of the measure values for the given row and column headings

Min

Displays the minimum of the measure values for the given row and column headings

Count

Displays the total count of measure values for the given row and column headings. This represents the total number of records corresponding to the given row and column headings, and is the same value for any selected measure.

Distinct Count

Displays the count of unique measure values for the given row and column headings.


Correlation

Displays the Pearson correlation coefficient for the correlation between the measure values (for the given row and column headings) and the corresponding values in a second column, specified by the menu labeled 'with'.

Covariance

Displays the covariance between the measure values (for the given row and column headings) and the corresponding values in a second column, specified by the menu labeled 'with'.

Variance

Displays the (sample) variance of the measure values for the given row and column headings.

Std Deviation

Displays the (sample) standard deviation of the measure values for the given row and column headings.

Variance (Pop)

Displays the (population) variance of the measure values for the given row and column headings.

Std Deviation (Pop)

Displays the (population) standard deviation of the measure values for the given row and column headings.

Weighted Average

Displays the weighted average of the measure values for the given row and column headings. The weights are given by the corresponding values in a second column, which is specified by the menu labeled 'with'.
"The trend long term for performance management, even business intelligence, for that matter, is allowing us to do more. It’s allowing users to do more for themselves. Nowadays there's a buzzword for it: self-service BI. Certainly we’re a big proponent of that. But a key is to spend less time within the solution, and get more value. That ends up being the perennial challenge.

That’s why there is so much left to be done. With other BI solutions, they still require a fair amount of training to get up to speed on them. Therefore companies using them have needed fairly skilled individuals. They have had to invest in training programs to give them the skills. So that is changing somewhat with easier-to-use solutions like ours.

Instead of forcing user to adapt to the technology, we’re trying to make it as intuitive as possible, using point-and-click controls, going heavy with visualization as a means to explore the data, et cetera." - Mark Flaherty, CMO, InetSoft

Previous: Dashboard Crosstab Table