Skip to main content
Solved

Pivot Reporting by Metric and Week

  • March 11, 2022
  • 3 replies
  • 95 views

trevor_shand
Forum|alt.badge.img+2

We’d like to build a report where we see our company names (in this case ABC, DEF, etc.) then their score for two different metrics, by week, like the example below. Can this be done?

 

Best answer by Azad

@trevor_shand  

Sure this is currently possible in reporting ( except the total columns ) 

Add the two metrics you want to see in Show me 

Add the Name of the company and the Date field in group by 

click on the settings icon for the date field and select Pivot  and you should be able to see the report in the way you described. 


 

 

3 replies

anirbandutta
Forum|alt.badge.img+2
  • Expert ⭐️
  • March 16, 2022

@Azad for possibilities


suryanarayana
Forum|alt.badge.img+2
  • Helper ⭐️
  • March 16, 2022

We could not achieve the exact same thing but we could achieve similar thing in report builder if we do Row Grouping.

 

 


Azad
Forum|alt.badge.img
  • Gainsight Employee ⭐️
  • Answer
  • March 16, 2022

@trevor_shand  

Sure this is currently possible in reporting ( except the total columns ) 

Add the two metrics you want to see in Show me 

Add the Name of the company and the Date field in group by 

click on the settings icon for the date field and select Pivot  and you should be able to see the report in the way you described.