Need to generate a aging report based on the duration between stage to stage(stage value is like unactioned, call scheduled, meeting scheduled,closed).
| id | leadid | created date | old vale | new value | field | unactioned duration | call scheduled duration | meeting scheduled duration | closed duration |
| 1a | 2a | 01-Jan-22 | | unactioned | stage | | | | |
| 1b | 2a | 08-Feb-22 | 1 | 2 | priority | | | | |
| 1c | 2a | 18-Mar-22 | unactioned | call scheduled | stage | 76 | | | |
| 1d | 2a | 25-Apr-22 | call scheduled | meeting scheduled | stage | | 38 | | |
| 1e | 2a | 02-Jun-22 | meeting scheduled | closed | stage | | | 38 | 152 |
Calculations reuired.
| unactioned duration | call scheduled duration | meeting scheduled duration | closed duration |
| created date(minimum created date)- created date value(if field=stage & New Value=Call scheduled) | created date(if field=stage & old value=call scheduled) - created date(field=stage & new value=call scheduled) | created date(if field=stage & old value=meeting scheduled) - created date(field=stage & new value=meeting scheduled) | created date(if field=stage &new value=closed)- created date(minimum created date) |
