I would like to rotate the units, in this case dates, to report vertically instead of horizontally because the dates are over running each other and are not clear to read anymore. Is this possible?
If not, can you change (decrease) the intervals to have fewer dates to be on the X-Axis?
Thanks in advance 🙂
Rotate units on axis to vertical
Userlevel 7
+2
Hi William, are you able to post a screenshot to better understand your request?
Userlevel 5
+3
Hi Willem, are you referring to when you 'enable' the Pivot Table option? Having the option to do a Vertical Pivot Table, rather than Horizontal?
For example:
Have a look at the first screenshot under the "1. Habits scorecard measure over time" header on https://www.gainsight.com/customer-success-best-practices/vps-of-customer-success-heres-how-i-run-the-team/
You see how the dates on the x-axis are squashed together and almost looks like one long string of text, if you have more data it gets worse and they start overlapping each other and you can't read the dates anymore. Can you, as in Excel, rotate the dates 90 or 45 degrees to be vertical or at an angle instead of horizontal?
Also, can you force the y-axis in a Gainsight report to stop at a specific point? Example, if you have a percentage graph and the max it can go to is 100%, Gainsight sometimes take it up to 150% although the data will never go over 100% and I can't see where to specify the range of the axis.
Appreciate any response on this.
Thanks.
Have a look at the first screenshot under the "1. Habits scorecard measure over time" header on https://www.gainsight.com/customer-success-best-practices/vps-of-customer-success-heres-how-i-run-the-team/
You see how the dates on the x-axis are squashed together and almost looks like one long string of text, if you have more data it gets worse and they start overlapping each other and you can't read the dates anymore. Can you, as in Excel, rotate the dates 90 or 45 degrees to be vertical or at an angle instead of horizontal?
Also, can you force the y-axis in a Gainsight report to stop at a specific point? Example, if you have a percentage graph and the max it can go to is 100%, Gainsight sometimes take it up to 150% although the data will never go over 100% and I can't see where to specify the range of the axis.
Appreciate any response on this.
Thanks.
Userlevel 7
+2
Great suggestion!
Userlevel 6
+1
Hi Willem,
Thanks for asking. Excel does allow you to control each and every element of a chart. Currently, Gainsight reports do not offer such granular control over the individual elements. The ability to modify axis labels, the range of axis, etc is something which we are currently scoping to enable that granular control. However, this is on our medium-term roadmap and will take a while to materialize. I'll update this post when we pick this up!
Moving to the second part of the question, we can indeed decrease the intervals to have fewer dates either by filtering the data set or by reducing the granularity of dataset via summarize by. Most date fields when added to group by will have a summarize by (Week, Month, etc.) option. This document contains more information. https://support.gainsight.com/Reports_and_Dashboards/Admin_Guides/How_to_Build_Basic_Reports#Summarize_by
Thanks for asking. Excel does allow you to control each and every element of a chart. Currently, Gainsight reports do not offer such granular control over the individual elements. The ability to modify axis labels, the range of axis, etc is something which we are currently scoping to enable that granular control. However, this is on our medium-term roadmap and will take a while to materialize. I'll update this post when we pick this up!
Moving to the second part of the question, we can indeed decrease the intervals to have fewer dates either by filtering the data set or by reducing the granularity of dataset via summarize by. Most date fields when added to group by will have a summarize by (Week, Month, etc.) option. This document contains more information. https://support.gainsight.com/Reports_and_Dashboards/Admin_Guides/How_to_Build_Basic_Reports#Summarize_by
Userlevel 6
+1
Even though most % data is limited to 100%, in some use cases, it exceeds 100% which makes it hard for us to default to a max of 100. We do plan on making this configurable instead!
Reply
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.