I am working with the Tableau ServiceNow ITSM connector. I have an additional data source that I need to join my SN data to, but I need to do a join rather than a blend because I have some LOD calcs that I need to compute and blends do not support LOD calcs across multiple data sources.
I have a calculated field from my SN data that I need to join my additional data source to but I am having the hardest time because it doesn't look like the SN connector supports the "create join calculation" OR customer SQL.
Is this observation correct? Or am I missing something?
Either way - does anyone know how to do a join on a calculated field between SN and an additional data source?
Are you working with a Tableau Extract here? What is the second data source type?