Vova Member

Comments

  • I was able to resolve it using a card Rank and Window and LAG 1 to have a new column with next status timestamp. I also added same LAG 1 for the next status name so I can see which status is going after IN QA status. Thank you again
    in How To Calculate Time In Status? Comment by Vova June 20
  • Thank you, David for your quick response. Is there a way to Pivot on per-ticket \ per In-QA status basis? I am not sure how the ranking will happen if I Pivot since one ticket may have multiple transitions from "In QA". Ticket Status Timestamp JIRA-3 Verified (Ready to Deploy) 2024-01-03T14:32:45 JIRA-3 IN QA/REVIEW…
    in How To Calculate Time In Status? Comment by Vova June 20
  • I have learned what I did wrong. Even though I did join the calendar, I had to add Group BY to the data to correctly count the number of items per day so that the chart can show 0 if I had no items in a month. I will mark my question as resolved.
    in Broken Trend Chart With No Data Comment by Vova December 2022
Default Avatar