Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When I load points they all appear incorrectly; data appears to be loading correctly;
using load script
Unqualify *;
CustomerAccounts:
load *,
GeoMakePoint(Latitude,Longitude) as GeoKey;
load
AccountFacts.AccountReportingLevel0 as Theater,
AccountFacts.AccountReportingLevel1 as Region,
AccountFacts.AccountReportingLevel2 as Region_Sub1,
AccountFacts.AccountReportingLevel3 as Region_Sub2,
SFAccountId,
ApplyMap('HasCapacityOppty',SFAccountId,'No') as HasCapLikeOpenOppty,
AccountFacts.AccountName as AccountName,
AccountFacts.AccountType,
AccountFacts.AccountStatus,
AccountFacts.AccountOwnerName as AccountOwner,
AccountFacts.CountryTheater,
AccountFacts.BillingStreet,
AccountFacts.BillingCity,
AccountFacts.BillingState,
AccountFacts.BillingPostalCode,
AccountFacts.Country,
AccountFacts.CountryISO3166Alpha3,
AccountFacts.CountryGroup,
AccountFacts.CountryGroup_PAC,
AccountFacts.IsEmergingCountryGroup,
AccountFacts.EmployeeSegment,
AccountFacts.VerticalSegment,
AccountFacts.Industry,
AccountFacts.SIC,
AccountFacts.IndustryDescription,
AccountFacts.NumberOfEmployees,
AccountFacts.Longitude as Longitude,
AccountFacts.Latitude as Latitude,
Example of point on incorrect map?
Using the Maps Chart Object - Points Maps - Part 1 - (video)
| [-71.281088999999994,41.945084999999999] |
Can you please attach only your lat & long data if it is not confidential?
Thanks
sorry it is confidential.. example of data is the [] above.