If you are using a gauge indicator in your dashboard and want to make the gauge reflect a percentage like shown below (elasticube is Sample Retail) -
Follow the steps below -
Steps:
1. Create an indicator widget and add a value you want to review.
In this example, I want to get a percentage of sales order in the USA out of all sales orders:
In this example, I want to get a percentage of sales order in the USA out of all sales orders:
(COUNT([Sales Order ID]),[Region])/COUNT([SalesOrderID])
2. Click on the "123" selector on the value and select percent and click OK
3. On the right hand side of the widget editor, click "Design" then "Gauge"
Additional editor options on the left-hand side of the widget editor should appear.
Additional editor options on the left-hand side of the widget editor should appear.
4. Change the "min" and "max" values to percentages by clicking the "123" selector
5. For the max value, click the pencil icon then change the value from 100 to 1
Then click OK
Then click OK
6. Now you should have a correct looking gauge with a range of 0% to 100%
