How to create a Gauge chart
In this guide, we'll walk you through the process of creating a Gauge charts. This chart is commonly used to display metrics like progress, completion percentages, or performance indicators.
Let's get started!
1. Access the Dashboard
2. Choose the Chart Type
3. Add a Chart Tag
4. Add a Chart Title
5. Add a Chart Description
6. Percentage, Target, Max value options
7. Add a Query
To start creating a table, you'll first need to access your dashboard folder. Dashboard folders are located on the right green sidebar of the WebApp. If you don't have a dashboard yet, you'll need to create one by clicking on the yellow icon Create dashboard. Once you're in your dashboard, click on the plus (+) button under the Add chart
A dialog box will appear for you to select the type of chart you want to create. From the dropdown menu, select "Gauge".
Next, you'll need to add a chart tag. This tag should be unique and separated by underscores if it comprises of more that one word / letter e.g (p_c ,perce_coverage)
Now, add a title for your chart. This title should represent what the chart is about. For example, if your chart is about outlet coverage, you might choose a title like "% coverage".
Add a description for your chart. This helps other users understand what the chart is about and what the query does. For example, you might write "percentage outlets visited out of the total"
In this step, you'll configure various options for your chart:
- Percentage: Toggle this on if you want to show the value as a percentage if this has not been done through the query
- max value: Fill in the max value to be 100
- Target: Fill in the target to be 100
Finally, you'll need to add a query that will fetch the data for your chart. Remember to set a condition to only calculate the percentage only when the field used have a value of more than zero. This can be achieved using the CASE WHEN function. Test your query to ensure it returns the expected results.
And that's it! You've created your first Gauge Chart. Remember, you can always edit your chart later if you need to make changes or adjustments.
Final chart
add filters accordingly
Let's get started!
1. Access the Dashboard
2. Choose the Chart Type
3. Add a Chart Tag
4. Add a Chart Title
5. Add a Chart Description
6. Percentage, Target, Max value options
7. Add a Query
1. Access the Dashboard
To start creating a table, you'll first need to access your dashboard folder. Dashboard folders are located on the right green sidebar of the WebApp. If you don't have a dashboard yet, you'll need to create one by clicking on the yellow icon Create dashboard. Once you're in your dashboard, click on the plus (+) button under the Add chart
2. Choose the Chart Type
A dialog box will appear for you to select the type of chart you want to create. From the dropdown menu, select "Gauge".
3. Add a Chart Tag
Next, you'll need to add a chart tag. This tag should be unique and separated by underscores if it comprises of more that one word / letter e.g (p_c ,perce_coverage)
4. Add a Chart Title
Now, add a title for your chart. This title should represent what the chart is about. For example, if your chart is about outlet coverage, you might choose a title like "% coverage".
5. Add a Chart Description
Add a description for your chart. This helps other users understand what the chart is about and what the query does. For example, you might write "percentage outlets visited out of the total"
6. Percentage, Target, Max value options
In this step, you'll configure various options for your chart:
- Percentage: Toggle this on if you want to show the value as a percentage if this has not been done through the query
- max value: Fill in the max value to be 100
- Target: Fill in the target to be 100
10. Add a Query
Finally, you'll need to add a query that will fetch the data for your chart. Remember to set a condition to only calculate the percentage only when the field used have a value of more than zero. This can be achieved using the CASE WHEN function. Test your query to ensure it returns the expected results.
And that's it! You've created your first Gauge Chart. Remember, you can always edit your chart later if you need to make changes or adjustments.
Final chart
add filters accordingly
Updated on: 23/08/2023
Thank you!