create a single score report with custom columns

[rajeevj]

Hi,

I am not sure if this is the correct forum for the following Q.

Has anyone created a single score report with custom columns? If yes can you please share how did you manage it, please?

I know that I can get customized columns via the "cog" but I would rather like to avoid using this option.

Any assistance would be greatly appreciated.

Many thanks

Raj

[Samaksh Wani]

Hello Check the link Below

https://www.servicenow.com/community/hrsd-forum/report-creation-on-hr-case-table/m-p/2610089#M30532

Plz Mark my Solution as Accept and Give me thumbs up, if you find it Helpful.

Regards,

[rajeevj]

Hi @Samaksh Wani ,

What I am after is: 

1) when I create a list report the available table fields are different. Here I get a lot more fields to choose from.

2) when I create a single scorecard report then the cog doesn't give me the same list of fields that I get when creating a list report.

I have tried creating DB views but I still can't see all the fields (Pic 2)

[AndersBGS]

Hi @rajeevj ,

What are you trying to show in the single score? Which type of field is is that you would like to utilize? 

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

Best regards

Anders

[rajeevj]

Hi @AndersBGS ,

In the list report, I can utilize the hidden fields .e.g. within the assignment group, we also have IT towers but I can't see the hidden fields when I click on the SSC to see the list and then may be customize it using the cog.

Does this answer your Q?

Many thanks 

Raj