I'm new to Tableau and trying to create a calculated field that has 3 steps of calculations. Looking for help in creating calculated field.
IF [Complexity] = High THEN L1
IF [Complexity] = Medium THEN L2
IF [Complexity] = Low THEN L3
L1 = [Complexity]* 2
L2 = [Complexity] * 1
L3 = [Complexity} * 0.5
Total = (COUNTD(Builds) *L1) + (COUNTD(Builds) *L2) + (COUNTD(Builds) *L3)
How do I perform the above calculations using Calculated Fields??