Weekly open Bugs

Questions & Answers
, ,
1

We have report to show “Open Production Bugs” in each week from Jan-1-2024 through ? Currently I’m editing all the graphs each Monday to add the latest week. I’ve tried a few things but no luck yet. Any idea on this how can be achieved ?

I guess we need a calculated member/measure for “every week this year” - something like that.

2

Hello @Ajay,

Thanks for posting your question!

There are a couple of things you can do:

  1. Create a new calculated member (Calculated members in Time dimension) that aggregates weeks of the current year until the current day (today):
Aggregate(
  [Time.Weekly].[Week].DateMembersBetween(
    '01 Jan 2024', 'today')
)

Please note that you need to choose “Time.Weekly” hierarchy in the dropdown menu:

image.png
image.png1774×968 104 KB

  1. Adjust import options to automatically generate Time members 6 days ahead, so you would always have it displayed even if there is no activity for that week yet. You can read more about this in our documentation here:
    Data from Jira

image.png
image.png1526×816 66.1 KB

Best,
Marita // support@eazybi.com