Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Unanswered

Calculate Case Time by Status

(0) ShareShare
ReportReport
Posted on by 80

Hi,

I have a problem with the calculation of times regarding the status of a case.

During processing, a case goes through several status changes. For example, there are 'In Progress', 'Researching' and 'Waiting for Customer Reaction'.

What is important to me now is the time that is actively spent by us on solving the case.
So the sum of all times of a case minus the time when the status of the case was 'Waiting for Customer Reaction'.
Of course, it can happen that a case is set to this status several times during processing.

Just to clarify my knowledge: I have not yet worked with the implementation using JavaScript but only with flows.

Thanks in advance for your help!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans