Standardizing Scale on Y Axis
Is there a way to standardize the scale on the Y axis of chart widgets in the dashboard? I want to standardize to 100% on all graphs, but the dash auto-selects for me.
If this isn't available yet, could it be added to the options? Visually it would really help the people for whom this dash is developed. Right now % completeness is misleading if you are only looking quickly.
Thanks, Kelly
Best Answers
-
There currently isn't a way to set the Y Axis to a specific number, it will auto-adjust depending on the metrics that it is referencing. Please let our Product Team know about your feedback through this form, here!
What I would personally do in this situation is set up a 7th data point to "fill out" the rest of the bar and have it reach 100%, which would set a standard Y Axis across all of your charts. I've called mine "Left to Go":
Then as long as your widget sizes are the same, the bar graph will be standardized.
To create this metric, I took the values of all the other data and subtracted the SUM of these values from 100:
Let me know if this will work for you!
Cheers,
Genevieve
-
Genevieve P that I like! thanks!! good thought - I really do want it to be uncomplicated because there are a number of different groups of people who will glance in from time to time and the less confusing it is...
kelly
Answers
-
There currently isn't a way to set the Y Axis to a specific number, it will auto-adjust depending on the metrics that it is referencing. Please let our Product Team know about your feedback through this form, here!
What I would personally do in this situation is set up a 7th data point to "fill out" the rest of the bar and have it reach 100%, which would set a standard Y Axis across all of your charts. I've called mine "Left to Go":
Then as long as your widget sizes are the same, the bar graph will be standardized.
To create this metric, I took the values of all the other data and subtracted the SUM of these values from 100:
Let me know if this will work for you!
Cheers,
Genevieve
-
Genevieve P, Thanks, I was thinking about this as an option, but was hoping not to add another bar - again, it could confuse the viewer who is not paying close attention. BUT I may do that last field in a white so it doesn't "show" it might provide a work-around for now.
I appreciate your help! Kelly
-
Ah, yes! You could do it in white. You'll still need some sort of label or column name for that field, but this could be made up of symbols... for example " ____ "
-
Genevieve P that I like! thanks!! good thought - I really do want it to be uncomplicated because there are a number of different groups of people who will glance in from time to time and the less confusing it is...
kelly
-
-
@Genevieve P. Here's another thing to consider. Change the "Left to do" heading to just a fullstop. Then change the bar to white. As it is a white background the bar won't show and the legend will just show a . under the last colour. That way it is fixed, but not really visible.
