4 Replies Latest reply on Nov 12, 2017 5:17 PM by Andrey Kovalenko

    LOD FIXED Calculation

    Andrey Kovalenko

      Hello,

       

      Can please somebody help me, I'm just not able to figure out what am I doing wrong here. I'm still new to the Tableau and maybe I'm just missing something simple, but I was trying to solve this puzzle for a few days now with no success.

       

      I'm analyzing NFL data (nfldb database gathered from a github site (https://github.com/BurntSushi/nfldb). In this particular instance, I analyze team data for a season against opp team. I get Rushing Yds by the game, calculate Avg Rushing Yds depending on whether the team was playing home or away, and now I want to compare against opp team's Rushing Yds total averages (and averages for home and away games). I use LOD FIXED Calculations to get the results but just not able to get the correct numbers. Also, these numbers are very easy to calculate (see Rushing Y Avg H/A worksheet) on the lower level.

       

      Please, help!

       

      Andrey.

        • 1. Re: LOD FIXED Calculation
          Jim Dehner

          Hi

           

          See the attached

           

          I think this is your formula

           

          It will return this in text form

           

          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.

          • 2. Re: LOD FIXED Calculation
            Andrey Kovalenko

            Hello, thanks for your help, and sorry if I did not make myself clear. I need to display averages (total, home and away games) across all games in the season of opp team in the first (All) worksheet's table next to averages of the team under consideration, and this is what I cannot figure out. How to display the data I have in the Rushing Y Avg H/A worksheet also in the table I need.

            • 3. Re: LOD FIXED Calculation
              Jim Dehner

              If you are trying to drop a table beneath your graph you will have to do

              that on a dashboard. Create one worksheet with your graph and another with

              the text table. Filter them both the same an connect them with an action

              filter that passes all the filter values from on sheet to the o the and

              then place each on the same dashboard an size them accordingly.

              Jim

               

              On Nov 12, 2017 5:06 PM, "Andrey Kovalenko" <tableaucommunity@tableau.com>

              • 4. Re: LOD FIXED Calculation
                Andrey Kovalenko

                No, I need the numbers for my table (All worksheet), and just cannot get the correct FIXED calculation, also it feels it should be somewhat simple and I'm just missing something. I have created that graph for the reference only. The numbers in the columns Rushing Yds Avg and Rushing Yds Avg (H/A) of Rushing Y Avg H/A worksheet are correct numbers and I want them to be displayed in the table in All worksheet for corresponding Opp teams.