8 Replies Latest reply on Aug 29, 2018 10:54 AM by Anuvir Singh

# Percent of total missing per value and location

To give a little background of the data. I am looking to find out how efficient the grocery store clerks are at scanning certain items in a large order. The customer ID represents "one opportunity to scan the 3 items". We have the data for 3 items and whether or not the clerk successfully scanned them in that customer ID visit.  I have made a calculated field to count the missing items because we are ultimately interested in the items that were missed.

1. Percent of total missing values per value of all customer ID's no matter the location

2. Percent of total missing values per value of all customer ID's BY location (so north only, south only, west only)

Please let me know if you have any questions.

Jessica

• ###### 1. Re: Percent of total missing per value and location

Hi Jessica,

Something like this?

This is just for Question 1. We can create something similar for Q2 as well.

~Tushar

• ###### 2. Re: Percent of total missing per value and location

Hello Tushar,

I am looking for the percent of total per clerk ID. For now we can disregard the clerk region and just find the percent of total values missing for each specific clerk. So for John it should be % apple missing=50%, % orange missing = 50% and % pickle missing = 25%

• ###### 3. Re: Percent of total missing per value and location

Is this the solution you are looking for?

• ###### 4. Re: Percent of total missing per value and location

Hello,

No I am just looking for the percent of total oranges missed over all possible oranges for that specific clerk. Then percent of total apples missed and pickles missed of same parameters.

Then I was looking to find the percent of total of each value missing for location specific only.

• ###### 5. Re: Percent of total missing per value and location

Let me know what is the result you are looking for for Q 1 & 2.

As per your previous reply shouldn't these be the numbers for percent of total per clerk id

• ###### 6. Re: Percent of total missing per value and location

What you have posted is what I believe I am looking for!!

So for each clerk.. have the percent of total of all values missing over total values per (all clerk specific)

Then for Q2 i am looking for the percent total missing per location.

• ###### 7. Re: Percent of total missing per value and location

That's what is in the attached worksheet. Please go through that. If your answers are different for any questions than mine please highlight them and let me know what should they be.

• ###### 8. Re: Percent of total missing per value and location

Hi Jessica,