I have a set of benchmarks i need to display in a dashboard where the target value is a percentage of the whole (eg., “95% of staff have been trained”). we would like to show the progress toward each threshold as if that 95% target were in fact 100% completion of this target while ignoring any overage. in the example below, the gauge is showing a target value of 95% of an organization’s staff (1.9 in this case), but their actual value is 2, exceeding the threshold by .1, or, 5%. we do not wish to show the overage, since the only information we want to display is progress towards the target value on a scale of 0-100%. In other words, we want to rescale the 0-1.9 range on 0-100% domain. is there a way to achieve this?
Hello @jtroxel, Hope this message finds you well!
If I understand you well, you want to adjust the scale of your gauge so that the target of 95% is treated as 100% in the context of your dashboard.
In this case my suggestion is create a calculated field that make this calculation:
adjust_value = ifelse({actualValue} > {targetValue}, 100, ({actualValue} / {targetValue}) * 100)
Where actualValue is the actual value and targetValue is the target value (1.9 in your example). By doing this, the gauge will show progress towards the 95% target as if it were 100%, ignoring any excess.
Please, tell me if it’s work!
1 Like
@lary_andr i am impressed that you were able to accurately interpret my rather convoluted description of the issue and your solution definitely feels like its on the right track but when i adapt this to my own dashboard, it is displaying the following:
My Values field contains the following calculation:
ifelse(StaffTrained > (TotalStaff*.95), 100, (StaffTrained/ (TotalStaff*.95))*100)
My Target Value field contains the following calculation:
TotalStaff*.95
this feels like there’s some recursive logic here or its like a lifecycle hook issue where one calculation needs to fire before another but i cant seem to wrap my head around it. i even just tried hard coding 1.9 into the calculation instead of “TotalStaff*.95” but it still doesn’t display as expected. any other ideas?
1 Like
@jtroxel thank you for your awnser! I’m very happy to help 
As a suggestion to your problem, I think that you can follow a structured approach to create/understant the calculated fields correctly and ensure the logic is applied in the right order.
first of all, you need to create a calculated field for the adjusted value, which will compute the progress towards the 95% target and treat any value above this target as 100%.
In this case could be something like:
AdjustedProgress = ifelse(StaffTrained > (TotalStaff * 0.95), 100, (StaffTrained / (TotalStaff * 0.95)) * 100)
subsequently, you should create a calculated field for the target value, which simply defines the target as 95% of the total staff, like:
TargetValue = TotalStaff * 0.95
one point: it’s important to verify that the AdjustedProgress field is calculated after the TargetValue field.
qs calculations order can be controlled by how fields are referenced, so since TargetValue is a constant (95% of the total), it should be calculated first, allowing AdjustedProgress to use this value.
if issues persist, check for any conflicts with other calculations or filters applied in the dashboard that might affect the outcome
and please, tell me if it’s work!!
Hi @jtroxel,
It’s been a while since we last heard from you, did you have any additional questions regarding your post or were you able to find a work around for your case?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you!
Hi @Brett @lary_andr We have determined that the issue preventing our desired effect comes form the fact that the relationship between the display value and target value is inextricable. so, for instance, if we wanted the target value marker to be set at 75% of the total, we have no way to set the display value to show the actual overall percentage, rather than a percentage in relation to the target value, eg., “75%” of a 75% target value or “100%” of 75%. We also have the option to show the difference in percent from the target value, for example, but neither of these options are as intuitive as being able to mark on the gauge where the target is, and then showing a display value where 75% refers to 75% of the gauge’s scale from 0-100%.
This is frustrating and our work around is to set the target value to 100%, and we simply indicate the actual 75% target value in the chart title, rather than visually with the gray line plotted at the 75% point on the gauge as we would prefer. Users will now know the target has been met when the display value in the center of the chart matches whatever target value we indicate in the chart title.
Hi @jtroxel,
Thank you for providing information on your work around. I will set this as a feature request so that additional options can be evaluated.
Thank you
1 Like