'Two data sources in Tableau

Here is my first question. In the Tabeleau I have two different data sources:

  • Tableau live data extract from which I pull date and value 1 (number of locations)
  • Table from SQL table with date and another value 2 (number of affected locations)

Have to make calculated field using those value 1 and value 2 (percent of affected locations) but Tableau is "forcing" me to define relation between two data sources. However, datatype of date is different and it is not possible to define relation. Any suggestion?

Thank you!



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source