Home > Tableau > Tableau Dynamic Linked Parameters

Tableau Dynamic Linked Parameters

November 26th, 2011 Leave a comment Go to comments

The first thing to tell you is this isn’t possible, one of the few weaknesses in Tableau.

I wanted to set up 2 parameters in Tableau, the first would be a start date, the second an end date. What I wanted to do should be straightforward – to set the values available in the end date based on what was selected in the start date parameter – so the earliest date available in the end date parameter is the same as the value selected in the start date parameter.

The first thing I did was create a calculated field to return values based on the result of the start date parameter – i.e. If  Date >= Start Date parameter Then Date End. I used this calculated field to set the min and max date range in the parameter and thought that would be parameter set up complete.

I displayed the 2 linked parameters on the sheet and tested it. I altered the values in the Start Date parameter expecting the values available in the End Date parameter to alter…but nothing happened. This was surprising so I spent an hour or so going through the calculated field, checking if it was working correctly, trying to work out what I’d done wrong but couldn’t find anything incorrect in my workings.

My next stop was Google…and I eventually came across this post on the Tableau forums where it says:

“> to be able to restrict the available dates of one parameters according to the other
Not currently possible, another very nice idea for a feature request.”

Disappointing as I assumed this would be – and it should be – standard for a software as powerful as Tableau.

  1. Ujval Gandhi
    November 27th, 2011 at 23:05 | #1

    I completely agree — Parameters are so close yet so far..

    One of my pet peeves is the lack of capability of extending the tool-tips – I think it is another powerful feature that is not fully utilized

    Regards,
    Ujval

    • Andrew
      November 29th, 2011 at 18:29 | #2

      Agree with you on the tooltips although I heard Tableau 7 will have improvements in this area. I guess it’s a case of watch this space for when it’s released.

  2. Ujval Gandhi
    December 8th, 2011 at 12:41 | #3

    I looked @ the 7.0 build – Nothing major in the terms of the tool-tips. The only ‘extension’ is in the Keep/Exclude feature, I was really hoping to see “insert images”, support for html, etc in the tool-tips.

  1. No trackbacks yet.