Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Aravind Koushik Gobburu
Contributor
May 17, 2022

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

0 votes
Roberts Čāčus - eazyBI
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 19, 2022

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