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

    Percent of total missing per value and location

    Jessica Rupnow

      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.

       

      Please help me show two different things.

      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