eazyBI - how to load report with current week by default

Peter Bengov Community Champion Mar 21, 2016

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

This widget could not be displayed.

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 

Peter Bengov Community Champion Mar 27, 2016

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)?

Peter Bengov Community Champion Mar 27, 2016

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).

This widget could not be displayed.

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
Community showcase
Posted Tuesday in Jira

What modern development practices are at the heart of how your team delivers software?

Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...

266 views 1 3
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