For each row calculation

[AshleyM]

I am new to qliksense and trying to create a dashboard to show productivity based on the number of tickets a person works per hour each day.

The data I have is below but I don't know how to put the calculation in to qlik. It needs to be for each day (dt) divide the number of hours worked by the number of tickets cleared then give a percentage depending on how close the outcome is to 4 (it can be over 100% if it works out to be more than 4 per hour)

Any help would be much appreciated. Please let me know if I haven't explained myself properly.

[Or]

It's not really clear from the data how many hours were actually worked - these numbers don't seem to be in any reasonable format. Generally speaking, though, it seems like a relatively straightforward case of Sum(Hours) / Sum(Ticketscleared) once the hours field is converted to actual hours (I'm guessing nobody worked 75057 hours in a day).

[AshleyM]

Thanks for your response @Or I will check the data as I hadn't noticed that but once that is sorted how do I do a calculation for each person, each day? And get a percentage based on how close to 4 the result is?

[Or · Accepted solution]

If your table contains the person ID and the date, the measure will work per person and date. That's just how Qlik works - measures are calculated per the dimensions in the object (unless specified otherwise).