# 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

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

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

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

Thanks,
Ganesh Satav

1 Like