 How to add a declining ideal trend line? y = mx + b

I’m looking to add a declining line representing the ideal trend of test cases per day.

For example, 100 test cases over the next 10 working days, getting to 0 by the end.

y = -10x + 100 eazyBI performs a calculation per each row (per each day if you use days on Rows). You would like to reduce the calculation for burndown to y = mx, where

• x is a rank value for each day (it should be descending for burn-down and ascending for burn-up)
• m is a pace per day

You would apply the filter for what days eazyBI should draw a line as well:

CASE WHEN
-- draw a line on those days:
DateBetween([Time].CurrentHierarchyMember.StartDate,
"Today",
)
THEN
-- calculate a pace as total value divided by the number of days to burn it
-- use any measure (or value) representing scope to burn
(([Measures].[Open issues],
[Time].CurrentHierarchy.DefaultMember)
/
-- burn in 10 days
10 )
*
-- day's rate in the period
(
10 -
DateDiffWorkdays(
"Tomorow",
[Time].CurrentHierarchyMember.NextStartDate
)
)
END

I used a measure Open issues for this formula. You can use any other value or measure there. I used this measure in a tuple with Time (it represents total value in this measure for today).

Daina / support@eazybi.com