Exclude Weekends in Line Chart

Question & Answer
,
1

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 to exclude the Weekends? Please let me know.

Thanks,

2

Hi @arul and welcome to the QuickSight 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:

3

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 for 12th April and 13th April as it is not there in Dataset.
But the line chart by default populates 12th and 13th APril. Is there way to restrict the weekends from Line chart.

4

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

image
image208×760 22.6 KB

5

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!

6

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!