Avg Resolved Tickets Per Agent Per Day in the Previous Month

Questions & Answers
1

Hi. New here and hopefully someone could point me in the right direction. I’ve done some searching in the forums but I do not see anything that can help me get the information above. Is it possible? Thanks in advance.

Example:
Agent 1: 21
Agent 2: 9 (he has some issues!)
Agent 3: 33
Etc.

2

Does anyone know if it’s possible to do the above? Thanks.

PS: I’m not requesting anyone actually make it, but if it’s possible and the best place to find the information on how to do it.

3

Hi @teak421,

With a user dimension, for example, Assignee in the report rows and the Time dimension in pages, you can define a calculated measure similar to the one below:

[Measures].[Issues resolved]
/
DateDiffDays(
  [Time].CurrentMember.StartDate,
  [Time].CurrentMember.NextStartDate
)

See an example below:

Screenshot 2023-02-03 at 18.29.10
Screenshot 2023-02-03 at 18.29.101548×976 78 KB

Please look at the eazyBI documentation page for more information on defining calculated measures - ​Calculated measures and members.

Best,
Roberts // support@eazybi.com

1 Like
4

Thanks for the direction…