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
Sheet1
| Title | Agreement | PP Days | Week 1 Days | Week 2 Days | Week 1 Pivot Columns – Tableau Name | Week 2 Pivot Columns – Tableau Name |
| User A | Y | 3 | #Tuesday;#Wednesday;# | #Thursday;#Friday;# | Week 1 – Spilit 1 | Week 2 – Spilit 1 |
| User B | Y | 3 | ;#Monday;#Tuesday;#Wednesday;# | ;#Monday;#Tuesday;#Wednesday;# | Week 1 – Spilit 2 | Week 2- Spilit 2 |
| User C | Y | 3 | ;#Monday;#Tuesday;#Friday;# | ;#Monday;#Tuesday;#Friday;# | Week 1 – Spilit 3 | Week 3 – Spilit 3 |
| User D | Y | 3 | #Thursday;#Friday;# | ;#Monday;#Tuesday;#Friday;# | Week 1 – Spilit 4 | Week 4 – Spilit 4 |
| User E | Y | 3 | ;#Monday;#Tuesday;#Friday;# | ;#Monday;#Tuesday;#Wednesday;# | Week 1 – Spilit 5 | Week 5 – Spilit 5 |
0
[Sheet1]
Count
true
0
“A1:G6:no:A1:G6:0”
true
2
Title
130
[Title]
[Sheet1]
Title
0
string
Count
true
“WSTR”
[Sheet1_F352E8B5C59F4A7AB9B686FE38DFEB6C]
Agreement
130
[Agreement]
[Sheet1]
Agreement
1
string
Count
true
“WSTR”
[Sheet1_F352E8B5C59F4A7AB9B686FE38DFEB6C]
PP Days
20
[PP Days]
[Sheet1]
PP Days
2
integer
Sum
true
“I8”
[Sheet1_F352E8B5C59F4A7AB9B686FE38DFEB6C]
Week 1 Days
130
[Week 1 Days]
[Sheet1]
Week 1 Days
3
string
Count
true
“WSTR”
[Sheet1_F352E8B5C59F4A7AB9B686FE38DFEB6C]
Week 2 Days
130
[Week 2 Days]
[Sheet1]
Week 2 Days
4
string
Count
true
“WSTR”
[Sheet1_F352E8B5C59F4A7AB9B686FE38DFEB6C]
Week 1 Pivot Columns – Tableau Name
130
[Week 1 Pivot Columns – Tableau Name]
[Sheet1]
Week 1 Pivot Columns – Tableau Name
5
string
Count
true
“WSTR”
[Sheet1_F352E8B5C59F4A7AB9B686FE38DFEB6C]
Week 2 Pivot Columns – Tableau Name
130
[Week 2 Pivot Columns – Tableau Name]
[Sheet1]
Week 2 Pivot Columns – Tableau Name
6
string
Count
true
“WSTR”
[Sheet1_F352E8B5C59F4A7AB9B686FE38DFEB6C]
