Forum Discussion

JasonFurtner's avatar
JasonFurtner
Regular Visitor
3 years ago
Solved

DistinctCount overcounting when drill down by date

Hello   I have data that looks similar to the form below.   Unit SN Question Answer (Y/N) Date N001 Question 1 Y 4/1/2023 N001 Question 2 Y 4/1/2023 N001 Question 3 Y 4/1/...
  • JasonFurtner's avatar
    3 years ago

    Nevermind. I figured it out. I can just add a filter to only count 1 question from each questionaire. That seems to work okay.