Controlling/Targeting/Limiting the Y-Axis Range

My customer has been using the web based tables and reports from Flow in their weekly meetings. This format has been easy for them to present on but they were curious to adjust the Y-Axis range to emphasize small percentage changes for measures of large magnitudes or sensitive processes.

They are interested in a method to either manually set the upper and lower limits on the y-axis and the option to have the y-axis limits automatically fit to the range within the data set.

In the case of the auto-fit, would you pad the upper and lower limits of the y-axis with a percentage 10-20% of the difference in the max and minimum values contained within the data set to maintain aesthetics? This would set the trend to automatically track to the center 60-80% of the chart space.

yaxis(min) = min - ((max - min) / 10)

yaxis(max) = max + ((max - min) / 10)

Flow Support

April 25, 2017 14:19

Hi Kevin

Thanks for the suggestion.

One way we could do this is to have a "toggle" that allows users to quickly change the chart view between "Pin to zero" and "Unpin". This means their is no additional configuration required.

Would this work for your customer?

Kevin OConnor

April 25, 2017 14:53

When they unpin the chart view, does that mean that it will then fit closer to the value range?

April 25, 2017 19:24

Yes, "Unpin" will scale the y-axis similar to your padding description above. "Pin to Zero" would ensure that the zero is visible in the y-axis.

April 25, 2017 19:29

That sounds like something that would work. Would the toggle be a setting that is applied at the report level from within the Flow configuration tool or would it be something that is accessible when the report is opened through a browser?

April 25, 2017 19:32

For now, it would just be a "toggle" on the report in the browser.

April 28, 2017 19:23

My customer is interested in the proposed solution.

Controlling/Targeting/Limiting the Y-Axis Range

Comments

Didn't find what you were looking for?