Skip to main content

Complex Website

This dataset contains views and clicks on a website on various browsers, countries, and platforms.

Let's start by finding some events:

Loading...

Each row has a time represented in hours since epoch, which we can convert to a more friendly format using the FromEpochHours and ToDateTime functions.

Let's use those functions to see how many views, clicks, and errors our website has on different days:

Loading...

Try ordering by allViews or allErrors to see how that changes the most popular day.

We can also drill down to find the events on a particular day:

Loading...

We can also aggregate each of these metrics by browser:

Loading...

Next let's drill down to see what's going on with the chrome browser:

Loading...

What about if we do it by country?

Loading...