Quicksight: Guage Chart - Reserve Padding linked to Target Value
I am trying to show Value relative to Target Value in a Guage Chart. What I want to do is show the Target Value in the middle, and the Value above or below the middle subject to the range. To achieve this, I need the reserve padding to be 100 on the Target Value...but Quicksight only appears to allow it to be based on the top of the range: Reserve padding (%) – Added to the top of the range (target, actual value, or max)
Here's an example, and while the data is dynamic with this data I want the center of the chart to be the Target Value of 12.5% and the max at (2x target = 25%).
- Newest
- Most votes
- Most comments
Set the range of the y-axis to go from 0% to twice the target value. So if your target is 12.5%, set the range from 0% to 25%.
Set the "Reserve Padding" option to 50% instead of the default 100%. This will make the target value fall in the exact middle of the chart range.
The actual value will now appear above or below the target depending on whether it is higher or lower than the target.
Some key points to note:
The range must be symmetric around the target for it to appear exactly in the middle Reserve padding of 50% instead of 100% is needed to center the target Dynamic target values can still work as long as the range is calculated correctly based on the target
Relevant content
- asked a year ago
AWS OFFICIALUpdated a year ago- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
