Total Bar Does Not Match Rows in View

tableaucommunity@tableau.com — Thu, 30 Oct 2014 16:26:25 GMT

I have created a fairly complex view that allows business users to rank products by a number of different e-commerce metrics (eg, sales, units sold, page views) and filter for date/date range, type of product, product hierarchy, etc.. There is also a filter that allows the user to define the number of records to display. For example, they can ask to see the top 20 products by page views for Sept 1 - 7th that are under the category of jewelry. I constructed the 'Number of Products' filter by creating a calculated field 'Rank' defined as RUNNING_SUM(MIN([Number of Records])) and then displaying the quick filter, which then allows the user to define a range.

The issue I'm having is that the default Total row seems to be calculated prior to the 'Number of Products' filter, such that the total displayed is all applicable records that match the filter conditions. How do I set up the Total bar to understand that I would only like to sum the rows that are in the view itself.

Thanks!

Best way to alias quickfilter on a set

tableaucommunity@tableau.com — Wed, 30 Oct 2013 18:41:58 GMT

I have a workbook that ranks products by a number of different e-commerce metrics.

I want to include a filter that allows the user to select to display:

(1) only products that have sold at least one unit [items sold <> 0]

(2) only products that have sold no units [items sold = 0]

(3) all products

I achieved this by creating a set of product IDs with the condition Items Sold = 0. Then made it a quick filter. The problem is that the naming on the resulting filter is not very user friendly for my non-technical business users.

My question is whether it is possible to alias the existing quickfilter, or if it is possible to solve the problem in another way which allows me to clearly label the filter conditions in the 1, 2, 3 format above. I tried to use a parameter and a calculated field to decode, but neither a case or if statement is valid because it's a boolean.

Content in Tableau Community Forums

Total Bar Does Not Match Rows in View

Best way to alias quickfilter on a set