Search code examples
tableau-apitableau-desktop

How can I count only specific values in tabluea?

I have a medal column, there are 4 different values in the medal column gold, silver,bronze, and NA, I don't want to count the NA column in the calculated field in tableau

I want to do something like this

Count(Medals(not including NA))/count(Medals)

Solution

  • One solution is

    SUM(INT([Medal] <> “NA”)) / COUNT(“*”)