Hi!
I have a table in my script with Registered and Processed dates of tickets.
If the ticket wasnt processed according to target it's failed. And in my pivot i have the number of failed tickets according to processed dates.
However, the ticket can be registered in January, for example, with 10 days target. And this ticket can be processed in March.
So this ticket is failed starting from January till March.
Can I create some sort of expression in pivot to count such tickets the way I've explained above?
My sample data is attached.