eazyBI - how to load report with current week by default

I'm using a lot the option to drop-down the week number to populate the report's data with. 

eazybi wwekly.PNG

However, in dashboards with multiple reports of this kind it could be very useful if the week shown is the current week. Can this be configured?

Also - a feature request: dashboard-level dimensions. Instead of picking a time or any other dimension per report cube, add the option to add that dimension into the whole dashboard so it could update all reports right away. 

Thanks

2 answers

1 accepted

Hi Peter,

  1. You can create a 'Current week' calculated member with following calculated member formula (note that it has to be created in Time.Weekly hierarchy)

    Aggregate({[Time.Weekly].[Week].CurrentDateMember})

    Then you can use this calculated member instead of selecting the week in your reports - it will automatically always have the current week aggregated.

  2. Thank you for suggestion, but there already is such a feature - you can make the report page as common dashboard page. When the common page is changed all the reports that use this Page filter in dashboard will have the common page selection. See more details here https://docs.eazybi.com/display/EAZYBI/Create+dashboards#Createdashboards-Commondashboardpagedimensions.

Let me know if there is anything else I can assist you with!
Kind regards,
Lauma / support@eazybi.com 

Thanks a lot Lauma for both answers. 

Regarding #1 - is there a way I can combine the ability to show Current week with previous weeks (selected using a drop-down)?

Also, is there a way to take the last 4 weeks into account? Like instead of Current week set the filter to last 4 week. I've tried using this in the Time dimension calculated section, as per https://docs.eazybi.com/display/EAZYBI/Calculated+members#Calculatedmembers-Timedifferencecalculations:

Filter(
  [Time.Weekly].[Week].Members,
  DateBetween([Time.Weekly].[Week].CurrentMember.StartDate,'4 weeks ago','today')
)

But getting this error after hitting Create:

Formula is not valid: 
Member expression 'Filter([Time.Weekly].[Week].Members, DateBetween([Time.Weekly].[Week].CurrentMember.StartDate, "7 days ago", "today"))' must not be a set

Thanks for the help

Yes, you are on the right track for the formula as well. It is only necessary to put the Aggregate(..) function around the set 

Aggregate(
Filter(
  [Time.Weekly].[Week].Members,
  DateBetween([Time.Weekly].[Week].CurrentMember.StartDate,'4 weeks ago','today')
))

Please make sure you create the formula in the Weekly Time hierarchy (you can select the hierarchy on the top of formula editing screen - next to the calculated member name).

Hello, to chime in an adaptation. 
Setting the page to a calculated "Current Date Member" works for keeping the Dashboard fresh. However, the drop down items are listed in Ascending order with the current week on top. Instead of that jarring effect of newest to oldest. It be great to list the weeks in descending order. I didn't have much luck with the Order function so created this calculated member:

Aggregate({
[Time].[Current Week], 
[Time.Weekly].[Week].CurrentDateMember.Lag(1),
[Time.Weekly].[Week].CurrentDateMember.Lag(2),
[Time.Weekly].[Week].CurrentDateMember.Lag(3),
[Time.Weekly].[Week].CurrentDateMember.Lag(4),
[Time.Weekly].[Week].CurrentDateMember.Lag(5),
[Time.Weekly].[Week].CurrentDateMember.Lag(6),
[Time.Weekly].[Week].CurrentDateMember.Lag(7),
[Time.Weekly].[Week].CurrentDateMember.Lag(8),
[Time.Weekly].[Week].CurrentDateMember.Lag(9),
[Time.Weekly].[Week].CurrentDateMember.Lag(10)
})

Given we are only looking back X amount of weeks, it's not terrible. Hope this helps. 
 

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,796 views 11 18
Join discussion

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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot