Jenny (Xiao) Zhang

Tableau Tips,Tricks,Best Practices – Calculation

calculation

Tableau Blog Posts Series – Tips,Tricks,Best Practices

Blog four – Calculation

For Example: if we were counting the number of IDs and those IDs have an additional value attached to them:

1 20
2 11
3 500
4
5 504
The count of IDs will be 5, where the count of values is only 4
If we wanted to go through each row and find all values that meet a condition, then count how many met this condition, we can set up the formulas as such:
Calculation1:

IF Sales >= 500,000
THEN 1
ELSE 0
END
Calculation2:
WINDOW_SUM([Calculation1])

%d bloggers like this: