Tag Archives: aggregation

Unexpected Results: Rounding

When using Tableau with different data sources, it becomes obvious fairly quickly that there are differences in what functions are available in one data source vs. another. For example, MEDIAN() and COUNTD() are functions not available in MS Excel, Access, or text data sources, but are available in Tableau Data Extracts and many others. This post goes into a case where the same function is available, but is returning different results than we might expect depending on context, and introduces a workaround. Continue reading

putting grand total together

Customizing Grand Totals – Part 2

In Part 1 of this series, I introduced one workaround to the issue of getting Grand Totals to show a different value from the Tableau defaults, by using two worksheets – one for the detail rows and one for the Grand Total row – on a dashboard. That method has a few limitations, the biggest being that it can’t handle Subtotals. Here, you’ll learn two additional techniques for customizing Grand Totals and Subtotals in a single worksheet, and their limitations: using MIN() and MAX() to test for the Grand Total row, and using a table calculation with a duplicated dimension. Continue reading

Grand Total Dashboard

Customizing Grand Totals – Part 1

Of all the questions on the Tableau forums, one of the more common ones is that people see the Grand Total and/or Subtotal rows – the ones created by going to the Analysis Menu then choosing Totals->Row/Column Grand Totals – not providing the results that they’d expect. And then, of course they’d like to have the total rows provide the desired results. For example, the measure might be a Count Distinct or an average, and the desired total is the sum of all the returned values and not what Tableau generates. Continue reading