I'm new to Tableau and struggling a bit with calculations. I have a field that can have a value of 0 or 1. I just want to count the number of records where the value is 1 but am struggling as there is no where clause. Any help would be appreciated.
Think I found the solution
SUM(IF [Field Name] = 1 THEN 1 ELSE 0 END)
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...