
1. Re: Interpolation in Tableau
Jim Dehner Sep 25, 2018 10:54 AM (in response to Simmy Johney)Hi
You are asking very specific questions  if you want very specific answers  please provide your TWBX workbook with the data included
Jim

2. Re: Interpolation in Tableau
Simmy Johney Sep 25, 2018 11:41 AM (in response to Jim Dehner)Here is the twbx with the data. TIA!!

Tableau.twbx 37.8 KB


3. Re: Interpolation in Tableau
Jim Dehner Sep 25, 2018 12:02 PM (in response to Simmy Johney)see the attached
I don't know where you are going with the analysis but this should give you a direction
there is a table calculation that can be written as
that returns this
then you can calculate the running total of the values using
and it will return this
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.

Tableau_v10.2.twbx 112.6 KB


4. Re: Interpolation in Tableau
Simmy Johney Sep 26, 2018 9:23 AM (in response to Jim Dehner)Thanks a ton, Jim. This is super helpful Any chance you could help me with the second step as well? with the same data, I now wish to see the running total of percentage for each answer code. I am wondering if I could make a table of sorts for referencing, like I would in Excel. I essentially want to check between which two cumulative distribution values would lets say "20%" fall and then what are the corresponding scores? I want to replicate this calculation in Tableau: = Closest lower score + (cutoff% – closest lower cumulative distribution %age) / (closest upper cumulative distribution %age  closest lower cumulative distribution %age). For instance, in this case, if my cutoff is 20%, then my calculation would be: 2 + (20%12%) / (32%12%). This is slightly complicated, any guidance for this?
Score
Count of Respondents (Cumulative distribution)
1 3% 2 12% 3 32% 4 78% 5 100% 
5. Re: Interpolation in Tableau
Jim Dehner Sep 26, 2018 10:45 AM (in response to Simmy Johney)see the attached
this is a little complex because all the calculations are table calcs which are on the bottom of the order of operation
I added a parameter to select the target value
the calculation is
and it is computed across
in the table it would look like this
of you can plot it to look like this
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.