Way to measure magnitude with Data Value Changed or other filer | Community
Skip to main content
Oliver_Zosel
New Participant
November 10, 2016
Solved

Way to measure magnitude with Data Value Changed or other filer

  • November 10, 2016
  • 1 reply
  • 3846 views

Is there a way in a smart list to filter by the magnitude of a data value change of an integer field? I.e. I want to see in a specific time period how many leads jumped by 40 or more in lead score.


Alternatively is there a different filter I can apply to do so?

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 Devraj_Grewal

Yes and no. You can bring in the filter "Score was changed" and use the constraint "change". This allows you to determine how much the score was changed, however you can only choose an exact value (ex. score was changed 40 points; score was changed 18 points). You cannot choose that the change was "greater than" 40 and include all score changes of 40 points, 41 points, 42 points etc.

1 reply

Devraj_Grewal
Devraj_GrewalAccepted solution
New Participant
November 10, 2016

Yes and no. You can bring in the filter "Score was changed" and use the constraint "change". This allows you to determine how much the score was changed, however you can only choose an exact value (ex. score was changed 40 points; score was changed 18 points). You cannot choose that the change was "greater than" 40 and include all score changes of 40 points, 41 points, 42 points etc.

Oliver_Zosel
New Participant
November 11, 2016

Thanks Devraj, that's a bit frustrating, but what can you do. I'm surprised there isn't a request to put such a measurement in, it seems like it'd be helpful.