I have a spreadsheet that tracks the hours worked for all part-time or temporary employees for the upcoming healthcare law changes. I need a calculation that calculates if an employee works 30 hours or more. This can be as simple as If((SUM>29,1,0). This is an easy calculation in excel but for some reason I can not get this set-up correctly in Tableau. The data is set-up on a weekly basis, Any help would be greatly appreciated.
Would it be something like this?