How to switch Value - Percentage on a Grid or Chart. From Tips & Tricks December 22
Sneak: How to switch Value - Percentage on a Grid or Chart
The Tips&Tricks Series is produced by the Customer Success Team. It highlights several easy to follow instructions and range from simple tasks to more advanced use cases.
How to switch Value - Percentage on a Grid or Chart
When you want to be able to switch or display different values on a grid, or chart, like the base value AND also it’s % value of the total, it can be done using several techniques in Discover, without the need for any complex coding or calculation.
In this example, we will use a sales metric, and find the % of total value for this metric. Starting report:
- Using the right click context menu, right click on the Sales header and choose % of total following the click path below. Notice all the different nocode calculations you can incorporate besides % of total.
The newly created measure will be added on the grid:
- Using conditional formatting, you can add % of total as an indicator, in the same cell as the sales metric
The % of total measure is then added as an indicator on the grid, in sales column
- Using Formatting Panel with a pie chart. Start a brand new pie chart report. Open Formatting Panel from the right side of the canvas.
Go to the “data labels” property, and under content, choose the information/label that you want to show in the chart.
If you have questions about these tips (or improvements) please let us know in a comment.
P.S. We will post previous Tip&Tricks as well as all new ones to keep this information active and available to all users.
- 7 mths agoLast active
- 1 Following