A number box returns the sum, average, minimum, maximum, count, or distinct count of a measure. A number box is an effective format to quickly convey your KPIs as it shows changes between the current and the last period in a simple manner.
To create a number box, follow the next steps:
- Click on the number box icon.
- Drag and drop a metric you're interested in into the Measures field.
- Drag and drop a date dimension into the Breakdown by Date field.
- By default, a number box will sum up measure values by date periods. To change an aggregate function, click on SUM and / or Year.
On a widget level, users can also set particular filters by dataset variables. To do so, you can drag and drop variables from the measures and dimensions field and then apply a filter to the variable you chose.
By clicking on Data , you will get a preview of the data used to build a widget.
Updated 3 months ago