-
1. Re: Passing variables from one data source to another
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.
-
2. Re: Passing variables from one data source to another
Hi Swaroop,
Hope I call you right. Thanks so much to show this idea. I does works and unlock me a lot more possibilities!
