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


    Gavin Wong


      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


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

          DATEPART('quarter', [Order Date])



          : sum( [Calculation1])



          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 ...




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


            Best Regards