2 Replies Latest reply on Aug 3, 2018 10:21 AM by Stephen Groff

    Pull first occurrence of Serial # by MIN DATE

    Stephen Groff

      So I need to count serial #s based on the calculation below, and this calculation works and is 100% accurate (Historically speaking).

       

      However, when I add this calc to the Viz, and then add-in dates... it's all over the place.

       

      I want to COUNTD by the first occurrence found in the data using (I think) MIN([DATE])

       

      Anyone know how to accomplish this via the calculation below?