Most recent issue

Hi,

We have a custom field called “client” which contains the name of the client making the request, with all requests in the same project. What we would like to report on is the time (number of days) since the last ticket was raised by client. So would see a table something like:

Client    |    Days since last issue
A                      5
B                      1
C                      10
D                      3

I can get all the data into EazyBI but I’m wondering how I report on the time since the last issue for each client.

Thanks

Hi @jcandiloro,

Yes, you can build such a report and a calculated measure to see days since the last issue the Client has reported.
You may construct a calculation like this. First, look for the date of the last created issues by going through all days in the Time dimension and picking the latest day with created issues. Then you may calculate days between the last found date for a customer and today.

The formula might look like this:

DateDiffDays(
  --date of the last reported issue
  Tail(
    --go through days in Time dimension
    Filter([Time].[Day].Members,
      --last day when issue is created for selected Client
      DefaultContext((
        [Measures].[Issues created],
        [Time].CurrentHierarchyMember,
        [Client].CurrentHierarchyMember
      )) > 0
    )
    --transform Time member to date for further calcaultions
    ,1).Item(0).StartDate,
  'today'
)  

More details on calculated measures and used function you can find there:
https://docs.eazybi.com/eazybijira/analyze-and-visualize/calculated-measures-and-members
https://docs.eazybi.com/eazybijira/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference

Best,
Zane / support@eazyBI.com