2 Replies Latest reply on May 1, 2018 8:41 AM by chris.calmeijermeijburg

    Filter using Dateadd and Today()

    chris.calmeijermeijburg

      Hi all!

       

      I have a workbook where I would like to calculate the total number of billable hours in the previous month. I have create a viz for this that does this nicely for the entire year:

       

      1.PNG

       

      Now I only want to show the previous month, so I add a filter based on month, and manually select the previous month (April, or 4 in this case):

       

      2.PNG

       

      All is working fine. However, for future use I would like the workbook to automatically select the previous month based on today's date. So I thought of creating a calculated field using DATEADD and Today() to use as a filter. The calculation itself is working out ok, (it shows the previous month in the filter selection), however the viz no longer shows only the previous month, but all months again:

       

      3.PNG

       

      Any thoughts on where this is going wrong? Packaged workbook is attached as reference. Thanks!