2 Replies Latest reply on Oct 14, 2019 7:32 AM by Tina Shanti

    moving average and other calculations using Tableau calculated fields

    Tina Shanti

      Hello,

       

      I have following excel file that is being used to build geo map Tableau dashboard and "Final score" is used to color code market name (below 60 high risk, 60-80 medium risk, above 80 low risk etc)  Currently moving average per month and other fields are being calculated in excel but would like to do these calculations in Tableau, but cannot use Tableau's table calculation as I am using only Final score in the geo map.  please shed light on how that can be done.  I am trying to create "Final Score" column from excel which is calculated as follows:

       

      1) moving month over month percentage changes calculated for each "Market Name", I have 400+ market names in my file

      2) then average of "moving month over month percentage change" for all months for each market name

      3) then "Final Score" is calculated by (1+ result of Average of Month-Month change) *(latest score for the market)

       

       

       

       

      Market NameLatitudeLongitudeScoreReport_DateMoving_Month_Over_Perc_ChangeAverage of Month-Month ChangeFinal Score
      Chicago43.04103-76.2714687/1/2018
      Chicago43.04103-76.2714728/1/20186%
      Chicago43.04103-76.2714569/1/2018-22%
      Chicago43.04103-76.27146210/1/201811%
      Chicago43.04103-76.271467.511/1/20189%
      Chicago43.04103-76.271476.712/1/201814%
      Chicago43.04103-76.2714781/1/20192%
      Chicago43.04103-76.271470.72/1/2019-9%
      Chicago43.04103-76.2714683/1/2019-4%
      Chicago43.04103-76.2714904/1/201932%
      Chicago43.04103-76.2714665/1/2019-27%
      Chicago43.04103-76.271464.56/1/2019-2%
      Chicago43.04103-76.271479.57/1/201923%3%81.62406527