Can you help on below issue
I have table of Task with field names
Case Id,
Status,
Created date,
Updated Date,
Resolved date,
Reload Date,
I would like to put below solution on Straight table like Status, number of cases and Avg days,
Status is categarized Backlog, Ready for Squad, In Process, Done
These status can Changes every day, Twice in a day, May remain same( In case of remain same, it will not repeat, untill data status changes)
We need to caculate age of every status means
If task is in Backlog on 1st May and status changes to In Process on 6 May, The Age of backlog will be 6. same way we need to caculate others staatus age also.
Filers should have From date and To date (From date and To date derived from reload date)
Above Calculatiuon Should be dynamic based on In date interval selected by User
Also once the status is changed for a case, the case should be counted only once in the new status and should ignore in the old status.
Thank you
