Average Business Duration Does not display in visualization

David Diaz
Giga Contributor

an hour ago

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. 

PA - dashboard view.png

 

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

PA - data view.png

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

0 Helpfuls
  • 72 Views
2 REPLIES 2

Dr Atul G- LNG
Tera Patron

49m ago

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.

 

DrAtulGLNG_0-1780403295730.png

 

*************************************************************************************************************
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/dratulgrover [ Connect for 1-1 Session]

****************************************************************************************************************
0 Helpfuls

Tanushree Maiti
Tera Patron

13m ago

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 

 

 

Please Accept the solution if it assisted you with your question & Mark this response as Helpful.
Regards
Tanushree Maiti
ServiceNow Technical Architect
LinkedIn: https://www.linkedin.com/in/tanushreemaiti
0 Helpfuls