• v7.7.0
    • v7.11.0 (latest)
    • v7.10.0
    • v7.9.0
    • v7.8.0
    • v7.7.0
    • v7.6.0
    • v7.5.0
    • v7.3.0
    • v7.2.0
    • v7.1.1
    • v7.1.0
    • v7.0.8
  • Services & Support
  • Devo.com
  • Contact
    • Contact Us
    • Request a Demo
    • Partner Inquiry
  • Log In
    • USA Devo
    • EU Devo
PREVIOUS
Visualize the usage share of operating systems
NEXT
Build a histogram displaying country distribution

Searching data / Working in the search window / Use case: eCommerce behavior analysis / Step 3. Country distribution

Download as PDF

Step 3. Country distribution

Devo also includes a comprehensive set of geolocation functions that can be used to extract relevant geolocalization information from IP addresses.

  1. Suppose you want to extract the information of the countries from where the connections have been made. You can reuse our example query, going back to the moment we created the operatingSystems column. To do it, select the Node tree tool on the toolbar and click the step where we created the column. 

  2. Now select the clientIpAddress column and click the Create column icon on the toolbar.
  3. Enter Country as the name of the new column and select the Geolocated Country (mmcountry) operation. Select Create column when you're done. You will get the country codes corresponding to the IP countries.

  4. Apply a Filter Or to the new column data to show only not-null values. To do it, hover over the column header and select the arrow that appears. Check the box at the top of the distinct value list to select all the values, and uncheck only the null value from the list. Select Apply in the window that appears to filter the data.

  5. As said above, the values returned in the Country column are codes, not the country names. If you want to obtain the country names, you have to create a new column using the ISO-3166-1 Country Name (countryname) operation.

Select and drag the new columns next to the clientIpAddress column to display the countries and corresponding codes next to the client IP addresses.

Download as PDF

PREVIOUS
Visualize the usage share of operating systems
NEXT
Build a histogram displaying country distribution

Export

See what Devo can do for you. Request a demo!
Discover what's new (Release notes)
  • v7.7.0
    • v7.11.0 (latest)
    • v7.10.0
    • v7.9.0
    • v7.8.0
    • v7.7.0
    • v7.6.0
    • v7.5.0
    • v7.3.0
    • v7.2.0
    • v7.1.1
    • v7.1.0
    • v7.0.8
  • Services & Support
  • Devo.com
  • Contact
    • Contact Us
    • Request a Demo
    • Partner Inquiry
  • Log In
    • USA Devo
    • EU Devo
  • +1 888 6830910 (USA)
  • +34 900 838 880 (Spain)
Copyright © 2019 Legal Terms Privacy Policy Cookies Policy

Powered by Confluence and Scroll Viewport