# Is it possible to create a report like GA3's "Users by time of day"?

**URL:** <https://community.piwik.pro/t/is-it-possible-to-create-a-report-like-ga3s-users-by-time-of-day/2040>\
**Category:** Reports and working with data\
**Created:** [April 18, 2023, 8:48pm UTC](https://community.piwik.pro/t/is-it-possible-to-create-a-report-like-ga3s-users-by-time-of-day/2040 "2023-04-18T20:48:50Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![johnny\_n](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/johnny_n/32/1649_2.png) [@johnny\_n](https://community.piwik.pro/u/johnny_n)\
**Post date:** [April 18, 2023, 8:48pm UTC](https://community.piwik.pro/t/is-it-possible-to-create-a-report-like-ga3s-users-by-time-of-day/2040/1 "2023-04-18T20:48:50Z")

</div>

New to Piwik Pro - absolutely loving it, clean and simple and very easy to see and find the data I’m looking for without wading through a bunch of things I’m not.

One thing that’s very helpful to us in GA3 is the chart under the heading “When do your users visit?” – which shows a very simple chart of the traffic at all days/times. I haven’t seen anything similar to this in Piwik Pro, and didn’t see anything similar in the “12 useful custom reports” (which is very helpful btw)…

Thank you!

---

<div class="post-metadata">

**Author:** ![piotr](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/piotr/32/1654_2.png) [@piotr](https://community.piwik.pro/u/piotr)\
**Post date:** [April 18, 2023, 8:58pm UTC](https://community.piwik.pro/t/is-it-possible-to-create-a-report-like-ga3s-users-by-time-of-day/2040/2 "2023-04-18T20:58:42Z")

</div>

Hi @johnny_n,

Welcome to the community. I’m glad you like the product. Spread the good word 🙏

Is this what you’re looking for?

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/2X/f/f6b8158355c7cbc1cb69ba368b708f8826217ce0.png)

If so, here’s the definition of the report (Custom report → Bar chart):

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/2X/4/40f4d269548bd85dd7c2d8228adf8a5d4fdd4caa.png)

Cheers!

---

<div class="post-metadata">

**Author:** ![johnny\_n](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/johnny_n/32/1649_2.png) [@johnny\_n](https://community.piwik.pro/u/johnny_n)\
**Post date:** [April 18, 2023, 9:09pm UTC](https://community.piwik.pro/t/is-it-possible-to-create-a-report-like-ga3s-users-by-time-of-day/2040/3 "2023-04-18T21:09:29Z")

</div>

Hi Piotr – thanks so much, I think that can get me close. I’ll start there…

I should have included this screenshot in my original post. This can represent any time frame and very easily gives a good idea of when the site receives the most traffic at a glance (darker is more traffic)… just quickly gives a nice “feel” for what’s happening with the site.

 ![Screenshot 2023-04-18 at 4.05.53 PM](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/2X/1/1049abdf0c7f779d4cec2f9d911b1110a92d8e55.png)

Thanks again, and will do! 😀

---

<div class="post-metadata">

**Author:** ![piotr](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/piotr/32/1654_2.png) [@piotr](https://community.piwik.pro/u/piotr)\
**Post date:** [April 19, 2023, 2:55pm UTC](https://community.piwik.pro/t/is-it-possible-to-create-a-report-like-ga3s-users-by-time-of-day/2040/4 "2023-04-19T14:55:50Z")

</div>

Oh, yeah. This is more comprehensive.

Unfortunately, we don’t have such two-dimensional representation.

I recommend analyzing two bar charts, one that I shared before and another with an extractions for days:

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/2X/3/3f5a3a110c30e4e2e87043c68e9520ea5008ad08.png)  
_(see that there are other extractions you can get)_

Or just export data out of the simple table with two dimensions with following extractions:

- Date (group by hour of day)
- Date (group by day of week)  
And create a pivot table in Excel/Sheets.  
 ![image](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/2X/7/71f05d5edeb89ea23ad4c3fb33b4a682dff114e2.png)

I know, the last one is suboptimal but it will get you the exact thing you look for.

---

<div class="post-metadata">

**Author:** ![johnny\_n](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/johnny_n/32/1649_2.png) [@johnny\_n](https://community.piwik.pro/u/johnny_n)\
**Post date:** [April 19, 2023, 7:31pm UTC](https://community.piwik.pro/t/is-it-possible-to-create-a-report-like-ga3s-users-by-time-of-day/2040/5 "2023-04-19T19:31:39Z")

</div>

Thanks so much for the additional information – this is very helpful, I’ll test these two options out and see which one is preferred. I really appreciate you taking the time to give me some suggestions!

All the best,  
john