I want to find out how many distinct individuals have clocked in per day in VA. Imagine a person clocks in every time they enter a building. I don't care if they enter building multiply times a day, but want to know how many unique individuals clock in per day. Data I have is f.i. like this: Monday John Monday John Monday Michael Monday Jake Monday Bob Tuesday Bob Tuesday Jake Tuesday Michael Tuesday John Wednesday Bob Wednesday Bob Wednesday Jake Thursday Charles Thursday Jacob Thursday John Thursday Bob Thursday Bob Friday Charles Friday John Friday Charles Friday Bob Friday Jake Friday John If I use just a 'Count' on the "Name" then I get 23, which is not what I'm after, since this counts all duplicates during a day. If I use 'Distinct' then I get 6, which is not what I'm after either, since it won't separate days. I want a total Distinct count per day, so the number I'm after from this example is 18. So I want a dashboard to saying that number 18, fairly simple to achieve in Excel but I can't figure out how to do this in VA. Basically I need a 'Distinct' count for all values in "Monday" then a 'Distinct' count for all values in "Tuesday" and so on. Then I need to summarize the days to get to the total for the week. Is this possible to achieve directly in VA? Or would I need to prep data and create a separate column for each day?
... View more