How to calculate 3 week moving average using eazyBI

I'd like to create a plot that is updated daily with a 3 week moving average of how many story points are resolved. Mechanically this would mean looking at 3 weeks into the past and finding what the average story points resolved per day is and having that be one data point. Then the next day the same information would be pulled and a new average would be found and that would be the next data point and so forth conitnuously. If anyone has any insight on how to do this with JIRA dashboards or eazyBI it would be much appreciated. I haven't been able to find data the automates moving average graphs in connection with JIRA.

 

1 answer

Hi,

When time hierarchy level in a report is days, then this calculation will do the work:

Avg(
  LastPeriods(21, [Time].CurrentHierarchyMember),
  [Measures].[Story Points resolved]
)

When time hierarchy level in a report is weeks, then you may use 

Avg(
LastPeriods(3, [Time].CurrentHierarchyMember),
  [Measures].[Story Points resolved]

More about dynamic time periods (including function LastPeriods() ) you may find in the eazyBI documentation.

 

Zane
eazyBI Customer Support Consultant

@Zane Baranovska I want to tweak this to return me the same average but instead of story points, I'd like an issue count of resolved issues. Using the above code and swaping story points resolved for issue count only returned me the full count, and not the average. can you assist?

@John-Michael Talarico, your approach to change only the measure is correct.
For example, to calculate a three-week moving average for resolved issues, you may use measure Issues resolved and put it in a formula like this:

Avg(
LastPeriods(3, [Time].CurrentHierarchyMember),
[Measures].[Issues resolved]
)

Make sure that in Time dimension is selected the right hierarchy over which you would like to get running average (see picture below).

eazyBI_3_week_moving_avg_resolved_issues.png

 

 

Zane / support@eazybi.com

Thanks! this is great! I'll be working a lot more with the tool. Is the best means on contact through email or tagging eazyBI here?

You may use both channels. eazyBI Support is checking questions in Atlassian Community pages as well.

The community is a great power: if you ask the question there, you may get an answer from other experienced users, and this answer would benefit other users as well. Also, you may google the topic later, while, in your mailbox, it would get lost.

If you have a question specific to your business case or with sensitive information, you may reach eazyBI support via email.

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Bridget Sauer
Published yesterday in Marketplace Apps

Calling all developers––You're invited to Atlas Camp 2018

 Atlas Camp   is our developer event which will take place in Barcelona, Spain  from the 6th -7th of   September . This is a great opportunity to meet other developers and get n...

71 views 0 5
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you