I am doing some reporting for our CSAT-style survey questions and hitting some confusion charts. The question itself can yield one of five possible numeric answers: 1, 2, 3, 4, 5. Therefore, the maximum average value of a group is 5.00. However, when making a report where the average is above 4.00, the report shows a max y-axis range of 6. This is silly and something I would like to change.
Does anyone know how to set a specific value range for the y-axis in a column graph?
Per the above, I would like to to be min of 1.00 and max of 5.00 (depending on the data, I might even do a min of 3.00 if I am feeling crazy).
Thanks for the help as always!
How do you adjust the y-axis scale in column reports?
None
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
We're sending monthly emails to customers that contain reports, and it would be ideal if we could dress the reports up a bit before embedding in an outreach.
Thanks for posting Ben :)
Thanks
Venky
One other thing to consider is expanding filters on reports. For example, if we do get to configure the y-axis scale for Gainsight dashboard reports we need to ‘lock in’ that scale if the time frame is expanded. We have reports that works in the current CQ showing activities per distinct count of accounts, but when the data set is expanded to Previous CQ (which contains a lot more CTA data), the scales on the y-axis that counts Accounts displays higher than the activities because the scale, well, scales.
If we admins get to designate the initial scale of both axis's, whatever changes happen when applying filters should maintain the same scale.
Looking forward to more advanced dashboard capabilities!
Note that the lesser amounts on the graphs are represented as the higher value. This skews the entire reason for visualizing the information in dashboards. Hope to have this converted to idea and see the graph controls (like@pele mentioned e.g. bounds, units, labels, label position, etc.) implemented.
This would be an incredible value to us admins who support our Customer Teams.
Hi@davebrown2242 - in your specific example, the issue is that you have dual axis turned on, so a separate axis for the blue values and a separate axis for the red values. The dual axis feature is useful if the two data series are significantly different in min/max ranges (usually 10x or greater), but if the two series are in a similar range (like your data is), then it’s best to turn off the dual axis.
Ha, good catch@dan_ahrens . I was just trying to help by snapping a quick snapshot and missed that. Also I fixed that graph. Thanks again.
I went ahead and converted this to an Idea / feature request.
This would be a VERY, VERY beneficial feature. I too have the CSAT problem.. Executives sure don’t like it when I tell them I KNOW our CSAT scale is 1-5, but the product doesn’t let me pick the scale
Similarly with the data score placement.. inside end, center, inside base, …
Hello Everyone,
Happy to announce that your request has been considered and implemented in the Horizon Analytics. Gainsight has now enhanced the Chart Editor settings in both SFDC & NXT versions.
Thanks for posting!