Showing results for 
Show  only  | Search instead for 
Did you mean: 
Level 7
Report Inappropriate Content
Message 1 of 3

Getting data sourced from past date

Hi! Today is June 30, 2020 and I want to extract the data of Agents' last communication sourced from the past date, say June 29, 2020 at 6:00 PM. I have tried the filter on queries and report and I set the "Last communication" filter to "earlier than June 29, 2020 6:01 PM" but all i'm getting are the agents last communication that is updated to June 30. 2020, thus I am getting low and inaccurate numbers. I need to extract data sourced by June 29, 2020 at 6:00 PM to see the count of Agent communications by that point in time. Thanks!

2 Replies
Report Inappropriate Content
Message 2 of 3

Re: Getting data sourced from past date

The best I would suggest to use 'Inactive agent' (default query available). By default, the filter would be last 30 days. We can duplicate the query and customize the filter for last one day/week/month etc.


Report Inappropriate Content
Message 3 of 3

Re: Getting data sourced from past date

That type of historical data is not available, as the last communication is a dynamic field, updated on each asci.  Historical info is not kept for that.

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

You Deserve an Award
Don't forget, when your helpful posts earn a kudos or get accepted as a solution you can unlock perks and badges. Those aren't the only badges, either. How many can you collect? Click here to learn more.

Community Help Hub

    New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

  • Find Forum FAQs
  • Learn How to Earn Badges
  • Ask for Help
Go to Community Help

Join the Community

    Thousands of customers use our Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

  • Get helpful solutions from product experts.
  • Stay connected to product conversations that matter to you.
  • Participate in product groups led by employees.
Join the Community
Join the Community