Create a Gauge Chart
Here we will create a Profit Margin gauge chart. A gauge can be used to visualize a single key figure. A gauge is easy to read and understand and provides an instant indication of performance within a range.
This time we will add a formula to calculate the profit margin.
Proceed as follows:
-
Click on the + icon to the right of the KPI chart to add a new visualization.
-
Under Properties > Visualizations, click on the menu icon (three dots). Then click on the measurement pointer icon.
-
Click on Add KPI and then on the formula icon fx.
The formula editor opens.
-
Enter the following:
(sum(Sales) - sum(Cost)) / Sum (Sales)
-
Click on Apply.
Customizing the diagrams in advanced editing mode​
Once all visualizations have been created, switch to advanced editing mode to customize them. Toggle on Advanced options at the top right.

Proceed as follows:
-
Select the gauge chart.
-
Deactivate chart suggestions.
-
Under Presentation > Range limits, set the minimum value to -0.5 and the maximum value to 0.5.
-
Select the Bar option.
-
Activate Use segments and deactivate Use library.
-
Click on the Add limit button. Enter 0.12 in the field.
-
Click on the Value bar. Select red for the values below the limit and green for the values above the limit.
-
Select Data. Click on the formula to display further options. Under Number format, select Number from the drop-down menu. Under Simple, select the 12% option. This will display a percentage without decimals.
-
Select Appearance > KPI axis. From the Field Names and Titles drop-down menu, select Field Names Only.
-
Click on the chart and add a title: Profit Margin.
The gauge is ready and shows a large profit margin.
The different colors of the gauge are used to support the interpretation of the value. Red is worrying, green is good.