I have an activity related dataset and I’m trying to build a calculated column that will group any rows that can be considered as a batch of “Trouble Time” together. The concept of this column is to group the rows and find the total amount of lost time due to a failure. Each row will get a “Y” flag if it is “Trouble Time” and/or a “Failure”, otherwise it’s marked as “N”. The tricky part for me is the association/assignment to the failure and avoiding the “N” rows. Once I can figure out the calculated column, I can sum the total time over this group value and that shouldn’t be a problem. Make sure to note that there can be multiple types of the same Failure_Desc, so I need to keep each event separate. I’ve attached a picture of the sample dataset and my goal for my calculated column… please ask any questions needed for clarification. Really appreciate the help!