# How to display page views grouped by page name and time?

**URL:** <https://community.influxdata.com/t/how-to-display-page-views-grouped-by-page-name-and-time/55985>\
**Category:** InfluxDB 3\
**Tags:** influxdb\
**Created:** [January 22, 2025, 6:49pm UTC](https://community.influxdata.com/t/how-to-display-page-views-grouped-by-page-name-and-time/55985 "2025-01-22T18:49:21Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![beanbeanjuice](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/beanbeanjuice/32/19525_2.png) [@beanbeanjuice](https://community.influxdata.com/u/beanbeanjuice)\
**Post date:** [January 22, 2025, 6:49pm UTC](https://community.influxdata.com/t/how-to-display-page-views-grouped-by-page-name-and-time/55985/1 "2025-01-22T18:49:21Z")

</div>

```auto
    from(bucket: "beta")
    |> range(start: -1y)
    |> filter(fn: (r) => r._measurement == "pageview")
    |> filter(fn: (r) => r._field == "page")
    |> window(every: 1h) // Time windows of 1 hour
    |> group(columns: ["_start", "_value"]) // Group by time window start and page
    |> count(column: "_field")

```

Currently, I have this. In the table view, it does display the groups properly, and the count per group, but I’m not sure how to add a time field to this. Here’s what I’m trying to do.

06:00:00 “/gallery” 5  
06:00:00 “/home” 3  
07:00:00 “/gallery” 2  
07:00:00 “/home” 1  
08:00:00 “/gallery” 22  
08:00:00 “/home” 5

Right now, it just shows this.

 ![image](https://us1.discourse-cdn.com/flex023/uploads/influxdata/original/3X/e/6/e67409fc6dc1c1f8798c99f1482fa68e5bd9e779.png)