Step 2. Operating system ranking
Apache logs can provide information about the operating systems used to access our website. This data can be extracted from the userAgent column.
To extract the operating systems from the userAgent column, follow these steps:
- Access the demo.ecommerce.data table and click the Create column icon from the query window toolbar.
- Select User Agent OS Family as the operation, which will parse the user agent values and retrieve the corresponding operating system. Then click New argument and select the userAgent column. Enter a meaningful name for the new column (for example, operatingSystems).
- Click Create column. The new column will be added to the right of the table. Select its header and drag it next to the userAgent column.