Hi Tableau Community,
My first post and I am super new to Tableau. Hoping someone can help
Objective: Calculate time per issue in each Status Category
The workbook attached contains issue status changes from a Jira instance. The status categories identify the high-level issue status categories. The Status
2 = To Do
4 = In Progress
3 = Done
An issue can transition between statuses that belong to one of the categories. For example,
- it can transition from Backlog status to To Do status that are both status category 2
- it can transition from To Do status to Defining status that is from status category 2 to 4
- it can transition from Defining to Done which is of status category 4 to 3
- it can transition from Done to Deployed which is both of status category 4
Hence, below are the calculations I need to perform. Note, the day the status changed from one category to the other is captured in the "Changed" column of the workbook.
Days per issue in "To Do" status category = Total number of Days spent by issue in Column "Statuscategory" set to 2 AND "Statuscategory1" set to 2
Days per issue in "In Progress" status category = Total number of (Days spent by issue in Column "Statuscategory" set to 2 OR Days spent by issue in Column "Statuscategory" set to 4) AND "Statuscategory1" set to 4
Days per issue in "Done" status category = Total number of (Days spent by issue in Column "Statuscategory" set to 4 OR Days spent by issue in Column "Statuscategory" set to 3) AND "Statuscategory1" set to 3
I have tried using fixed LoD but no luck. Workbook attached. Any idea how to calculate the time spent?
Thanks in advance and thanks Saransh Chaudhary for helping me clarify the question.
Message was edited by: Bhushan Nagaraj Clarifying the question based on solution provided by Saransh Chaudhary
