What's New For February 2018: Calculations For Table Insights

Bryna Gleich

In Analyze, Insights, you can design tables to view measures and attributes as rows and columns, like a spreadsheet. When you design a table with at least one measure and attribute, you can now apply a calculations — such as sum, average, or median — to a column's values. To calculate a column, hover over the column, select ∑, and choose the calcuation to apply.

• To apply the same calculation to multiple columns, hover over the calculation's row under the column, and select Add (the plus sign).
• To apply the same calculation as the column's measure to the overall measure instead of the column's values, select ∑, Rollup (total). For example, with a column of averages, Rollup (total) provides the average of the overall measure, not the average of the column's averages.
• To remove a calculation from a single column, select its X. To remove a calculation from all columns, select the row's X.