Versions Compared

Old Version 4

changes.mady.by.user Borja Moro Moreno

Saved on

compared with

New Version 5

changes.mady.by.user Borja Moro Moreno

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

...

Column added

Required field

Longitude
latitude
Longitude
longitude
Size/Color
timeTaken
Partitioning
method
...