I have two dataset on a Dashboard with two different fields, can we connect them using Connected data sources? , consider below scenario:
On
Opportunities we have Sector as a field with 2 values A & B, on Region Target we have department with the same values. I have global filter Sector, when I select A it should automatically select A from Department under Region Target.
Yes - that's possible. When connecting datasets, the field names are not important. Only the values of the connected fields should match.
@Roman Michalik Thank you, my issue is resolved, I had two same name fields which had different values, so had to select the right one, now its working!! Cheers.
Are the values in Sector__c and Department the same?
Some things to check:
No additional blanks or so?
Is one of the fields a lookup field?
Are you using labels?
thank you for your response, the values matches, but its not working. :(