1 2 Previous Next 16 Replies Latest reply on May 5, 2018 5:09 PM by Don Wise

    Running Sum but Exclude Date Range quick filter

    Matthew Hefferon

      Hello Tableau community!

       

      I have a request and having issues coming up with a solution.

       

      For example I have create date, user name and the total number of records:

      Screen Shot 2018-05-04 at 10.10.04 AM.png

      I need to use "create date" as a quick filter and display like below.

      Screen Shot 2018-05-04 at 10.10.21 AM.png

       

      The works as expected but not what is needed.

       

      What I need is to show the total count of records for the full time period even if the start date in the create date is filtered. So instead of showing the 8 records I need to see 30. The only filtering should be when the end date of the create date is filtered.

       

      I've attached a sample workbook. I've tried some LOD calculations and start date / end date parameters but not sure the best approach.

       

      Thanks

        1 2 Previous Next