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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.