6 Replies Latest reply on Nov 14, 2018 5:05 PM by lei.chen.0

    Filter only shows 30/31 month days

    Daniel Ferreyra

      Greetings Tableau Enthusiasts!

       

      I have a table that shows the number of days per month since the first data entry for the first month, then it counts the natural days of each month:

       

      Many of my calculated fields depend on these numbers, meaning that when I filter these numbers other calculated fields change too.

       

      I want to filter last month (october), and I have tried to do so by doing the top 1 with filter tool:

      And also with a true false  calculated field (Last Month):

      Is there any easier way to do it? Please feel free to edit the workbook.