Avg Resolved Tickets Per Agent Per Day in the Previous Month

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.

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

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.

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]

See an example below:

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

Roberts // support@eazybi.com

1 Like

Thanks for the direction…