This content has been marked as final. Show 2 replies
Using ODATA, I have extracted data from two Sharepoint links. One source have IDs / other information and other two data source have names for each id. As TAbleau does not support $expand, I have join the extract the data after pulling from Sharepoint.
I am looking for creating 'Calculated Fields' in Extract 1 similar to below table and AssignedName and IssueName are pulled from Extract2.
So that I can use AssignedName and IssueID as Drop-downs on dashboard in which AssignedName Dropdown will have two names - Harris & Sam and IssueName will have four names - David, Ram, Steve, Mike. Because if I use Drop-downs directly from Extract-2 then drop-downs will have all six names.