Average Business Duration Does not display in visualization

[David Diaz]

I need show the average time Catalog Tasks are worked on (Business Duration).

To start, I created the visualization (single score) but does not display / show the data in Platform Analytics. Shows up as zero (0) value. 

But I am able to view the Business Duration on the Data table view.

Similarly, using the same table and filters on a list visualization does not display correctly as well. How do I fix this issue?

[Dr Atul G- LNG · Accepted solution]

Hi @David Diaz 

I tried it on NCDNet and it is working as expected. Please try again from scratch and check if there are any conditions in the data source that might be blocking it.

[Tanushree Maiti]

Hi @David Diaz 

ServiceNow doesn't natively populate business Duration on Catalog Tasks upon closure.

You need to enable or create a Business Rule on the sc_task table that triggers upon closure/completion to calculate the business duration

refer: KB0869390 Incident Business timings are showing as '0' when they should have values 

[David Diaz]

Hi Tanushree,

I can see the business duration values on the data source for the completed Catalog Tasks. It just does not display on the dashboards for the average for some reason. Thank you for the KB article though. I appreciate it.