This content has been marked as final. Show 3 replies
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 .