Skip to main content

We would like the ability to transpose (flip the columns and rows) tabular reports. This will allow us to better display data to our end users.

One use case that we are currently encountering for this request is our annual loyalty survey. We receive a few responses per customer for this survey, but include many questions that we’d like to display to our CSMs in the C360. Displaying each question response horizontally is not a good experience, as it requires horizontal scrolling from the user to view all of the survey results in one screen. 

I can imagine many more use cases where this would be helpful and can imagine other customers would benefit from this enhancement as well.

I had this on my list of things to make a post about. I also want to add that this is a different use case that Pivot and/or row grouping does *not* solve, nor is it capable of doing so.

 

 

The terrible but only work around I came up is:

 

You create a new table that stores a label for each column you want.

 

Then you merge this into your data set on a field that is the exact same, i.e. a field that is always true in both data sets.

 

 

Then you case statement, "If Label = ACV then output the ACV column" else "if label = renewal date then output renewal column, etc.

 

This is all under the assumption they are the same data type.

+1 to this

Terms & ConditionsCookie settings