Performance Analytics Report and Dashboard

[Narmadha PR]

Hi,

I need to create a Performance Analytics Report and Dashboard for the excel sheet provided below, that gets the count when an incident record is created from the CI . Also it needs to provide the count on both yearly and weekly basis. Please help me on my requirement. Thanks in Advance!

[Dr Atul G- LNG]

Hi @Narmadha PR 

I tried this in myPDI, but generating the report exactly the way you want isn’t possible. You can create a multi-pivot and add the required rows and columns, but most of the work will be manual. To get this specific data, you would need to create a trend report separately.

[Narmadha PR]

Hi Sir,

Thank you! Can you please send me a step by step procedure to implement this?

[Dr Atul G- LNG]

Hi @Narmadha PR 

It's a simple report. The type is pivot.

You can see the screen shot for row and columns.https://youtu.be/UNnSPE2eP4s

This video gives you more in-depth.

[Ankur Bawiskar]

@Narmadha PR 

exact same look and feel is not possible as ServiceNow reporting has it's own limitation.

what's the exact business requirement?

what customer wants to see in reporting?