nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

eazyBI - how to load report with current week by default

Peter Bengov

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

eazybi wwekly.PNG

Accepted answers

Lauma Cīrule

Hi Peter,

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

All comments

Lauma Cīrule

Hi Peter,

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

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

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

Lauma Cīrule

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

Adam Schultz_hz2e8b

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.

Satish_Kumar

EazyBI demo page has a simpler solution for WeeklyReverse order, check it out at https://eazybi.com/accounts/1000/cubes/Issues/reports/63909-issues-created-vs-resolved-by-priority

There is a calculated Time Dimension, WeeklyReverse order. The formula they have given is below & it seems to work well. Thanks eazyBI Team.

Aggregate(
Order(
[Time.Weekly].[Week].Members,
[TIme].CurrentHierarchyMember.StartDate, DESC))

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-software

jira-administration

eazybi

addon-com.eazybi.jira.plugins.eazybi-jira