How do I export the breakdown data of a scorecard in performance analytics

Matthias Lipper
Kilo Contributor

I am Looking for a solution to Export the breakdown data of a scorecard. See example below. When I click "Export scores to CSV" I just get the overall score, but not the detailed list below. So this means I have to copy manually each value from the list. Happy for any Suggestion

Matthias

 

find_real_file.png

 

 

find_real_file.png

7 REPLIES 7

Namrata Khabale
Giga Guru

Hey,

Refer the Link it might help you:

https://docs.servicenow.com/bundle/london-performance-analytics-and-reporting/page/use/performance-a...

 

Mark Correct and Helpful if you find my response Worthy!!!

 

Best Regards,


Namrata.

Matthias Lipper
Kilo Contributor

Thanks Namrata,

you are referring to the Standard Export functionality that I tried as well (see first screenshot). This Approach gets you the Output below in Excel. 

 

find_real_file.png

 

However what I would like to get is the data shown in the Second screenshot - so what is shown in the breakdown tabl:

However what I would like to get is the data shown in the Second screenshot - so what is shown in the breakdown table. I assume that I am not the only one with that issue. 

find_real_file.png

Tushar Hirpurk1
Mega Guru

Hi Matthias,

                Adding to Namrata's point, you need to export the score as PDF only if you want the solution you mentioned,

 CSV file is comma separated value file which will by default saved as Excel file,

so if you want like attached Screenshot i recommend you to export eh score as PDF only,

find below differences

1} Export as PDF

 

find_real_file.png

 

2} Export as CSV

 

find_real_file.png

 

 

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

 

Regards,

Tushar

Hello Tushar,

yes - that is a good idea. The PDF Export gives you as well the breakouts as you have shown in your example. Unfortunately the PDF Exports cuts the results. so in my example it Shows just 10 out of 56 rows. Is there any way to get all the lines?

What works definitely is pasting the PDF data in Word then convert into a table and copy that to Excel. That is cumbersome but still would take less time than entering 50 lines manually.

 

find_real_file.png