I have a custom report that is displayed in a section on the C360. It is sorted by date, and to be useful to the AMs in the C360 the most recent data needs to be at the top. The sorting is fine in Report Builder, but does not carry over when the report is displayed in C360. What am I missing?
Page 1 / 1
So using the Ranking function seems to have fixed the sorting. Seems to me the sorting should be persistent without limiting the set of records.
Hi Kristin, I was just going to post that the ranking is persistent. For others seeing this post, sorting refers to click on the column name in report builder. If you do this, then this sorting does not carry over when the report is loaded in 360 or dashboard.
Ranking on the other hand is persistent. The primary use case of ranking is to show a limited set of records, but if input the limit to be high enough (higher than total count of records) it performs a sort. You can see more details on ranking here - https://support.gainsight.com/hc/en-us/articles/212529508-How-to-Build-Basic-Reports. Expert tip: Ranking work for text fields as well. 'Top' = descending order and 'Bottom' = Ascending order.
Ranking on the other hand is persistent. The primary use case of ranking is to show a limited set of records, but if input the limit to be high enough (higher than total count of records) it performs a sort. You can see more details on ranking here - https://support.gainsight.com/hc/en-us/articles/212529508-How-to-Build-Basic-Reports. Expert tip: Ranking work for text fields as well. 'Top' = descending order and 'Bottom' = Ascending order.
This was very helpful, I was only thinking sort too! Thanks!
Hi Gaurav!
I'm trying to accomplish this to show our top 25 accounts by MRR. When I apply the ranking to the currency field, it shows the top 25 accounts, but it does not sort them largest to smallest. I also don't have the option to select "asc/desc".
Any thoughts on what is happening and how to solve for this?
I'm trying to accomplish this to show our top 25 accounts by MRR. When I apply the ranking to the currency field, it shows the top 25 accounts, but it does not sort them largest to smallest. I also don't have the option to select "asc/desc".
Any thoughts on what is happening and how to solve for this?
Did you get this resolved Lane?
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 E-mail address. We'll send you an e-mail with instructions to reset your password.