web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Service | Customer Service, Contact Center, Fie...
Suggested Answer

How to report on time tracked in a case

(0) ShareShare
ReportReport
Posted on by

Hello all,

we have implemented Dynamics 365 Customer Service and try to report on the total time a support engineer spent on a case. I have found the information, that the total time spent on a case is not saved as a value on the case entity but on the case resolution entity. There are two questions open for us:

1. Is it possible to get the value from case resolution to the case? Or is there another way to get the value to report on it in a view containing case data?

2. Is it possible to add customer entries/activities to the timeline (we have one for other time spent on the case) and have all times reported on that included in the total time?

Thank you in advance

I have the same question (0)
  • Suggested answer
    RakeshJ Profile Picture
    on at

    Hi Clara,

    Regarding Question1 -

    Yes, we can get the value from Case Resolution to Case entity. From the below screenshot, you can see that Case Resolution has N:1 relationship with Case entity.

    You can easily bring the field value from Case Resolution entity to Case entity via Mapping and get the value on Case. 

    pastedimage1605005124088v1.png

    Regarding Question# 2 - Is it possible to add customer entries/activities to the timeline (we have one for other time spent on the case) and have all times reported on that included in the total time?

    You can try to implement like  https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/define-rollup-fields#aggregate-data-for-a-record-from-related-records

    If this is helpful, kindly mark this as verified. 

    Thanks,

    Rakesh

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Service | Customer Service, Contact Center, Field Service, Guides

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 53 Super User 2025 Season 2

#2
Daniyal Khaleel Profile Picture

Daniyal Khaleel 27 Most Valuable Professional

#3
Soundari Profile Picture

Soundari 15

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans