Count of quarters a deal's close date is pushed

[Anonymous]

Thursday

Hey everyone, I have Salesforce object that acts as a change log report that captures key changed values.

Example of that object here: Example Data. The field "Changed Value(s)" denotes what has changed on each record.

I'm trying to put together a report that let's me know how many times each opportunity's "Close Date" has been 'pushed' out 2 quarters. Not just one change resulting in a close date 2 quarters out, but at least 2 changes. Trying to assess pipeline health by gaining visiblity of opportunities that are just being moved and moved - if that makes sense. 

Ideally I'd be able to just filter on a field or something that would let me display how many opportunities with Close Dates in this Quarter/Next Quarter/etc. have been moved 1, 2, 3, 4, 5, 6+ etc. times.

[Anonymous]

Hey everyone, I have Salesforce object that acts as a change log report that captures key changed values.

Example of that object here: Example Data. The field "Changed Value(s)" denotes what has changed on each record.

I'm trying to put together a report that let's me know how many times each opportunity's "Close Date" has been 'pushed' out 2 quarters. Not just one change resulting in a close date 2 quarters out, but at least 2 changes. Trying to assess pipeline health by gaining visiblity of opportunities that are just being moved and moved - if that makes sense. 

Ideally I'd be able to just filter on a field or something that would let me display how many opportunities with Close Dates in this Quarter/Next Quarter/etc. have been moved 1, 2, 3, 4, 5, 6+ etc. times.

[Icey]

Hi @Anonymous ,

Maybe you can create an example to show what you want. Just like below:

Best Regards,

Icey