6 Replies Latest reply on Apr 19, 2018 7:01 AM by Zhouyi Zhang

# Tableau 10.3 : Adding a user defined number to the total number of records

I'm doing some modeling exercises and have encountered a scenario I'm having trouble with.   I want to provide my end user with the ability to add X to the total number of records that meet a criteria.   Attached is an example of how I am approaching the problem presently.   The base represents current measures of number of records the model is the adjustment by end user defined parameter.   In the attached the desired result is to increase the number of records which are Trait A and Lvl SV  by exactly 10 (ie from 18 to 28).   The functionality I get is that each of the 18 records is increasing by 10 thus making the delta 180.   Can't seem to figure this out and could use some help.

• ###### 1. Re: Tableau 10.3 : Adding a user defined number to the total number of records

Hi, Michael

Please find my solution attached as well as screenshot below

Hope this helps

ZZ

1 of 1 people found this helpful
• ###### 2. Re: Tableau 10.3 : Adding a user defined number to the total number of records

Thanks ZZ I figured it would be something straightforward I just couldn't quite get there.

• ###### 3. Re: Tableau 10.3 : Adding a user defined number to the total number of records

Ok I was playing around a bit further and now have additional thoughts on this....First while the formulas you introduced do exactly what I desired, this in turn broke the Deltas calculation.  At the end of the day I would need to extend the functionality to say a second and third parameters that   would allow me to add to the other trait/lvl combinations while still being able to measure the deltas between the Base and Model.   Hopefully this makes sense and hopefully you know another adjustment I can make to fix the Deltas measurements as well.

• ###### 4. Re: Tableau 10.3 : Adding a user defined number to the total number of records

Hi, Michael

ZZ

• ###### 5. Re: Tableau 10.3 : Adding a user defined number to the total number of records

I believe the example to be pretty straightforward, but let me see if I can clarify further.    The basis of the example is a modeling interface of sorts.   I have a population that is present state (BASE) and through the use of parameters I want to manipulate that population in a specific manner (add # directly to specific "cells" in the chart) to create the future state (Model).   The Delta would just be the visual representation of the actual change for each "cell".  For example The Base value of Trait A SVP population is 18 and I want to add 10 to that via the parameter to show a future state of 28.    Base = 18, Delta = 10 , Model = 28.

Hope that clarifies what I am trying to accomplish with this exercise.

• ###### 6. Re: Tableau 10.3 : Adding a user defined number to the total number of records

Thanks, Michael

I think I didn't name it properly. the calculation1 should be your Delta if I replace this with your original delta, below is the result.

ZZ