Skip to main content
Solved

Pivot Reporting by Metric and Week


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. 


 

 

View original
Did you find this topic helpful?

3 replies

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

@Azad for possibilities


suryanarayana
Forum|alt.badge.img+2

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 ⭐️
  • 95 replies
  • 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. 


 

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings