Skip to main content
Question

Rotate units on axis to vertical

  • November 28, 2018
  • 7 replies
  • 45 views

willem_du_plessis
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 🙂

7 replies

dan_ahrens
Forum|alt.badge.img+2
  • Expert ⭐️⭐️⭐️
  • 1984 replies
  • November 28, 2018
Hi William, are you able to post a screenshot to better understand your request?


willem_du_plessis
https://



sagan_sherlin
Forum|alt.badge.img+4
  • Helper ⭐️⭐️
  • 280 replies
  • November 29, 2018
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?


willem_du_plessis
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.


dan_ahrens
Forum|alt.badge.img+2
  • Expert ⭐️⭐️⭐️
  • 1984 replies
  • December 6, 2018
Great suggestion!


rakesh
Forum|alt.badge.img+1
  • Lets put your data to work!
  • 835 replies
  • December 12, 2018
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 


rakesh
Forum|alt.badge.img+1
  • Lets put your data to work!
  • 835 replies
  • December 12, 2018
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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings