Create report which shows counts of CSAT and DSAT for IT teams

[gm6]

Hi,

Create report which shows counts of CSAT and DSAT for IT teams. It is a table format which shows like below

Thanks

[Tai Vu]

Hi @gm6 

Performance Analytics might be what you're looking for.

Create a pivot scorecard visualization for a breakdown widget

Cheers,

Tai Vu

[AndersBGS]

Hi @gm6 ,

As @Tai Vu have mentioned, Performance Analytics might be the way to go, as you requirement can't be resolved through standard reports.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders 

[Mark Manders]

If I understand you correctly, you can create a Multi Level Pivot-table report on the asmt_assessment_instance table and filter on metric type = CSAT or metric type = DSAT (and probably state = completed).
Add 'Metric Type' as your column and 'task.assignment_group' as row (dotwalk). This should give you the numbers per survey and the total count.

[gm6]

@Tai Vu 

@AndersBGS 

have created the using the Pivot scorecard. I have requirement if there are zero surveys mention as zero and also need the sorting as per count highest count to lowest