1 Reply Latest reply on Jan 30, 2019 3:15 PM by Patrick Van Der Hyde

    Cumulative week to date, month to date comparisons

    Peter Fisher

      Hi all,

       

      I have been using tableau more and more for building simple dashboards to provide views on totals for various metrics. I have created a parameter to allow to switch between day grouping, week, monthly and yearly views as a drop down, however I have been asked if it can be done to show a cumulative view.

       

      IE if I selected Week on a Wednesday it would show the cumulative view for every week up until the weds (or what ever day they were looking at) so we can see where we stand that week in relation to previous weeks, I would also like to do the same for the montly view so if you were on say the 9th of january and viewed the previous 12 months it would show the total for those months up to the 9th.

       

      I think this can be done using a date trunc but it is not something I have much experience with so anny suggestions would be appreciated.

       

      Cheers

       

      Pete