Team, In the line chart can we exclude the Weekends? The dataset that i have does not have data for Weekends because of that i am not able to make use of isworkday function or the Extract function to filter the data. I see when pulling in Line Chart all the dates are getting populated. Is there way…

Hi @arul , What if you setup a filter for your date field, something like the following that allows you to exclude nulls? [image]

Hi @Brett , Thank You for the reply. I had tried the above mentioned option. The Problem there is, i have dataset that does not have Weekend dates included. Below is an example: Date Count 9-Apr 5 10-Apr 10 11-Apr 150 14-Apr 200 i expect the Line chart not to have X axix value fo…

Hi @arul , Following up here as it’s been awhile since we last heard from you on this thread; did you have any additional questions or were you able to find a work around in the interim? If we do not hear back within the next 3 business days, I’ll close out this topic. Thank you!

Hi @arul , Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed. Thank you!

Exclude Weekends in Line Chart

Q&A

Brett April 14, 2025, 9:14pm 2

Hi @arul and welcome to the Quick Sight community!
I was able to find an old community post that had a similar request, check out the solution provided here and let us know if this may work for your case:

Topic		Replies	Views
How do I exclude weekends from the visuals? Q&A error , quick-sight , calculations , Business-Intelligence-Engineer	2	439	May 27, 2024
How to Exclude specific dates Q&A quick-sight , calculations , Business-Intelligence-Engineer	4	274	April 24, 2024
How to exclude the weekend days from network formula? Q&A developer , quick-sight , qls-dev-resources	7	276	February 16, 2024
How to exclude data from specific dates in a visual Q&A filters , date , quick-sight , Business-Intelligence-Engineer	10	1071	November 27, 2023
When applying a week filter to a line chart. Can we see the week start date and end date in CSV Q&A developer , quick-sight , export-embed , qls-learningdash	3	183	June 1, 2024

Exclude Weekends in Line Chart

Related topics