for each category, calculate the date difference (DATEDIFF) between "closed at" date of a row with "closed" status and the "opened at" date of the rows with an "open" status.
The objective is to have an extra column to the right, with these values:
The code checks if the status is open for that row
If so, you will do a datediff, as you already suggested. First you take the 'opened at' date, secondly, you create a Pull-up fuction, that looks for all the categories in the 'category' column. for each category, it will take the last value of the 'closed at' column, where 'status' is 'closed'.
The code checks if the status is open for that row
If so, you will do a datediff, as you already suggested. First you take the 'opened at' date, secondly, you create a Pull-up fuction, that looks for all the categories in the 'category' column. for each category, it will take the last value of the 'closed at' column, where 'status' is 'closed'.
The code checks if the status is open for that row
If so, you will do a datediff, as you already suggested. First you take the 'opened at' date, secondly, you create a Pull-up fuction, that looks for all the categories in the 'category' column. for each category, it will take the last value of the 'closed at' column, where 'status' is 'closed'.
The logic is as follows:
