This content has been marked as final.
Show 2 replies
-
1. Re: Passing variables from one data source to another
swaroop.gantela Dec 4, 2017 5:56 PM (in response to Peng Chen)Peng,
If possible, you could try adding a third sheet with just a list of all possible days,
as described here:
CROSS JOIN with Tableau's join dialog
In your project, you could make a join as shown in attached graphic
connecting all version to all possible dates, and then left joining to holidays.
Then you could count holidays using:
{ FIXED [Version],[Name]:SUM([Holiday])}
and get the subtracted amount using:
MIN([workday_in_version])-SUM(ZN([holiday in version]))
Please see attached workbook in Forum post.
-
254099hol.twbx 33.1 KB
-
254099join.png 21.1 KB
-
-
2. Re: Passing variables from one data source to another
Peng Chen Dec 5, 2017 6:55 AM (in response to swaroop.gantela)Hi Swaroop,
Hope I call you right. Thanks so much to show this idea. I does works and unlock me a lot more possibilities!