Why Vizioneer?

My photo
Atlanta, Georgia, United States
The "Vizioneer" comes from mashing two words that have shaped my world for most of my adult life - Engineer and [data] Visualizations (or Vizes to those who know what's up). Graduating from first from Oglethorpe University in Atlanta, followed by Georgia Tech with my Bachelors and Masters in Civil Engineering, all of which taught me to think through anything and everything - problem solving, "engineering" solutions, teaching to the "ah ha" moments - is what I love to do. In 2010 that investigative, engineering mindset intersected a job change and a plunge into the world of Data Analysis. In the search for the next great thing I stumbled on to a data visualization and dashboarding product called Tableau software and things just took off. So now I guess you could call me that engineer with the sweet data visualizations - or just "The Vizioneer" :)

In 2013, I joined the incredible team at Slalom, focusing on Tableau and it's been an amazing experience. Recently in 2014, I was honored and humbled to receive Tableau's highest recognition of being named a Tableau Zen Master. Follow along to see what happens next :)

Wednesday, June 18, 2014

Dynamic Parameters - a sorta hack

...And we're back.

It's been a little more than six weeks since I've saddled up and hopped on the blog.  The #Tableau30for30 took a lot out of me and I've needed some time to recover :).

So dynamic parameters.  It's the number one most requested feature idea in the Tableau Community.  Everyone seems to have come across a time where this would come in handy.  It's a great idea and given the demand it should be implemented sooner rather than later.  

Unfortunately, it's not coming in the very soon to be released v8.2.  You'll hear a lot about some very slick new features - Story Points and the Visual Data Window to name a few.  But dynamic parameters ain't on the docket.  So it's time we take matters in to our own hands.

Let's start at the beginning.  What's the point of dynamic parameters?  Here's the text from the idea page (currently with 870 votes - only one with over 320 votes):

Parameters are really useful when you need to do something too complex to be handled by quick filters or action filters. However parameters are currently hobbled by the fact they have to be static lists.

It would be really, really useful and solve a lot of Tableau gotchas, if you could define the options available for a parameter dynamically, from the result of a datasource, and preferably with the option to apply filters also.

That's a bit about what dynamic parameters could do.  Let's talk about what parameters are in general.  Here's what we're NOT talking about - The type of parameter that is a numerical value that can be changed via a slider or typing something in that will affect calculations.  Those parameters work great - no complaints there.  Rather, what the "Idea" is typically talking about is a parameter based on a STATIC list (think one time snapshot) of values of a dimension in the data.  Here's how it typically goes:
Create a new parameter>>Change the data type to "String">>Click the button for a "List" of Allowable values>>Select "Add from Field" and select the dimension to get your list of values (I'm using Superstore data and going with "Category")

This will create a list of values based on the dimension selected.

This static list now lives apart from your data set.  If the data set changes (the company adds more product categories) this list will NOT update.  This is the gripe.  The thinking is that if the data changes, so should the parameter.

So here we go.  I'm going to propose an idea.  Follow me for a minute.

When we create a list of values in a parameter, it's as if we're informally creating a new table of values, based on a snapshot of the data, that now lives outside the the data.

What if we just more formally create a table of values that remains based on the underlying data, yet lives outside of the full datasource (as a parameter would).  What if, instead of calling this new table of a single dimension of data a "parameter", we called it what it really is - a small data source.

Here's what I'm proposing - Based on the same example from above (Creating a String Parameter from a List of Values based on the Category field), we head back to the data window and head for the Custom SQL.  What? You don't like SQL?  This is going to be the easiest three lines of code you've ever written.  It goes like this:

In general terms it's:
Select [Your Dimension]
From [Your Datasource]
Group by [Your Dimension]

And using the SQL from above, what do we get?

A single value list with all of the Product Categories - this looks strikingly similar to the parameter we created, except for one thing.  This is dynamic.  This list will change if the underlying data would change.

So we've created this dynamic list - what can we do with it?  Basically anything we want - we can do most of the same things we could do with parameters - use it in formulas, use it in quick filters (single select or multi-select - the second option is not currently possible with a parameter), etc....  The sky is the limit.  Here's an example:

Notice the two data sources.  Superstore is our primary data source and the single value list dynamic table based on Categories is the secondary source.  Creating a multi-select quick filter works like a champ (make sure the two data sources have the correct links and relationships - which Tableau will make sure of if the headers have the same names).

Interesting stuff, I say.

Is it a perfect solution.  Nope - it's a hack.  Are there a dozen reasons why it's not a best practice? I'm sure there are, and I'm sure the comments section below will let that play out.  But with all that said - could it help solve a problem you're having? It just might.  

It's a crazy simple solution and my hope is that it sparks a conversation.  I by no means think this is anywhere near the last word on this topic, but with v8.2 walking out the door, it's time we begin to amass ideas for v9.0.

I look forward to your feedback.  Many thanks- 



  1. This is a great hack - I've been using a combination of sets and filters to get what I need, but this may be easier - I could set up different views in SQL depending on the "filter" I want and link them as a "data sources" listing my dimensions I need.

    1. Thanks Stacey - I do hope it's helpful. I know there are some weak points in the solution, but I also think there may be some cases where this could really help. Keep me posted on how it goes when you implement this! Thanks!

    2. Thanks Nelson! This looks promising.

      Hi Stacey any chance you can share your version of usage by combining sets and filters?


    3. Greetings to every one that is reading this testimony. I have been rejected by my husband after three(3) years of marriage just because another woman had a spell on him and he left me and the kid to suffer. one day when i was reading through the web, i saw a post on how this spell caster on this address gbojiespiritualtemple@gmail.com , have help a woman to get back her husband and i gave him a reply to his address and he told me that a woman had a spell on my husband and he told me that he will help me and after 2 days that i will have my husband back. i believed him and today i am glad to let you all know that this spell caster have the power to bring lovers back. because i am now happy with my husband. Thanks for Dr,gbojie . His email: gbojiespiritualtemple@gmail.com OR.His WhatsApp Number:+2349066410185 or check out his website:https://gbojiespelltemple.wordpress.com

    4. Hello am From Canada. I feel so joyful today because of the help Dr Abaka has rendered to me for getting my Husband back with his spell. I have been married for 3 years and it has been so terrible because my husband was cheating on me and was seeking for a divorce. But when i came across Dr Abaka Email, on the internet posted by a lady, i decided to get in touch with him and i explained my situation to him and then seek his help but to my greatest surprise he told me that he will help me with my case for there is no problem without a solution. Here i am celebrating because my Husband is back home and am really enjoying my marriage, what a great celebration. i will keep on testifying on the internet because Dr Abaka is truly a real spell caster. Why not contact Dr Abaka now if you are facing any challenges in your relationship life. Email drabakaspelltemple@gmail.com website https://drabakaspelltemple.blogspot.com or call/whats app +2349063230051

  2. Hey Nelson, some great thinking here around the problem, nice to get the ball rolling on how to solve for dynamic parameters.

    There are some use cases where the above does not currently work, for example if I want to use a calculated field like IF [Category]=[source2.product category] THEN [Category] ELSE 'Other' END and place that on the rows shelf or the color shelf it does not work. This is because a blend is required to get the viz, but that blend also means that any filters on the secondary source will also apply to the primary. So in a sense it becomes a quick filter rather than a parameter.

    Its so close, all that's missing is the ability for Tableau to utilize two unblended data sources in a single calculated field......

    1. Peter -
      Thanks for the feedback and you're right - because we end up using this as a quick filter you lose the ability to show an "Other". I've tried about 7 ways to Sunday using sets and combined sets to get around it, but to no avail at the moment. It's close, and I think it's fun to have ideas to talk about to kick the can down the road. Keep me posted if you come up with anything fun on this. Many thanks for checking it out.


  3. PeterG - See http://drawingwithnumbers.artisart.org/creating-a-dynamic-parameter-with-a-tableau-data-blend/ for how to get something like what you want. You can turn off the Category as a linking dimension in the secondary source, in which case a filter on the Category in the secondary only filters the secondary and not the primary (and vice versa). However, to have the match work right for a [Category] vs. Other then the Category (or a field with finer granularity than Category) has to be in the view as a dimension (since all calculated fields using dimensions or measures from the secondary have to be aggregated, the view has to have fine enough granularity so the comparison will work), in which case to make an Selected vs. Other value you'd need a table calculation to aggregate over all the Categories. You can see an example of that in http://drawingwithnumbers.artisart.org/selecting-one-to-see-one-vs-all-other/.

    There are also ways to use Sets from secondary sources, see http://drawingwithnumbers.artisart.org/how-to-have-sets-with-your-secondary-data-sources/ for details. However, selecting the particular value of a dimension to use for the IN/OUT of a set from the secondary is just like for the primary, there's no real dynamic way to do that outside of Tableau desktop, unfortunately.

    Nelson: I'm glad to see someone else posting this idea, I've been exploring various funky use cases for data blending for awhile now and there are some very cool things we can do with it!


  4. Thanks Jonathan, using your data blend technique and Nelsons post I've been able to get most of the way there. As you state though I need Category in the view for it to work. I've tried using variations on window_sum calcs to get the aggregation but its not behaving like it would with a single source because the new field I create for 'selected vs other' can't be used for the partitioning (because under measures)

    I also tried the technique in your second blog post but it seems to be dependent on having another blend (i.e. on date), is that correct?

    This is certainly a brain tax!

  5. Is it possible to insert these "parameters" into text?

  6. Hi Nelson
    I am able achieve the above mentioned trick to filter different (Data Source) worksheets on a single dashboard, but when I follow the same for multiple Dashboards is it possible to achieve parameter action with the quick filter when all my data sources for each dashboard are blended together by a common field ?



  7. very nice blogs!!! i have to learning for lot of information for this sites...Sharing for wonderful information.

    Nexus 5 Case

  8. Get SAP Successfactors Online Training by Certified consultant from India. Enroll for Expert level Instructor Led Online SAP SuccessFactors Training. Apply today!

  9. W3 D Technologies is a pioneer in Dell Boomi Training sector, providing the Dell Boomi Online Training course we have experienced expert faculty for Dell Boomi http://goo.gl/Rt7DuX

  10. We are offering Dell Boomi Online Training with latest techniques. Our experts have more than 8 years experienced and certified. Dell Boomi Online Training

  11. Nice Blog, thanks for the article. For tutorials, interview questions and online training on Dell Boomi Visit TekSlate.

  12. Nice post....We provide the cool gadgets....For more detail about cool gadgets click here Cool Gadgets | Electronics Gadgets | Latest Technology

  13. Useful information...... We provide gadgets at reasonable price....For more detail visit here Cool Gadgets | Electronics Gadgets | Latest Technology

  14. Nice post.....We provide the guideline for educational purpose.....visit here Ehow-india | How to Guides India | Ehow-India How To India Guides

  15. Hi there, awesome site. I thought the topics you posted on were very interesting.
    Buy iPhone 4s Back Cover in India.

  16. Replies
    1. Hello everyone i am charlotte cora by name.I was diagnosed with HERPES for close to a year and 4 years my friend Cindy introduced me to Dr Abaka that i can be cured by him which I never believed because I have spend so much money on different doctors. She advised that i give it a try because he cured her of Cancer with natural herbs. So I mailed him and complain to him about my illness, he said to me I am in the right place. Today i am the most happy person on Earth all thanks to Dr Abaka, he cured me with his herbal medicine. All i did was to order for the herbs which he sent through courier delivery services and he instructed me on how to apply it for a period of 2 weeks, before the completion of the 2nd week i was totally cured .I'm so happy thank you Dr Abaka. I share this because of the pain i passed through when i had it and i care about those passing through the same pain. He also said he has herbs for all kind of illness including HIV/AIDS, ASTHMA, CANCER, DIABETIC 1&2, BARRENNESS, IMPOTENCE, WOMB DAMAGE, HIGH BLOOD PRESSURE and EPILEPSY, Email him now on drabakaspelltemple@gmail.com or call him on +2349063230051.Thank you doctor i will keep on telling the world about you because i am free of genital herpes forever.

  17. How do we do if we have to set the parameter dynamically in production for multiple data sources. does tableau support this.

  18. Hello,
    Thanks for sharing this solution. I had never thought of using SQL to create a single value data-source, and I can see a lot of possiblities for how this could help me with other situations. However, in this case I need to add the parameter to a stored SQL procedure. Your solution changes the data-type from a parameter to a filter. I need the data-type to remain 'parameter' so I can add it to a stored procedure, and it would be nice if I could make the parameter within the procedure dynamically update based on the data-source.

  19. That is very interesting; you are a very skilled blogger. I have shared your website in my social networks! A very nice guide. I will definitely follow these tips. Thank you for sharing such detailed article.

    Tableau online training hyderabad

  20. After being in relationship with Wilson for seven years,he broke up with me, I did everything possible to bring him back but all was in vain, I wanted him back so much because of the love I have for him, I begged him with everything, I made promises but he refused. I explained my problem to someone online and she suggested that I should contact a spell caster that could help me cast a spell to bring him back but I am the type that don't believed in spell, I had no choice than to try it, I meant a spell caster called Dr Zuma zuk and I email him, and he told me there was no problem that everything will be okay before three days, that my ex will return to me before three days, he cast the spell and surprisingly in the second day, it was around 4pm. My ex called me, I was so surprised, I answered the call and all he said was that he was so sorry for everything that happened, that he wanted me to return to him, that he loves me so much. I was so happy and went to him, that was how we started living together happily again. Since then, I have made promise that anybody I know that have a relationship problem, I would be of help to such person by referring him or her to the only real and powerful spell caster who helped me with my own problem and who is different from all the fake ones out there. Anybody could need the help of the spell caster, his email: spiritualherbalisthealing@gmail.com or call him +2349055637784 you can email him if you need his assistance in your relationship or anything. CONTACT HIM NOW FOR SOLUTION TO ALL YOUR PROBLEMS

  21. CIITN is located in Prime location in Noida having best connectivity via all modes of public transport. CIITN offer both weekend and weekdays courses to facilitate Hadoop aspirants. Among all Hadoop Training Institute in Noida , CIITN's Big Data and Hadoop Certification course is designed to prepare you to match all required knowledge for real time job assignment in the Big Data world with top level companies. CIITN puts more focus in project based training and facilitated with Hadoop 2.7 with Cloud Lab—a cloud-based Hadoop environment lab setup for hands-on experience.

    CIITNOIDA is the good choice for Big Data Hadoop Training in NOIDA in the final year. I have also completed my summer training from here. It provides high quality Hadoop training with Live projects. The best thing about CIITNOIDA is its experienced trainers and updated course content. They even provide you placement guidance and have their own development cell. You can attend their free demo class and then decide.

    Hadoop Training in Noida
    Big Data Hadoop Training in Noida


  22. Great presentation of Tableau form of blog and Tableau tutorial. Very helpful for beginners like us to understand Tableau course. if you're interested to have an insight on Tableau training do watch this amazing tutorial.

  23. My testimony on how i won £4,000,000 with the great help of Dr Davi powerful lottery spell: Call him +55 (11) 97732-4658   
    It's unbelievable how fortunate I feel after finding your website. For the past 14 years, I have been looking for a way on how i will win lottery. Money situation was one of the biggest problem to me. I had a huge amount of debt and I didn't know what to do. Out of complete and total desperation, I contacted many of those so-called individuals who promised powerful magic to win the lottery, witchcraft or black magic. None of them worked and none were as wonderful, affectionate and warm as Dr Davi has been. He is definitely different from the others and I felt immediate hope and strength from hearing about the promises he had to offer. He carries an air of purity and divine strength that is as pure as fresh snow on the ground. I requested Dr Davi most powerful spells and I was relieved right away that I had someone to solve my problems for me. His spells worked wonders,i won (Four Million pounds) my money troubles resolved itself after winning the lottery. My life change over night,i now have my own house and two cars,also i am free from my debts. Dr Davi, I have no idea what I would have done without you being there to help me out. If you are there and you need a powerful magic to win the lottery,Dr. Davi is the right person you need to trust and work with,i promise you that you will also win and share your own testimony. You can contact him via email:

    Spelltemple@fastmail.com Call or text him +55 (11) 97732-4658 

  24. Greetings to every one that is reading this testimony. I have been rejected by my husband after three(3) years of marriage just because another woman had a spell on him and he left me and the kid to suffer. one day when i was reading through the web, i saw a post on how this spell caster on this address gbojiespiritualtemple@gmail.com , have help a woman to get back her husband and i gave him a reply to his address and he told me that a woman had a spell on my husband and he told me that he will help me and after 2 days that i will have my husband back. i believed him and today i am glad to let you all know that this spell caster have the power to bring lovers back. because i am now happy with my husband. Thanks for Dr,gbojie . His email: gbojiespiritualtemple@gmail.com OR.His WhatsApp Number:+2349066410185 or check out his website:https://gbojiespelltemple.wordpress.com

  25. It's A Great Pleasure reading your Article, learned a lot of new things, we have to keep on updating it learn Mulesoft online Thanks for posting.

  26. That is very interesting; you are a very skilled blogger. I have shared your website in my social networks! A very nice guide. I will definitely follow these tips. Thank you for sharing such detailed article.

    Dell boomi Free demo

  27. Greetings to you all, i am here today on this forum giving a life testimony on how Dr Idahosa has cured me from Hiv Virus, i have been stocked in bondage with this virus for almost 2years now, i have tried different means to get this sickness out of my body i also heard there was no cure to the virus, all the possible ways i tried did not work out for me, i do have the faith that i was going to be cured one day, as i was a strong believer in God and also in miracles, One day as i was on the internet i came across some amazing testimonies concerning how Dr Idahosa has cured different people from various sickness with his Herbal Herbs Medicine, they all advised we contact Dr Idahosa for any problem, with that i had the courage and i contacted Dr Idahosa i told him about my Sickness, He told me not to worry that he was going to prepare some Herbal Medicine for me, after some time in communication with Dr Idahosa, he finally prepared for me some herbs which he sent to me and he also gave me prescriptions on how to take them, My good friends after taking Dr Idahosa Herbs for some weeks i started to experience changes in me and from there, I noticed my Hiv Virus was no longer in my body, as i have also gone for test, Today i am fit and healthy to live life again, I am so happy for the good work of Dr Idahosa in my life, Friends if you are having any types of disease problem kindly email Dr Idahosa on { dridahosasolutioncenter@gmail.com} or call his WhatsApp number on +2348134261542 God Bless you Sir.

  28. nice article thanks for shaaring

    My name is LUCY SETHI from USA .I am here to
    give testimony on how I got my husband back.
    My husband left me for no reason 3 years ago.
    He moved in with another woman, I felt like
    killing myself, my life became very bitter and
    sorrowful. Then 1 day, a friend of mine told me
    about a great spell caster that is very good and,
    he said he gave him some lucky numbers that he
    played in a lottery and he won. I didn't believe it
    because I've worked with so many of them and it
    didn't work. He begged me further so I decided
    to try this great spell caster called DR TAKUTA. I
    still didn't believe. I used the spell he gave me
    and the next day I received a call from my
    darling husband Thomas last month. He
    apologized and came back to me. He even gave
    me 10,000USD as a means of compensating me.
    I'm very happy now. please i will advise you to contact him
    now and see for your self his Email is via____
    takutaspellalter@gmail.com or whatsapp him
    through the following contact on +27788634102

    Dr.TAKUTA also cures:
    2. HERPES 1/2