So, you have worked on creating a wonderful dashboard for your executives but you want to provide the graphs with some titles so your team can quickly see the numbers too.
Here’s how you might have been doing that for now
But, what about the total numbers?
Yup, you are creating new sheets to do just the metrics. Well, no need, anymore
Here are the tips to add the total of a metric (or metrics for that matter) within the sheet so you can create more insightful dashboards.
- Open the worksheet
- Duplicate the field
- Change to Count Distinct
- Aggregate the field using TOTAL()
- Change “Compute Using”
- Insert the field in the title
- A bit of formatting
- Here’s what the sheet looks like
And once you do this, the final product looks like this
Much better, right?