I have created a report based on How much total time spent in each status - #2 by gerda.zandersone, but after validating the data, it seems like the total is not right as the logic of “Days in transition status” measure is just sum up all the epic, story and sub-task hours without consider parent-child relationship in the calculation.
Taking below as example where SubTask 1.1 and 1.2 are child of Story 1,
Story 1 - 6 hours
SubTask 1.1 - 3 hours
SubTask 1.2 - 3 hours
I am expecting the total value would like 6 hours rather than 12 hours.