In tableau I made a sheet where I am trying to find the working days vs non work
In tableau I made a sheet where I am trying to find the working days vs non work
In tableau I made a sheet where I am trying to find the working days vs non working days. See excel, however, with my pivots I made I am unable to get the formula to work. Formula in a new calculated column I tried in Tableau IF(Find(Working days, "Monday") > 0 THEN "working day" ELSE "Non-working day" END but this does not calculate all columns 🙁  If person is not working Tuesday, Wednesday, Thursday then working days = Monday, Friday > This is the formula I need help with after your pivot columns together  ;#Monday;#Tuesday;#Wednesday data I made into a Pivot Column week 1 because I split the columns by replacing ;# with , using Tableau Prep  https://kb.tableau.com/articles/howto/pivot-calculated-fields Spilit Function I used REGEXP_REPLACE (REGEXP_REPLACE([WorkingDays], '(^[^a-zA-Z0-9]+)|([^a-zA-Z0-9]+$)', '' ), '([^a-zA-Z0-9]+)' , ',') https://stackoverflow.com/questions/56464321/remove-special-characters-and-add-a-semi-colon-in-a-word-tableau Count Week 1 values for people working vs non working days

Leave a Reply

Your email address will not be published. Required fields are marked *