Tableau/pivot help | Information Systems homework help

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

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadline.


Click Here to Make an Order Click Here to Hire a Writer