Need to add report to Dashboard

[Arka Banerjee]

Hi Team,

How can we create a report from View\Run Module which would display active HR cases by assigned to by Business elapsed percentage.

@Ankur Bawiskar 

For eg, we need to show how many HR cases are assigned to 'X' person with business elapsed percentage between 0-19, 20-39 and so on

Similarly, how many HR cases are assigned to 'X' person with business elapsed percentage between 0-19, 20-39 and so on.

Can someone please help achieve this

[Dr Atul G- LNG]

Hi @Arka Banerjee 

The "View/Run Report" module is deprecated. The legacy reporting module has been merged and enhanced under the Platform Analytics product.
You now need to create and manage reports under the "Tab Only" section of Platform Analytics.

Here's my video explaining the same: https://youtu.be/UNnSPE2eP4s

we need to show how many HR cases are assigned to 'X' person with business elapsed percentage between 0-19, 20-39 and so on

Atu: 

To achieve this, you need to create a Database View.
This view should include information from both the HR Case table and the SLA table.

[Ankur Bawiskar]

@Arka Banerjee 

you can use report on task_sla and then use Report Ranges feature

ServiceNow reporting - use report ranges for advanced grouping 

Report ranges 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Arka Banerjee]

Thanks Ankur,

I am a bit confused by this. Basically I need to stack the business elapsed percentages by dividing it into 5 slabs here of 0-19, 20-39 and so on. Is there any way I can use configure function field for this. Could you please help construct how I can technically achieve this.

Thanks1

[Dr Atul G- LNG]

Hi @Arka Banerjee 

Did you try using the Trend Report, where you get the option to trend based on a specific field?