View the original community article here

Last tested: Sep 4, 2019
 

Problem

I want to only show my totals row in the visualization, not any of the other data.

Workarounds

Not janky: change grouping

The easiest workaround is to change your grouping. Totals are just the measure values run without grouping by any dimensions. So if you remove the dimensions from your explore, then the measure values should show you the same value as the total.

Mildly janky: use table calcs

You can usually get the total to show up in its own row by using table calcs. Just use {fieldname:total} for the field which you want to show the total for. Then you can "hide from visualization" for all of the other fields so that the total is the only field you see. You might then want to limit the displayed rows to 1.

Very janky: limit displayed rows

This is an unsupported workaround, and while it is very cool it is not guaranteed to always work. Also, it only works with Table type visualizations. First, enable "Limit Displayed Rows" in the visualization settings. Then, choose "Show the first rows". Finally, enter -1 as the number!