1 Reply Latest reply on Oct 11, 2018 12:04 PM by Jim Dehner

    Average of Period (weeks, months etc)

    Shamirali Maredia



      I am trying to calculate average for certain number or weeks (for e.g: last 12 weeks) or months (last 6 months) of a measure value.  Can someone provide any guidance on it ?  Unfortunately, my search on google didn't provided what I was looking for.


      Thanks in advance.

        • 1. Re: Average of Period (weeks, months etc)
          Jim Dehner

          without seeing you workbook it will be difficult

          conceptually you would sum(measure)/countd(time)  but the actual formulas depend on the data structure and the viz construction -


          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.

          1 of 1 people found this helpful