Hello everyone,
I work for a B2B company and we want to track the monthly development of events by using timelines (see screenshot). Is it possible to exclude the weekends?
Thanks for you help.
Best answer by Saish Redkar
View original
Can I exclude weekends from my charts?
Userlevel 7
+10
Hey
Afaik, there isn’t a direct way to filter out the weekends in Amplitude. You can try using the offset functionality, but that doesn’t help much for a longer time horizon beyond a week.
Their documentation suggests using the rolling window/average metric to smooth out the chart in case of cyclical users, but not sure if that suits your use case.
The only other approach I can think of is instrumenting a ‘day_of_week’ property or creating this as a derived property ( if you are already sending a custom timestamp property ) and try filtering out Saturday and Sunday values.
Let me know if I have interpreted your use case correctly. Hope this helps.
Thank you Saish, helpful as always! :)
Do you know if Amplitude is planning to introduce an exclude weekends functionality any time soon?
Userlevel 6
+8
Hi
Kind Regards,
Denis
Just wanted to add a +1 (not being able to exclude weekends is the main reason we still use Pendo for some of our analytics instead of doing all on Amplitude).
Userlevel 6
+8
Hi
I'm happy to pass this information along to our Product team on your behalf via a feature request. Would you be so kind as to PM me your email address you use for Amplitude and your name? Thank you so much!
+1 for me too, i’ll send you a PM
Userlevel 7
+10
Amplitude recently launched the Event Hour of Day / Day of Week properties wherein you can use these properties to selectively filter on specific days/hour of the event occurrence ( not sure if this is GA to all or just paid customers )
You can exclude events performed on Saturday/Sunday and the charts will show 0 activity on those days per your selected timezone. If the use case is not showing the weekend days on the x axis altogether, then this is something which is not supported yet.
Userlevel 6
+8
Thanks for that too
Thanks for the replies.
And yes our case was for the x-axis, but the exclusion of certain weekdays is helpful nonetheless.
+10
Really interesting there is such strong demand for this! I use Amplitude for several B2B SaaS products but we just use “weekly” rather than “daily” as the standard time interval. I’m curious about the situation where it’s important to be able to see weekdays only?
Thanks for that too
Hi! Is there a solution for this topic? I work in a SaaS B2B and the weekends (and holidays) are no useful for us.
Thanks!
Does Amplitude has any update for this feature request raised one year ago ?
Our team is facing the same situation at the moment.
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.