
1. Re: Splitting and organizing data
Budi Lubis Mar 26, 2020 9:25 AM (in response to Kevin Hayes)1 of 1 people found this helpfulHi Kevin 
 What other data do you have?
 You can pivot those new columns into two columns to make it easier to analyze.

2. Re: Splitting and organizing data
Soumitra Godbole Mar 26, 2020 9:35 AM (in response to Kevin Hayes)Hi Kevin,
All you do is rename the split headers starting with Day 1, Day 2 ...... Day 6 (upto whatever is the
maximum number) then you have 2 choices
1) Do a data Pivot in Tableau
This is a lot easier as you will have 2 additional fields
[Pivot Field Names] ie "Day 1", "Day 2" .... (Header Names)
[Pivot Field Values] ie "Monday", "Tuesday" .... (values for each header)
2) Do a data Join with a single column
as an excel spreadsheet as shown below
Day
Day 1
Day 2
Day 3
. . .
Day 6
Now you will need to create a calculated field called [Day Value] using the following logic
Case [Pivot Field Name]
When "Day 1" Then [Day 1]
When "Day 2" Then [Day 2]
. . . .
When "Day 6" Then [Day 6]
Now your work becomes a piece of cake. Let me know if this was helpful and hope it answers
your question. Best Wishes !
Sincerely,
Soumitra 
3. Re: Splitting and organizing data
Soumitra Godbole Mar 27, 2020 8:10 AM (in response to Kevin Hayes)Hi Kevin,
In addition to the earlier explanation, here is a sample Histograph using your data and adding an
additional column for Row ID. For your reference, I have attached the twbx file (ver 2019.1) along with
the excel spreadsheet. Hope this is helpful and answers your question.
The only question I have is "Where is Thursday ?"
I hope there is no "Day 0" as it may get interpreted as "Day O" (Banana Boat Song)
"Daylight come and me wan' go home"
Best Wishes !
Sincerely,
Soumitra
Kevin's data.xlsx 9.9 KB

4. Re: Splitting and organizing data
Kevin Hayes Mar 27, 2020 12:15 PM (in response to Soumitra Godbole) 
5. Re: Splitting and organizing data
Soumitra Godbole Mar 27, 2020 12:54 PM (in response to Kevin Hayes)1 of 1 people found this helpfulYou're welcome Kevin ! Sorry I do not know what your data structure is like but tried to figure it
out by merely looking at your image of the columns. I may have overlooked something that I just
realized.
By any chance, other than the leftmost formula 9. Days of Weeks t... , are the other fields that you
have labelled as Day1, Day2 ..... Day 6 calculated using a Text function or by doing a split within
Tableau ?
In case you have done the split in Tableau, you are correct and may not be allowed to do a Pivot
but if you can do the split in say MS Excel recent versions (Text to Columns) as shown below, you
will be able to do the Pivot.
Oh yes, I just realized that even without the Pivot, you will be able to solve this problem using the
2nd method that I suggested in an earlier post (not the previous one) wherein you create a single
column in excel called Day No with 6 rows since you have 6 split fields  Day1, Day2 ... Day6
(No DayO ) depending on how many Day Columns you have above.
In case you have more than 10 Splits to do, I would advice you to either use Tableau Data Prep or
even better, do it in excel (I just solved a problem yesterday with 21 split fields).
Anyway here is the earlier post that I am speaking of (thanks to copy and paste)
2) Do a data Join (Cartesian Product join i.e. 1 = 1) with a single column containing 6 rows
as an excel spreadsheet as shown below
Day
Day 1
Day 2
Day 3
. . .
Day 6
Once you have done the Pivot, you need to create a calculated field called [Day Value] using the
following logic
Case [Pivot Field Name]
When "Day 1" Then [Day 1]
When "Day 2" Then [Day 2]
. . . .
When "Day 6" Then [Day 6]
Also make sure you do have one column like an index of Row Value 1,2,3 ... as I had shown in my
excel spreadsheet as the Countd of this Row will give us the Frequency for the Histograph.
Lastly I hope this long and boring explanation did not confuse you or take you back to stoneage .
If only you had real data, this would have been solved long ago. Best wishes !
Sincerely,
Soumitra 
6. Re: Splitting and organizing data
Soumitra Godbole Mar 29, 2020 1:27 PM (in response to Kevin Hayes)Hi Kevin Hayes,
Hope you're having a good weekend. I was just doing a routine followup to check if
you tried the latest solution I posted (that offers an alternative to Pivoting). Do let
me know if you have any difficulties. Also it would help to include either a packaged
workbook (twbx file) or an excel spreadsheet with dummy data. Take care !
Sincerely,
Soumitra