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

Community site session details

Session Id :
Service | Customer Service, Contact Center, Fie...
Unanswered

Case Movement tracking through Queues

(0) ShareShare
ReportReport
Posted on by 15

hi All,

Our process is setup such that technical support cases in CRM move between different queues ( eg - escalation levels L1->L2->L3->L2->L1).

How would I be able to run a report to see

  • how many cases came into a given queue on a given day.
  • how many times a case changed queues before it was resolved

Right now it seems CRM only remembers when a case came into its current queue, but doesn't recall in what and when that case was in previous queues.

( eg- like a owner/queue history field that salesforce.com has)

Best Regards

Michiel

I have the same question (0)
  • Stefa Profile Picture
    5 on at
    RE: Case Movement tracking through Queues

    Dear Gents,

    I think you could be able to help me from what I read in this discusion:

    What I need to be able to do is: create a view to see which Complaints entered a particular Queue over period X.

    I read the following in your comments: "So as you know, we could only get the enter date for each queue item."

    Can you please advise how we could do that?

    What I'm trying is Create a View-> Queue Items -> Queue Equals X ->Entered Queue Y; BUT it only brings items/cases that are currently in the Queue, not showing which complaints enetered that queue over certain period.

    Thank you in advance and regards!

    Neli

  • Michiel A Profile Picture
    15 on at
    RE: Case Movement tracking through Queues

    Hi Leo,

    Thank you for the feedback. My main issue is that a case can enter and leave a queue in a matter of hours. Hence, my current daily reports do not show actual workload for a given queue on a given day ( since by the time I run the report, the case is gone and hence it is not counted)

    Is the process we are using in MSD365 wrong? (we recentely moved from salesforce.com)

    What is the MSD365 design/process filosophy to have multiple teams share cases between themselves (=Queues), but allowing a manager to monitor/measure the actual case influx (work) in those queues. We may have incorrectly "translated" this from salesforce.com.

    The only other alternative I have found is another post here requiring the creation of a new queue entity item that captures the history

    community.dynamics.com/.../884709

    best Regards

  • LeoAlt Profile Picture
    16,331 Moderator on at
    RE: Case Movement tracking through Queues

    Hi Partner,

    Unfortunately in D365, queue item dose not has such history field to store what queue did the item was in.

    So as you know, we could only get the enter date for each queue item.

    If you want to filter the queue items based on entered date, there are 2 ways.

    1.Create an OOB report in D365 based on queue item and when you run the report, click on "Edit Filter" to add your conditions.

    pastedimage1602829874957v1.png

    2.Create a SSRS report, and add the entered date as filter parameter, so that we could filter records based on entered date on the report directly.

    Regards,

    Leo

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…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

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

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 100 Super User 2025 Season 2

#2
Suresh Kulla Profile Picture

Suresh Kulla 72 Super User 2025 Season 2

#3
DAnny3211 Profile Picture

DAnny3211 54

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans