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

[Aravind Koushik Gobburu]

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

[Roberts Čāčus - eazyBI]

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:

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