Skip to main content
trevor_shand
Helper ⭐️
Mar 11, 2022 7:29 PM UTC
Solved

Pivot Reporting by Metric and Week

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?

 

Azad
AzadAnswer
Gainsight Employee ⭐️
Mar 16, 2022 12:25 PM UTC

@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

3 replies

anirbandutta
Expert ⭐️
Mar 16, 2022 4:44 AM UTC

@Azad for possibilities

Translate
It's an opportunity for engagement
suryanarayana
Helper ⭐️
Mar 16, 2022 12:23 PM UTC

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

 

 

Translate
Inguva Suryanarayana
Azad
Gainsight Employee ⭐️
AzadAnswer
Gainsight Employee ⭐️
Mar 16, 2022 12:25 PM UTC

@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. 


 

 

Translate
PM- GS Home and Analytics