Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello Everyone!
Need help to the below mentioned scenario!
User have all data for his location along with dclongitude and dclatitude and provide competition data only have dc longitude and dclatitude and state--no connection with user location
1st table is connected to other matrix and have dropdown for the locations based on 1 or multiple location selection :
Need to show bubbles for that location along with competition bubbles
--how to show 2 different tables longitude latitude in one map
--how to co-relate both tables dclat and dc long
so based on user location selection zoom in --all nearby competition will automatically zoom in near to user location
Thanks for help in advance!
Thanks,
Neha
Solved! Go to Solution.
Hi ,
Thanks for your reply! Data is confidential
Solution :
creating a New Table with 4 columns LocationKey , dclongitude,dclatitude, Type
This Table will be related to Master Table from ClientCompany which contain Unique locationKey , dclongitude and dclatitude with all other infor
Competition Table Contain only dclongitude and dclatitude , I decided to create new column is location key related to master table , Purpose to find which competitor location belongs to which Client location , so that zoom in can be easy
New table columns:
Type will be able to define the Competition or ClientCompany in Map
or
Map Legend will be Type :- for 2 different color based on Competition and ClientCompany
dclongitude ---shows all values for both Types
dclatitude ---shows all values for both Types
Thanks,
Neha
Hi @NehaSha ,
Could you please share your sample data and excepted result to me if you don't have any Confidential Information.Please upload your files to One Drive and share the link here.
Regards,
Frank
Hi @v-frfei-msft ,
Thanks for your reply! Data is confidential
Solution :
creating a New Table with 4 columns LocationKey , dclongitude,dclatitude, Type
This Table will be related to Master Table from ClientCompany which contain Unique locationKey , dclongitude and dclatitude with all other infor
Competition Table Contain only dclongitude and dclatitude , I decided to create new column is location key related to master table , Purpose to find which competitor location belongs to which Client location , so that zoom in can be easy
New table columns:
Type will be able to define the Competition or ClientCompany in Map
or
Map Legend will be Type :- for 2 different color based on Competition and ClientCompany
dclongitude ---shows all values for both Types
dclatitude ---shows all values for both Types
Thanks,
Neha
Hi ,
Thanks for your reply! Data is confidential
Solution :
creating a New Table with 4 columns LocationKey , dclongitude,dclatitude, Type
This Table will be related to Master Table from ClientCompany which contain Unique locationKey , dclongitude and dclatitude with all other infor
Competition Table Contain only dclongitude and dclatitude , I decided to create new column is location key related to master table , Purpose to find which competitor location belongs to which Client location , so that zoom in can be easy
New table columns:
Type will be able to define the Competition or ClientCompany in Map
or
Map Legend will be Type :- for 2 different color based on Competition and ClientCompany
dclongitude ---shows all values for both Types
dclatitude ---shows all values for both Types
Thanks,
Neha
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |