3 Replies Latest reply on Jul 5, 2018 6:50 AM by Rita Bota

    How calculate cumulative monthly avg and compare it against monthly avg

    Rita Bota

      Hi Team,

       

      I have a requirement which is a priority one for me but I lack the understand to get a matching result between by database and my tableau view.

      I have used LOD calculation to get a result but this result does not match the record coming in from my database. please find formula attached :

       

      { FIXED    DATEPART('month', [Booking date]): AVG(

      { inCLUDE   DATEpart('year',[Booking date):COUNTD([Booking ID])})}

       

      I have also attached a package workbook version 10.3 with a truncated data set, suggestions and recommendations are welcome