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

    Average of Period (weeks, months etc)

    Shamirali Maredia

      Hi,

       

      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 -

          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.

          1 of 1 people found this helpful