Forum Discussion
Running Total Burndown
The data for JIRA looks like:
The shared calendar:
And what im getting as far as the UI
- kushanNa1 year agoSuper User
Hi,
from the screenshot you have provided here are my thoughts about it
- A cumulative total, month-over-month. - your line seems to be correct because i can only see Feb and march in resolved column
- Show all the months of the year even if we don't have any data for future months. - there are blank months so i can see you got that right as well
- For future months, don't show a flat line, don't show any line. Show only up until current month basically.- for this you will need to do the following
create a new dax calculated column in date table which it says if it part of this month or before
NewColumn = IF([Date] <= EOMONTH(TODAY(), 0), "Yes", "No") and filter the yes only (SS is a sample i tested not your data)
- Filter for issues that have status of Done.
you can simply drag and drop status column to filters and filter only done - Start from target number (i.e 40) and burn down to zero. - i can see a burning down in your sample line chart , so i feel like you got that right as well
- thegreenoz1 year agoFrequent Visitor
Thanks I have added that. The one thing missing in my chart is that it should start at 40 and count downward. So I tried the following but getting a V-shaped chart.
- manikumar341 year agoSolution Sage
thegreenoz ,
try this,
Burndown_Chart =
VAR MaxResolvedDate =
MAX ( 'JIRA_CICD'[Resolved] ) -- Get the latest resolved issue date
VAR TargetValue = 40 -- Set your starting target value
VAR IssuesResolved =
CALCULATE (
COUNT ( 'JIRA_CICD'[Issue key] ),
'JIRA_CICD'[Status] = "Done",
'JIRA_CICD'[Resolved] <= MAX ( 'Calendar'[Date] ) -- Include only up to current month
)
RETURN
IF (
MAX ( 'Calendar'[Date] ) <= MaxResolvedDate, -- Show data only up to resolved dates
TargetValue - IssuesResolved, -- Subtract cumulative resolved issues from target
BLANK () -- Hide future months
)- thegreenoz1 year agoFrequent Visitor
Thanks for that. Unfortunately the line goes up after the current month again.
- thegreenoz1 year agoFrequent Visitor
Hi, also we shouldnt go from 10 to 1, this is a month over month and not an accumulated tally which should be adding (increasing) overtime)