4 Replies Latest reply on Nov 26, 2018 11:50 AM by Anh Nguyen

    Control the sum of values assigned for multi parameters

    Anh Nguyen

      HI everyone,

       

      I am working on a dashboard which allows audiences to change the weights for each of 4 dimensions named Economic dimension, Social dimension, Civil and politic dimension, and Health dimension. The observations are 10 Canadian provinces which will be ranked based on their scores in these 4 dimensions.

       

      To do that, I create 4 parameters for these 4 dimensions from which audiences can choose the weight values from 0 to 1. However, I want to be sure that the SUM of these 4 weight values must be always equal to 1. Can I do that with Tableau? Is there any way to control the sum of the values assigned for each parameter?

       

      https://public.tableau.com/profile/anh4978#!/vizhome/Assigntheweight/Dashboard1

       

      Thank you for your help

       

      Anh