Chart data except for weekend dates?

[SandsB]

I have lots of files with thousands of rows of data. I make charts that go up and down because of very low numbers on weekends. Makes it hard to see what really going on over time. Is there a way to use ALL of the same data without picking out weekends so the chart only shows weekdays? Something using NETWORKDAYS maybe?

 

[saboh12617]

Hello,

You can use the FILTER function to retrieve only the days that are not weekends. For weekends = [Saturday+Sunday], the formula would be

=FILTER(your_data, WEEKDAY(your_dates, 2)<6)

With your_data the data to filter, and your_dates the corresponding dates column.

Note that you can also add an helper column with the WEEKDAY function, and use a manual filter on it.