Solved

Remove Weekends visitors from Line Chart

  • 19 April 2021
  • 8 replies
  • 555 views

Badge +3
  • Certified Partner
  • 17 replies

Hi,

 

Is there a functionality where I can filter out days like Saturday and Sunday from the line chart?

 

I only want to see the activity on certain days of the week?

 

Let me know if there is any such feature

icon

Best answer by claudias 18 May 2021, 00:42

View original

8 replies

Userlevel 4
Badge +2

Hello @Affan  What you can do is. In the bar chart view breakdown by day of week then exclude Saturday and Sunday by clicking on the bar. After that change to line chart and remove the date breakdown.
 

 

screenshot :)

 

Badge +3

I think this is only changing Saturday and Sunday values to 0.

 

I actually don’t want the Saturday and Sunday drop in the line chart,

 

The line chart should connect from Friday to Monday of the next week.

 

Let me know if there is any such functionality.

Userlevel 4
Badge +2

hmm, maybe add this in idea board. A way to change x-axis.

Badge

Hi @Affan , 

Claudia here from Mixpanel’s Solutions Engineering team - thanks for your question!

In order to take out Saturday and Sunday data points on a line chart, you would want to do something like this: 

 

However, if this does not hit on what you are trying to see, I would love to learn more about what you would are envisioning. We would appreciate as much detail as possible!

Hi,


I’d like to exclude weekend days but I couldn’t find your left tab with teh week days.

How did you show it ?​​​​​​​

Userlevel 5
Badge +5

@Natev this tab is now underneath your chart if you scroll down to where the breakdown is visible

Hi,

 

Is there a functionality where I can filter out days like Saturday and Sunday from the line chart?

 

I only want to see the activity on certain days of the week?

 

Let me know if there is any such feature

Friendly feedback, you should explain what “do something like this” means.  I am trying to do the same thing and have no clue how you’re getting to a filter where I can exclude days of the week.

Userlevel 5
Badge +5

Thanks for the feedback @davidyyoung we’ll try and include short videos or step by steps going forward. We also have a number of workshops that walk through this here

Reply