Weekly comparison of data

Hi there,

I am trying to build a report that shows me the current% of resolved incidents and the situation of last week. I am able to calculate the % of issues resolved. However what I want to know is: At this time last week, how many % of incidents were resolved (independent of when those incidents were created). Is this possible in EazyBI?



To move in time, you can use the ParallelPeriod(…) function. It would return period parallel to the one specified.
So, if you have weeks on rows, you would get the previous week as follows.

ParallelPeriod([Time.Weekly].[Week], 1, [Time].CurrentHierarchyMember)

By adding that in a tuple with some other measure, you would get that measure value on the parallel week, e.g. issues resolved previous week:

  [Measures].[Issues resolved],
  ParallelPeriod([Time.Weekly].[Week], 1, [Time].CurrentHierarchyMember)

Lauma / support@eazybi.com

With eazyBI version 6.0 we added default calculations to compare data to previous periods. You can click on header of the measure Issues closed and select option: Add calculated>Time ago>year ago. This will create a new calculated measure (report specific) with the name Issue closed year ago

Here is how the two looks in one report:

Daina / support@eazybi.com


This worked, thank you for sharing.