Tag Archives: hiding

Keeping a Value in Totals Whilst Excluding from Quick Filter List

Over at Peter Gilk’s Paint by Numbers blog there was a question on this post on filtering while retaining results. Here’s the what Jeremy asked:

May I ask if it would be possible to get a detailed explanation of applying this principle to a different type of data?

For example, I would like to see the US Sales totals, and have the ability to filter it to a US state without the ability to select a US territory (Guam, Puerto Rico, etc), but to have the US territory sales remain in the US national totals. How could I do this?

In this short post I cover two different techniques how to do this using a self-data blend and LOD expressions, respectively.

Continue reading

Filtering and Hiding

Joe Mako’s Order of filtering post:

http://www.tableausoftware.com/support/forum/topic/question-how-create-product-velocity-calculation#comment-39603

A long post on global filters, action filters, etc.
http://community.tableausoftware.com/thread/109284

Global filter across data sources (parameter with calc field to test the parameter)
http://vizwiz.blogspot.com/2012/06/create-global-filter-in-tableau-across.html

Complex sorts in table calcs
http://community.tableausoftware.com/thread/109013

use as filter is faster than quick filters

Use as filter can work on any clickable element in the view

  • Edit actions to change what they use
  • see the TCC11 – JediTricks video for some funky global filtering

(use in nursing dashboard for per-unit stuff?)

Type-in on a quick filter is used as a wildcard, to change this use a type-in parameter and then a calc field with:

[ID] == [ID Parameter]

That will return true for the one row of interest and false for everything else. Just put that on the filter shelf and select just “true” (you’ll need to set the parameter to a value that exists to have the “true” option available).

Can’t drag a filter

If a pill can’t be dragged onto the filter shelf, try converting it into a continuous.

Lookup0 to make filters work locally after all db calculations are done. Handy to filter in %ofTotal calc. #tableaujedi #TCC11
by mohanganeesh at 10/18/11 2:38 PM

Hide happens after the data calculations. Filter happens before. Very handy to use hide in % of total calc. #tableaujedi #TCC11

Here’s a hiding link using the LOOKUP() trick:
http://community.tableausoftware.com/message/172343
File is Hide via Filter on Table Calc.twbx.zip.

Create a field called Date Filter w/value LOOKUP(ATTR([date]),0). Tableau will treat it as a date for the filter functions, but still have all data available to the calculations.

Hide (filter) rows if first column is empty
http://community.tableausoftware.com/thread/116249

Filtering first year out of YoY calculations:
http://kb.tableausoftware.com/articles/knowledgebase/filter-first-year

Filtering YoY to same month/day as current date:
http://www.freakalytics.com/2012/06/05/balancing-analysis-of-multiple-years-by-filtering-through-the-same-monthday-as-today/

Grabbing certain prior dates out of the data with user-selectable “filter”:

one way to filter for data within specific dates:
http://community.tableausoftware.com/thread/116985

http://community.tableausoftware.com/message/175953#175953

IF [scanDate] >=[StartDate] AND [scanDate] <= [EndDate] THEN "Keep" ELSE "Remove" END

Restrict filter options in a Quick Filter based on another Filter

Mark Jackson demonstrates a couple of options in http://community.tableausoftware.com/message/210455#210455

Can use Action Filter

Find first month in a set of data

My response to http://community.tableausoftware.com/message/177996

which is based on: http://community.tableausoftware.com/message/168597#168597
workbook is running sum of count distinct.twbx

IF TOTAL(MIN([Month of Install]))=ATTR([Month of Install]) THEN 1 ELSE 0 END

Calculation uses TOTAL which doesn’t care about sorting/addressing, so it’s a lot more bulletproof.

Another one for last date:

As an alternative to LAST()==0 from Ross Bunker in http://community.tableausoftware.com/message/178251#178251

ATTR([Order Date]) == WINDOW_MAX(ATTR([Order Date]))

Hiding certain items/dimensions in a % of total

For hiding certain items/dimensions in a % of total – e.g. PrimeCare/Non-PrimeCare/Null, just show % of total that is PrimeCare

1.     Create a calculated field called “Hide [Dimension]” with calc:

LOOKUP(MIN([dimension]),0)

results in “find my value” when the [dimension] is in the level of detail 2. Add that calc field to the level of detail 3. Create a Quick Filter on the calc field

Enjoy!

from TCC11 – JediTricks video

Using a set:
http://community.tableausoftware.com/thread/109355
and attached workbook (upgraded so it will work with current data)

Using a simple IF statement:

A way to “filter” dates by using LOOKUP()
http://community.tableausoftware.com/thread/115403
full_running.twbx workbook, simpler solution worksheet

Create a calculated field that is LOOKUP([Date],0) and make it continuous. Put it on the filter shelf for Range of Dates and leave it at that. When the user changes the slider, the range will change.

Hide NULL values

http://onlinehelp.tableausoftware.com/v5.2/online/Output/wwhelp/wwhimpl/common/html/wwhelp.htm?context=Tableau_Online_Help&file=Tableau%2520Online%2520Help-29-24.html

Dashboards and filters

http://vizwiz.blogspot.com/2011/08/tableau-tip-local-vs-global-filters-on.html

http://reports4u.co.uk/2011/06/10/tableau-dashboard-level-filter/

Robert Morton with a bit on when filters might not be able to properly compute the domain: http://community.tableausoftware.com/message/215056#215056

Data source filters are not applied directly to the data that is extracted, instead are added to each query. Post from Robert Morton: http://community.tableausoftware.com/message/227815


A Rough Guide to Tableau Filter Actions by Peter Gilks - Added December 20, 2014

http://paintbynumbersblog.blogspot.co.uk/2014/10/a-rough-guide-to-tableau-dashboard.html


Related posts:

  • Feature Geek: Filtering by Discrete Regular Aggregate Pills in v9.2
  • Keeping a Value in Totals Whilst Excluding from Quick Filter List
  • How to Have Sets with Your Secondary (Data Sources)
  • Parameters
  • A New Compact (Mostly) Filter Layout for Showing All the Options
  • Creating a Dynamic "Parameter" with a Tableau Data Blend
  • Top 10 Table Calculations - The Next N, Where N >= 15
  • Identifying (and Using) Quick Filter Selection Status
  • Parameters

    Sheet Selector & Worksheet Swapping

    http://vizpainter.com/sheet-selection-on-steroids/

    http://www.tableausoftware.com/support/forum/topic/using-parameters-i-created-dynamic-dashboard-swaps-visuals

    http://www.alansmitheepresents.org/2011/03/changing-viz-types-with-dashboard.html

    http://community.tableausoftware.com/thread/109920

    http://kb.tableausoftware.com/articles/knowledgebase/creating-sheet-selector-for-dashboard

    https://www.interworks.com/blogs/dwyers/2012/05/10/using-layout-containers-hide-views-your-tableau-dashboard

    Using SIZE() to change what type of data is shown. Doesn’t use a parameter, but is in the category of “change the dashboard based on some factor” that the above links all use:

    http://www.alansmitheepresents.org/2014/03/inline-filtering-using-tableau-size.html

    Changing Hierarchies and Swapping Measures

    http://www.clearlyandsimply.com/clearly_and_simply/2012/03/dynamic-hierarchies-with-tableau.html

    http://kb.tableausoftware.com/articles/knowledgebase/parameterized-measure

    alternatively, hide using action filters

    http://community.tableausoftware.com/thread/117501

    URLs and URL Parameters for Reports
    http://www.tableausoftware.com/support/forum/topic/url-parameter-report-pdf-format#comment-44996
    http://www.tableausoftware.com/support/forum/topic/passing-filter-parameters-url

    Note: URL parameters for boolean fields must be lowercase “true” or “false”, not “False”, “FALSE”, 0, etc.

    Related posts:

  • Dashboards
  • Creating a Dynamic "Parameter" with a Tableau Data Blend
  • Unexpected Results: Aliases in URL Parameters
  • Dynamic secondary axis titles (in a few more minutes)