cant sort a pivoted table with a string fiels so my reports don’t go in a logical order.
add ability to manually change sort on reports for string fields
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.
Hi,
We already support sorting on the non pivoted field in the pivoted reports. If you want to sort the columns themselves, unfortunately, there is no way. Pivoted report often are heavy queries which take a while to process data when you query. We cannot support multiple operations which we support for non pivoted reports and guarantee a decent load time. Most of the pivoted reports might just time out.
What I’d recommend is to pivot the data using one of our data preparation tools (Data Designer) and then run the report on it. This way, we are pre-computing and are not computing everything when a user visits a dashboard and hence can support complex calculations.