1 Reply Latest reply on Aug 3, 2018 2:28 PM by Patrick A Van Der Hyde

    Count no. of duplicate fields in current month, and from previous month

    Lincoln Low

      Hi there,

       

      Background: I am trying to come up with a calculated field to essentially understand two things:
      1. Duplicates - Within a particular month, how many duplicate fields are there ?
      2. Re-post - Compared against the previous month, how many duplicate fields are there?

       

      Expected output:

      1. On a month-on-month basis i would like to output three fields:
      - Count of unique fields
      - Count of duplicate fields

      - Count of re-posted fields

       

      I have explored the forums for similar posts related to this matter, but do not seem to be able to work specifically for the issue i have at hand. I do not have extensive knowledge on the syntax used in Tableau and would really appreciate some help on this !

       

      Below is a sample data set that i will be using as reference.

       

      For the month of May-18, i am expecting the following results:
      Unique fields: 0

      Duplicate fields: 0

      Re-posted fields: 5

       

      For the month of Jun-18, i am expecting the following results:

      Unique fields: 2

      Duplicate fields: 1

      Re-posted fields: 4

       

      DateName
      Apr-18A
      Apr-18B
      Apr-18C
      Apr-18D
      Apr-18E
      May-18A
      May-18A
      May-18B
      May-18B
      May-18C
      Jun-18A
      Jun-18A
      Jun-18A
      Jun-18B
      Jun-18E
      Jun-18F
      Jun-18F

       

      Thank you so much in advance !