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?
Best answer by Saish Redkar
View original
How to group events by day of week?
Userlevel 7
+10
Hey
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!
Have a great weekend.
Userlevel 6
+8
Hi
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
+10
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
Welcome to the Amplitude Community!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. You can also create a Guest account below!
If you're a current customer, select the domain you use to sign in with Amplitude.
analytics.amplitude.com analytics.eu.amplitude.comor
Welcome to the Amplitude Community!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. Want to sign up as a guest? Create a Community account.
If you're a current customer, select the domain you use to sign in with Amplitude.
analytics.amplitude.com analytics.eu.amplitude.comor
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.