Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

how to create an Incident (Monthly) Month End CSAT Survey report as follows: Percentage By month of each questions answered of the overall surveys received

C_S3
Tera Contributor

Can someone please help me regarding this query?

how to create an Incident (Monthly) Month End CSAT Survey report as follows: Percentage By month of each questions answered of the overall surveys received

1 ACCEPTED SOLUTION

Community Alums
Not applicable

Hi @Chandni Shah ,

 

1. You can create report on Metric Result Table

find_real_file.png

 

2. Type of the report could be pie

3. Group by Metric.Question

find_real_file.png

 

3. Add below conditions to filter data:

find_real_file.png

Metric.Type is your Survey Name.

This would give you the data you need. 

 

Taranjeet 

Please mark reply as Helpful/Correct, if applicable. Thanks!

View solution in original post

4 REPLIES 4

Community Alums
Not applicable

Hi @Chandni Shah ,

 

1. You can create report on Metric Result Table

find_real_file.png

 

2. Type of the report could be pie

3. Group by Metric.Question

find_real_file.png

 

3. Add below conditions to filter data:

find_real_file.png

Metric.Type is your Survey Name.

This would give you the data you need. 

 

Taranjeet 

Please mark reply as Helpful/Correct, if applicable. Thanks!

Hello @Taranjeet Singh ,
Thank you for your response. Can you tell me how can I divide the data of the report based on the below given fields for every month?

Community Alums
Not applicable

@Chandni Shah , What are these fields? looks like something customized

Hello,
Thank you for your response.
Can you tell me how can I get the report in below format?
find_real_file.png