3 Replies Latest reply on Oct 2, 2018 3:20 AM by Mavis Liu

    Average of 10 weeks

    Andreas Kampianakis

      Hello world,
      i have an excel file that I use right now and I try to make it in tableau. Unfortunately I've stepped into a problem, where excel can calculate the avg of 10 weeks prior to my selected week number, without showing the week itself, but tableau as it needs for that the window_avg command seems not to work for this purpose. Does anyone have any idea on how to solve this? I have no workbook as we are working on creating one.
      Thanks everyone!