Exclude Weekends in Line Chart

[arul]

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,

[Brett]

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:

How do I exclude weekends from the visuals?

How do I exclude weekends from the visuals? I have tried using conditional formula isWorkday(date) which gives me 1 for weekday and 0 for weekend, when I try to use it as a filter for a graph, exclude all 0s, or just include all 1s, it is showing an error. sourceErrorCode: CONTEXTUAL_INVALID_ARGUMENT_TYPE How do I do this correctly?

[arul]

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.