7 Replies Latest reply on Nov 15, 2017 6:55 AM by John Rivett

    Distinct Running Count of First Gift (Version 10.1)

    John Rivett

      I need to pull the earliest gift date for each fiscal year (which starts Oct. 1)  per constituent record and then do a distinct running count of the earliest gift dates.

       

      My uploaded Excel sample has three people, Mark, Michelle and Louis, with multiple gifts and I’m having a hard time getting this to work with LOD and min calcs and pinpointing just the one gift. For instance in the highlighted rows in the Excel attachment, Michelle has given her first gift on 10/1/2017 (in fiscal year 2018) followed by three others. I only want her 10/1/2017 gift to show in the running count in a visualization broken out by fiscal year month; the other two I don’t want in the visualization. For FY2017 Michelle’s first gift would be on 11/29/2016 (she has two gifts on this same date but I only want a distinct count of the first gift of each fiscal year). Another example, Louis has two gifts on 12/1/2015 but I only want to count it once for FY16. Mark, his first fiscal 2017 gift would be on 10/6/2016.

       

      Can someone help me with this? My other workaround in the custom SQL was using the min function for the date and grouping by fiscal year, but I want to know how to accomplish this in Tableau when I have multiple records per donor for a given year.