Check How Many Processes are in a Status at a certain day
I need some help with an issue!
I have a table in which I have a list of process codes (on column "Informação", and associated to each code, there is a Start_Date and an End_Date (which is equivalent to the start date from the next row, since the column "Attribute" is a status of the process. Like such:
What I need is to know for each day of the year, how many processes I had in each kind of "Attribute".