Forum Discussion

Dni's avatar
Dni
Frequent Visitor
2 years ago

Burndown chart for software tasks

Hello,   I'm trying to create a table containing data that will be used to create a burndown chart. As an inputs, I have two tables: 1. Dates: the table date corresponding to the list of dates for...
govindarajan_d's avatar
govindarajan_d
Icon for Super User rankSuper User
2 years ago

Hi Dni ,

 

New = number of tickets with last 'when' is "New" before the date. I am not able to understand this. Can you help us by posting a single calculation and how it is done?

Dni's avatar
Dni
Frequent Visitor
2 years ago

Hello,

thanks for the quick reply

 

Here is an example of something that is in a measure; same spirit:

    VAR _Summarized = SUMMARIZE(
        _History ,
        'History'[id] ,
        "@Last Date", MAX('History'[when] ) ,
        "@Last Status" , CALCULATE(
                            MAX('History'[status]),
                            FILTER(
                                _History,
                                'History'[when]= MAX ('History'[when])
                            )
                        )
    )  

 

Basically for each date in the calculated table I want to:

- Filter History to get only the dates before the reference date

(e.g. the first date in the Burndown table is 1/1/24. This is the reference date)

- Filter History to get the latest [when] for each id

(e.g if I have a when for id1 at 31/12/23 and 30/12/23, I'll keep only the 31/12/23 one)

- and Finally filter history to get the id in status New

 

and then, count the IDs that match these criteria, and fill the New with this value in Burndown