Counting number of times a field is changed from one option to a selection of other options

[Staxed]

This is my first time doing anything with reporting, so please excuse me if this is a simple question.

I need to be able to track the number of times a specific field is changed from one option to one of a set of options. I also need it to be history based so they can choose a time period, or "last month", "last quarter" if possible.

Field: Assignment Group

If it's changed from option 1 to any of {option2,3,4,5}...i need to be able to count that change (but not the other way around.  The field is currently being audited, but that counter simple counters the number of times it's changed at all...I need to only count very specific changes.  Since this is my first time at auditing/reporting on something like this, I'm at a loss of even where to begin.

Hopefully that makes sense.

[Community Alums · Accepted solution]

Hi

If this is critical to your reporting, the easiest way to achieve this would be to add a field to the table (that's not displayed by default on forms or lists, and is read only). You can then use a flow or business rule to increment the counter during the conditions you want to count. 

Then it will be available on any dashboards and reports that you need it to. 

Mike