3 Replies Latest reply on Aug 22, 2018 7:51 PM by Eva K

    Show an axis with rolling last 4 weeks

    Eva K

      i need to show a line chart for counts by last 4 weeks. These last 4 weeks should be rolling based on Today(), my current chart looks like this

      instead of the x-axis shown above, it should display Jul 22, July 29, Aug 5, Aug 12. Even if there are no counts during Aug 5 week, it should still show last 4 weeks on the x-axis.

      Next Monday, this chart should show July 29, Aug 5, Aug 12, Aug 19. I have attached the twbx file and the datasets.

      I tried using trick shown on this thread but doesn't seem to be working .

      Rolling Week calculation