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 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
Julia Dillon
Posted Tuesday in Jira

Tell us how your team runs on Jira!

Hey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...

389 views 1 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