7 Replies Latest reply on May 2, 2013 1:25 PM by Tracy Rodgers

    How do I create a calculation based on multiple parameters in Tableau public?

    Chris Hubbuch

      This is probably a simple calculation, but my knowledge of syntax is limited.

       

      I'm working with housing price index data and want to set up a function for users to input a date and value and see how that value changed over time.

       

      The data is structured like so:

       

      RegionYearQuarterIndex
      OR20121243.81
      OR20122257.49
      OR20123267.38
      OR20124264.88
      PA19911100.00
      PA19912100.03
      PA19913100.37
      PA19914101.40
      PA19921101.78
      PA19922102.35
      PA19923102.50
      PA19924102.96

       

      Users would input parameters for state, start point and end point (year and quarter), and start value. The formula would divide the end point index by the start point index and multiply the quotient by the value (INDEX2/INDEX1)*VALUE.

       

      Mostly what I need help with is a formula that returns the index value based on location, year and quarter. Advice much appreciated.