Archive

Posts Tagged ‘parameter’

Tableau Dashboard Level Filter

June 10th, 2011 4 comments

Often in tableau you’ll find you need a filter that’s neither local of global, you will want a dashboard level filter. On a dashboard local filters are often too restrictive as they only alter 1 part of the dashboard, and to have 2 identical local filters on a dashboard also isn’t a valid option. To overcome that problem filters can also be global. This also comes with problems every worksheet from that data source is also forced to share that filter when you often don’t want to.

Currently there isn’t a dashboard level filter – i.e. a filter that’s local to everything on the dashboard only without affecting any other dashboards created from the same data source. Read more…

Tableau Advanced Date Filters

It’s possible using a combination of parameters, filters and calculated fields to create complex and advanced date filters in Tableau.

Say you want to see some a time period based upon a user selected time period. You can create a calculated field which will return a result based on what the user selected.

For this example you want the user to select a month, but you want to display results showing data from the month before the user selected month as well the selected month – i.e. the user selects Apr and you also need to display Mar as displayed in the visualisation.

This wouldn’t work with a standard filter, the user would need to select the months they were interested in one by one. Using a parameter and a calculated field is the way around this. Read more…

Tableau Parameter to Display Measures Selected by User

March 26th, 2011 2 comments

The introduction of parameters with Tableau 6 have made this software far more powerful. Intelligent use of these have made many things possible that we couldn’t do in previous versions including allowing the user to dynamically select which measures or dimensions they would like to see on the visualisation.

This could massively reduce the number of worksheets required. Where previously you would have needed to create 2 charts to show 2 different metrics now this is possible on one chart where the user can select what measure they want to see. Read more…