filter for a snapshot in past 'in past xx days' combined with 'not in the past xx days' | Community
Skip to main content
January 12, 2016
Solved

filter for a snapshot in past 'in past xx days' combined with 'not in the past xx days'

  • January 12, 2016
  • 1 reply
  • 1511 views

Hi All,

I need to create a report that returns the amount of people with a lead status change for a time period in the past. Using the date picker is not ideal as this would be a manual process. I am trying to achieve this via 'in past xx days' combined with 'not in the past xx days'.

In this example, this would mean people whose lead status changed to re-marketing during the period 9 Dec to 16 Dec 2015.

Here is an example

I dont trust the results, would someone be able to test this logic and advise weather this is at all possible?

Thanks

Matt

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Grégoire_Miche2

Hi Matt,

For me, the logic is good as long as you have an AND operator between your 2 filters.

-Greg

1 reply

Grégoire_Miche2
Grégoire_Miche2Accepted solution
Level 10
January 12, 2016

Hi Matt,

For me, the logic is good as long as you have an AND operator between your 2 filters.

-Greg

January 12, 2016

Thanks Greg