Spreading a constant value over time

Hi! I’m looking to create a report that compares time spent with a set budget for a certain period.
I can get the time spent just fine, but I’m looking for a way to spread out a fixed budget value (let’s say 10.000 hours for a year) over that period (~192 per week). I’m trying to recreate a certain view from Tempo Budgets in Jira (image attached below).

Can anyone help me with this?

Hi @Joel_Christ ,
eazyBI doesn’t have integration with Tempo Budgets, but here is the formula that you can use to calculate the Burn-up and Burn-down line.

  1. To get the report “Start date”:
ConstantValue(
    VisibleRowsSet().Item(0).item(0).StartDate
)
  1. To get the report “End date”:
ConstantValue(
    DateAddDays(
      Tail(
        VisibleRowsSet(),
        1
      ).Item(0).item(0).NextStartDate,
    -1)
)
  1. You need to have some value to burn. In my example, I am using “Original estimate value” in the report’s first month:
([Measures].[Original estimated hours],
VisibleRowsSet().Item(0).item(0))
  1. And then all can be combined to create a measure of “Burn up”:
CASE WHEN
  DateBetween([Time].CurrentHierarchyMember.StartDate,
    [Measures].[Start date],
    [Measures].[End date]
  )
THEN
  [Measures].[Burn] *
    (DateDiffWorkdays(
      [Measures].[Start date],
      DateAddDays([Measures].[End date], 1)
    )
     -
    DateDiffWorkdays(
      [Time].CurrentHierarchyMember.NextStartDate,     
      DateAddDays([Measures].[End date], 1)
    )
  )
  /
  DateDiffWorkdays(
    DateWithoutTime([Measures].[Start date]),
    DateAddDays([Measures].[End date], 1)
  )
END
  1. Or you can create a measure “Burn down”
CASE WHEN
  DateBetween([Time].CurrentHierarchyMember.StartDate,
    [Measures].[Start date],
    [Measures].[End date]
  )
THEN
[Measures].[Burn] *
    (DateDiffWorkdays(
      [Measures].[Start date],
      DateAddDays([Measures].[End date], 1)
    )
     -
    DateDiffWorkdays(
      [Measures].[Start date],
      [Time].CurrentHierarchyMember.NextStartDate
    )) /
  DateDiffWorkdays(
    DateWithoutTime([Measures].[Start date]),
    DateAddDays([Measures].[End date], 1)
  )
END

In the report, it looks like this:

Best,
Gerda // support@eazybi.com

Hi @gerda.grantina,

Hope this message finds you well!

I am trying to achieve exactly what is mentioned here by Joel.

I have followed exact steps mentioned by you, but I do not get any error or output.

How can I resolve it?

Thanks,
Ganesh Satav

Hi @Ganesh_Satav ,
Please share more details on your steps and what is not working.
Without more details, it is hard to comment on why something is not working as expected as I am not familiar with your setup and Jira configuration.

You can also share those details directly by sending them to support@eazybi.com

best,
Gerda

Hi @gerda.grantina,

Sure, I will share more details.

Please let me know what are the details you require from my side to help in resolving this issue. I will be glad to share the same.

Also I have raised a support request through Market place to help me on this topic.

Thanks,
Ganesh Satav

Hi @Ganesh_Satav ,
If you wrote to support@eazybi.com, then one of my colleagues will take care of your request and ask for additional information if needed.

best,
Gerda

Hi @gerda.grantina,

I have raised request through market place. The request is raised to support.
Thank you for your reply.

Thanks,
Ganesh Satav

1 Like