2 Replies Latest reply on Nov 27, 2017 3:27 AM by haitham Farouk

    Average

    Gavin Wong

      guys

      what am i doing wrong ? i cant seem to write the LOD correctly to find averages of 2016 Q1, 2016 Q2 etc.....

      referring to my other post that others suggested, i still cant get it to work...

      appreciate any help given.

        • 1. Re: Average
          Amit Narkar

          {FIXED

          DATEPART('year', [Order Date]),

          DATEPART('quarter', [Order Date])

           

           

          : sum( [Calculation1])

          }/3

           

          Try this if you need quarterly Avg.

           

          In order to get correct average for a given view = sum(Measure)/Count

           

           

          Average by Default Tableau takes into considerations data at granular level as well.

          • 2. Re: Average
            haitham Farouk

            Hi Gavin

             

            Check The below image ...

             

             

            Note:

            If you found this useful, please mark it as helpful or correct answer ..

             

            Best Regards