Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
yashdeep
Contributor III
Contributor III

Ticket resolved

How can we calculate ticket resolved per Engineer per day i.e how many tickets an engineer resolves per day.

Thanks in advance.

4 Replies
sebastianlettner
Partner - Creator
Partner - Creator

Hi,

please read this

QlikCommunity Tip: How to get answers to your post?

Regards

Sebastian Lettner

roger_stone
Creator III
Creator III

You'll need to be more specific than that but here are a couple of clues:

Day (or date) is a dimension

Engineer is a dimension

Count of tickets is an expression

Over to you.

yashdeep
Contributor III
Contributor III
Author

I have to calculate productivity of Engineer.

formula is" no.of tickets Resolved/Engg/Day"

I have following fields;

Ticket ID,Engg ID,Closing Date(Date on which Ticket Was Closed).

roger_stone
Creator III
Creator III

Something like this?

Respectfully suggest that you get some training as this is really basic stuff.