Solved

Pivot Reporting by Metric and Week

  • 11 March 2022
  • 3 replies
  • 76 views

Badge +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?

 

icon

Best answer by Azad 16 March 2022, 13:25

View original

3 replies

Userlevel 7
Badge +2

@Azad for possibilities

Badge +2

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

 

 

Badge

@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