Not sure but find my approach as reference below and stored in attached workbook version 10.5 located in the original thread.
1. Pivot your table
2. D1. Job: [Pivot Field Names]+str([Link Number])
4. D1. Sequence:
if [D1. Job]='Mon Job 11' then 0
elseif [D1. Job]='Tue Job 11' then 1
elseif [D1. Job]='Wed Job 11' then 2
elseif [D1. Job]='Thu Job 11' then 3
elseif [D1. Job]='Fri Job 11' then 4
elseif [D1. Job]='Sat Job 11' then 5
elseif [D1. Job]='Sun Job 11' then 6
elseif [D1. Job]='Mon Job 12' then 7
elseif [D1. Job]='Tue Job 12' then 8
elseif [D1. Job]='Wed Job 12' then 9
elseif [D1. Job]='Thu Job 12' then 10
elseif [D1. Job]='Fri Job 12' then 11
elseif [D1. Job]='Sat Job 12' then 12
elseif [D1. Job]='Sun Job 12' then 13
5. D2. Date: [Parameter 1]+[D1. Sequence]
6. Drag the required objects to the indicated locations and show parameter control
Hope it helps
calendar_nalmai_v10.5.twbx 186.5 KB
Hi Tim and Norbert Maijoor,
Apologies for my lack of response and closing off this issue.
It was technically unsolvable without a time index which was at the time unavailable in the database (I was trying to use a manually built one in excel at the time) - I used both of your responses to check if I could develop any work-around but failed.
I had to build some new tables and views added to our database, including a time index, to develop the solution, which made the problem pretty easy to solve, using a simple pivot calc in Tableau, as you noted Norbert.
Thanks either way!
Thanks for the feedback. Appreciated. Could you 'Close' the thread with a 'Helpful' or 'Correct answer' if applicable?