Displaying totals

A summary of your data can be useful. You can add column totals to your report by clicking the Totals checkbox in the upper right, then re-running the report. If your report contains more than one dimension, you can choose to include Subtotals in your table visualization.

You can also add row totals to your report, but only if you’ve added a pivot to your report. If you’ve added row totals, and your query exceeds any row limit that you’ve set, you will not be able to sort the Row Totals column (although you can sort dimension and measure columns as normal). This is because you might be missing rows in your data that should be included in your totals. If you run into this issue, you can try increasing your row limit (up to 5,000 rows).

There are some cases when totals won’t be available:

  • Column totals are available only for measures and table calculations, not for dimensions.

  • Row totals are available only for measures, not for table calculations or dimensions.

  • Certain types of columns won’t be totaled, because of database limitations or because the value would not make sense as a total. For example, you can’t add together a list of words.

Additionally, there are some things to keep in mind about how totals work in certain situations:

  • Columns that count unique items might not add up as you expect, since the same item might show up in several categories, but only be counted as one unique item in the totals.

  • Some table calculations that perform aggregations, such as calculations using percentile or median, might not add up as you expect. This is because table calculations calculate totals using the values in the total row, not using the values in the data column.

  • If you’ve filtered your report by a measure, totals may appear to be too high. However, in actuality, what you’re seeing is a total for your data before the measure filter is applied. In other words, the measure filter may be hiding some data from your report, even though that data is included in the total.

  • If you’ve used totals with merged results, Centricity calculates totals on each of the component queries and uses those totals in the merged result. Therefore, totals may appear too high, because what you are seeing are totals calculated before the results were merged. One way to avoid this is to align the filters on each query.

  • Similarly, if you’ve placed row or column limits on your report, and your report exceeds that limit, totals may also appear to be too high. However, what you’re seeing is a total for your data before the limits are applied. In other words, the limits may be hiding some data from your report, even though that data is included in the total.

In the situations described in the third and fourth bullets, above, it is possible to calculate totals only for the data you can see. To do so, you’ll need to use a table calculation, explained later on this page. For a column total, use sum(${view_name.field_name}). For a row total, use sum(pivot_row(${view_name.field_name})).



 

 

More questions about Centricity? Check out our website or talk to our Support Team.