Knowledge Drop
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!
LinkedIn
Twitter