Solved

How to group events by day of week?

  • 30 July 2021
  • 4 replies
  • 518 views

Badge

I want to show the average or unique value of an event in the last 90 days, but grouped by day of the week. So I can see which days have more-less activity on that specific event.

Is this possible?

icon

Best answer by Saish Redkar 31 July 2021, 05:19

View original

4 replies

Userlevel 7
Badge +10

Hey @IceDev 
If you want a simple visualization of how a particular event is performed on a daily basis for the last 90 days, a chart similar to this one might help. This just shows which days in a week the given event is performed the most during that time period

But if you want to actually use a group by on the day of the week and display the event count by day of the week e.g Monday, Tuesday then there isn’t a direct way of doing this in Amplitude. A hacky  workaround would be to instrument the time aspect you want to capture as an event property on all events or the specific usage event, e.g "event_day" : "Monday".

Here’s a similar question which was asked before for added context-

 

Hope this helps!

 

 

Badge

@Saish Redkar Thanks for the reply, I was afraid of that my only choice was going to be the hacky solution.. but’s fine I’ll do that.

Have a great weekend.

Userlevel 5
Badge +4

Hi @IceDev! I just wanted to confirm that Saish’s suggested workaround is also the recommendation we at Amplitude would provide as there currently isn’t a way to do analyses based on time of day. 

That said, I am more than happy to submit a feature request on your behalf to the Product team. Can you send me a DM with your org name, name, and email address? 

Alternatively, you can add this feedback to the Product Feedback section of the Community: https://community.amplitude.com/ideas

Badge

Looks like the Amplitude team implemented this now, and it’s in beta at a derived property for those with the Govern add-on.

I really like day of the week analysis, so I wrote a blog post describing how to use it:

https://timothydaniell.medium.com/how-to-group-analyse-by-day-of-the-week-in-amplitude-e2b1913c7e1b

Reply