Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM forum
Unanswered

Calculate Case Time by Status

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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans