7 Replies Latest reply on Sep 4, 2018 2:46 PM by Shinichiro Murakami

# Show percent of total and discrete count in columns

Hello,

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. Include a discrete count of how many in that variable were missed.

I am looking to show the percent of total and distinct count of the variables in the same table. The numbers need to be variable specific and only show percent of total and count distinct for that variable. I have posted a workbook and example of the table I am looking for. Thanks!!

Jessica

• ###### 1. Re: Show percent of total and discrete count in columns

Not exactly sure, but probably this approach works?

Thanks,

Shin

• ###### 2. Re: Show percent of total and discrete count in columns

Hello,

The data I am working with is not from excel so the pivot option is not available. Is there a different way around this?

• ###### 3. Re: Show percent of total and discrete count in columns

Hello,

Was wondering if you had any alternative options to this? My data source is not excel.

Thanks!

Jessica

• ###### 4. Re: Show percent of total and discrete count in columns

What is the connection?

Shin

• ###### 5. Re: Show percent of total and discrete count in columns

There are Very troublesome way to create that view.

With creating Each specific % calc field and crate manual place holders.

Visit this link for detail

Such a simple view, it required 100 steps!! - Having Multiple KPIs - - Still Struggling with Excel ?? <Tableau's Room>

Thanks,

Shin

• ###### 6. Re: Show percent of total and discrete count in columns

SQL