Skip to main content
trevor_shand
Helper ⭐️
March 11, 2022
Solved

Pivot Reporting by Metric and Week

  • March 11, 2022
  • 3 replies
  • 131 views

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
Expert ⭐️
March 16, 2022

@Azad for possibilities

It's an opportunity for engagement
suryanarayana
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.

 

 

Inguva Suryanarayana
Azad
Gainsight Employee ⭐️
AzadAnswer
Gainsight Employee ⭐️
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. 


 

 

PM- GS Home and Analytics