3 Replies Latest reply on Jan 8, 2019 1:00 PM by Deepak Rai

    A member has multiple rows but i want to only count them once when they satisfy a condition

    Rakshith Yashvanth

      I have a table which looks like this:


      I want a bar chart showing the number of members who had and haven't had a car over the years. like this:


      The problem is, in tableau, when use number of records, John gets counted twice and the calculation becomes:

      Please help.