How to create a binary datatype result in the dataset
The binary data type can have only 2 values. Usually, those will be either a 0 or 1. For example, let’s say you have a sales column that has multiple values. Now let’s say you have a threshold of $5000 and you want all the values less than 5000 then it should be 0 else it is 1.
To do that you can create a calculated field with the codes like-
If sum(sales)
Else 0
END
Now if you will check, this will be a binary field.