Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,300,435
Community Members
 
Community Events
165
Community Groups

How can we get eazybi reports for current and past two weeks

We have a requirement to.get a report of past two weeks created vs resolved reports.How can we get the reports for current and past two weeks reports at a time

1 answer

Hi @Aravind Koushik Gobburu 

You can use the Time dimension in the report rows or columns. Where you put it depends your current report configuration.

You can then select the predefined calculated members "Current week" and "Previous week" in the Time dimension. Or define a new calculated member to aggregate the past two weeks. See the suggested formula below:

Aggregate(
[Time.Weekly].[Week].DateMembersBetween('2 weeks ago', 'today')
)

Once you have the Time dimension calculated members selected, the measures "Issues created" and "Issues resolved" will display the number of issues in each period. The report could look similar to the one below:

Screenshot 2022-05-19 at 09.05.23.png

Please visit the eazyBI documentation page for more details on defining calculated members - https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members#Calculatedmeasuresandmembers-Howtodefineanewcalculatedmember.

Best,
Roberts // support@eazybi.com

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you