Forum Discussion

macin's avatar
macin
Frequent Visitor
3 years ago

Resolved date for tickets

Hi, 

I have following example list of jira tickets:

 

 

 

Key1 | To do | 01.01.2022
Key1 | In progress | 01.02.2022
Key1 | To do | 01.03.2022
Key1 | Won't do | 01.04.2022
Key1 | To do | 01.05.2022
Key1 | Done | 01.06.2022
Key1 | Done | 07.06.2022
Key1 | Done | 001.08.2022

Key2 | To do | 01.01.2022
Key2 | In progress | 01.02.2022
Key2 | To do | 01.03.2022
Key2 | Won't do | 01.04.2022
Key2 | To do | 01.05.2022
Key2 | Done | 01.06.2022
Key2 | Done | 07.06.2022
Key2 | Done | 001.08.2022

 

 

Expected

Key1 | 01.06.2022
Key2 | 01.06.2022

 

I would like to have following data

To do start date (earliest date)

In progress start date (earliest date)

Done date (latest done but earliest out of all done events).

 

Note: there is a possiblity that there are multiple consequitive Done statuses, I am interested only in the date against the Done status, which is later thna all other statuses that are not done.

 

I dont want to include Done dates which were Done at some point of time but afterwards they were reopened work done and then multiple tasks after done.What would you suggest?

 

I tried grouping but it always seems Iwill need to look at each row individually compared to previosy 

Show and Tell
Tips and Tricks

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    macin , Try a measure like

     

    new meausre =
    var _max = maxx(filter(all(Table), Table[Key] = max(Table[Key]) && not(Table[Status] in {"Done"}) ), Table[Date])
    return
    Minx(filter(all(Table), Table[Key] = max(Table[Key]) && Table[Status] in {"Done"} && Table[Date] >_max ), Table[Date])