1 of 1 people found this helpful
So the connector data source has to be an extract. Can the second db be extracted? If so, you should be able to do a join on a common Dimension.
I assume that you want to link on ID value so 123 in the left primar db would have a one to many relationship with the right 2nd db on the same value.
Data blending may not work with this however since dark/light are at lower levels of detail than the linking ID field. Another option is potentially data blending but only including Dark values in one view and then creating a second view with only Light values.. two different views with totals in a dashboard. This makes an assumption that you actually have just two values for color 2 and only one for color 1 but I am guessing there are many more.
Joining the data or getting the data into a common DB that could be joined before exploring with Tableau would be my way forward with this. It would make the analysis easier for you and likely easier to maintain.
I hope that helps get you going. If you have a workbook to share, please add it to the post and we can explore options.
Thank you Patrick.
Unfortunately I can not share a workbook. Yes, I am trying to link on ID values. Because of the one to many relationship, I am trying to create this new calculated field.
If this is back and dark, then new value will be "blackdark". But doing so, the calculated field turns into a measure instead of a dimension "blackdark".
Have a great week and thanks so much for your time !