5 Replies Latest reply on Apr 28, 2017 11:37 AM by Elliott Stam

    Count Occurrences Before and After a Fixed Date

    Dan Brewer

      Hi All,

      After receiving such great help for my first question, I've been inspired to ask another question I've been trying to tackle.

       

      I've got source data at a line item level that I need to roll up by date (using a level of detail expression I am able to count the distinct occurrences of a date field). What I want to know is how many of these occurrences were BEFORE a different static date field, and how many were AFTER the static date field.

       

      I've included a sample worksheet with data that supports this scenario with a caption at the bottom with the desired solution.

       

      Thanks in advance for all of the great help and support.

       

      Tableau Desktop Version 10.2.1