Report to show Completed vs Non completed Demands grouped by category

[dhanu3]

We need report on Demand table which will give Completed vs Non completed(approved, screening, submitted and Qualified state) demands count and percentage grouped by Category.

[Bhuvan]

@dhanu3 

Create a report from sys_report.LIST table and provide report name, table as data source and select table name

Select the visualization type from the available options [sample created is Donut]. 

Configure -> Group by 'State' and Additional Group by 'Category' and select 'Display data table' and refresh the data

If this helped to answer your query, please accept the solution and close the thread.

Thanks,

Bhuvan

[dhanu3]

@Bhuvan  Thanks for your reply.

It is not a normal report. Completed state should show different and non completed should be shown as 1 state(combination of other states).

 We dont want to use report range as it will be applicable for all reports. Database view also not useful for this case.

[Dr Atul G- LNG · Accepted solution]

Hi @dhanu3 

I’m not 100% sure, but did you include the dataset in the report?

https://www.servicenow.com/docs/bundle/yokohama-now-intelligence/page/use/reporting/concept/c_Multip...

[dhanu3]

Thanks @Dr Atul G- LNG .

I have never used this dataset before, but I think it will help here. Let me check and confirm.