Example: Adding latitude and longitude data to a map
This example uses the California website visits sample data to show data by latitude and longitude on a map.
You must have access to the IBM® Cognos® Analytics with Watson base samples. If your administrator installed these samples, they are in .
Before you begin
- Click New and then click Report.
- In the Templates and themes window, click Blank and then click OK.
- On the canvas, click the Pinned icon , and then click Visualization.
- In the Visualization gallery, click Map, and then click OK.
- At the top of the data slot pane, click the down arrow and select Latitude/Longitude.
- In the navigation pane, click Select sources or the Add a source icon , select and click Open.
- Expand California Zip Website Visits Xlsx and drag Latitude and Longitude to their data slots.
- Drag City to the Label data slot. The latitude, longitude, name of the city appears when you hover over the data points.
- Drag Website Visits to the Point size data slot and drag Visitor Ranking to the Point color data slot.
Select Page preview to run the report. Note: You can also click to run the report.The report runs and zooms in on California. Notice that the visualization is hard to read because the points are very close together.
- Select Page design to return to page design mode. If you ran the report from Run options, close the tab, which returns you to page design mode.
- Make sure that the visualization is selected on the canvas, and in the Properties pane, under LATITUDE/LONGITUDE, in the Type field, select Cluster.
- Under LATITUDE/LONGITUDE, set Transparency to 20.
- Optionally, under COLOR PALETTE, set a color palette for the Latitude/Longitude property.
- Run the report. Now the website visits are clustered by latitude and longitude.
- Save the report when you're done.