...
| Rw ui steps macro |
|---|
Go to Data Searchsearch and open the required table. Perform the required operations to get the data you want to use in the chart. | Note |
|---|
Missing required data If your table does not contain fields representing a pair of latitude and longitude values in integer or float format, you can use the operations in the Geolocation group to create latitude and longitude fields based on existing data in your table. For example, you can add to your table the latitude and longitude values corresponding to a set of IP addresses using the Geolocated Latitude (mmlatitude) and Geolocated Longitude (mmlongitude) operations. |
Click the gear icon on options menu in the toolbar and select Additional tools → Charts → Maps → Google heat map. Click and drag the column headers to the corresponding fields. Required Field | Data Type |
|---|
Latitude | float, integer, duration | Longitude | float, integer, duration | Size/Color | float, integer, duration | Partitioning optional | string |
The Google heat map is displayed.  Image Removed Image Added |
Working with Google heat maps
...
You can recreate the example shown in the picture above using the data of the following query and mapping the fields as follows:
Query | Required field | Column added |
|---|
| Code Block |
|---|
from demo.ecommerce.data
select mmlatitude(clientIpAddress) as latitude,
mmlongitude(clientIpAddress) as longitude
group every 1m by latitude, longitude, method, timeTaken
every 1m |
|
...
Required field | Column added | Longitude | latitude |
|---|
Longitude | longitude |
Size/Color | timeTaken |
Partitioning | method |
...
