3 Replies Latest reply on May 23, 2020 4:25 AM by Dario Medina

    CountD counting 1 extra record

    David Matthews

      Hello. I'm working on a larger project but have reproduced the problem with this sample data. Basically I am trying to find the distinct ids that have a flag. In the sample data/dashboard here you will see there should be 5 customer ids that have Special Discount flag of Y. When I do a calc field to identify which customerids have that field and then add it to dashboard and do a countd its showing 6 instead of 5. Any idea what is happening here?



      Calc field I created


      When I add it to dashboard it shows 6 instead of 5