The CreatorCon Call for Content is officially open! Get started here.

To calculate the open days of a major problem from opened_at to today, need report that shows count

HarshaVardhanB
Tera Contributor

There is requirement of creating a report of number of days the problem is opened, based on the opened/created date to today for a major problem record, without modifying/creating a field column on Problem table 

6 REPLIES 6

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @HarshaVardhanB 

https://www.servicenow.com/community/developer-articles/function-fields-in-servicenow-reports-calcul...

CC:

@AnveshKumar M 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

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/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Ankur Bawiskar
Tera Patron
Tera Patron

@HarshaVardhanB 

you can use function field for this in reporting.

Function field is not an actual column but helps creating a virtual column which can display data

check this video and it explains the details

Reporting Function fields - Platform Analytics Academy - April 5th, 2023 

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

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

@HarshaVardhanB 

Hope you are doing good.

Did my reply answer your question?

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

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Bhuvan
Giga Patron

@HarshaVardhanB 

 

Use function fields in report designer to calculate number of days problem record was opened. This will not create any fields or store the data in database and optimal for creating reports.

 

See below for sample how to use function fields in reports,

 

https://www.servicenow.com/community/developer-articles/function-fields-in-servicenow-reports-calcul...

 

If this helped to answer your query, please mark it helpful & accept the solution.

 

Thanks,

Bhuvan