I want to connect two API data source which has different column and I want one column in one data source to use with another another data source -
I tried lookup which not working 100% correct like
lookup(e9a7a8a3355813c7092c52abe7c48ad9@/Items/ClientName;,2be76f6247be4846f5045a92cb3f3af1@/records/Name;,2be76f6247be4846f5045a92cb3f3af1@/records/Time_zone_for_live_calls__c;)
Its like
DS1 : API Data source is having Client Name , Client Region.
DS2: API Data Source is having Client Name , Created Month , Employee Count
I want to Graph where I can show Month wise Employee Count for every Client Region as seperate line
My main issue is connecting two data source perfectly I want Client Region of DS1 map properly with DS2 [As of now lookup is working but not giving proper result , not ploted all monthly data]