Selecting Data from a Week Ago Excluding Weekends for Chart

[slink]

Hi! I am looking to try and show data in my Qlik Cloud dashboard that averages the values in a column over the past week. I want the data to be averaged for the past week excluding Saturday and Sunday. I have looked at many posts and tried to use different versions of set analysis for this, but have been unable to find one that allows me to pull data that averages it all from the past week. Any help would be much appreciated!

[sidhiq91]

@slink  Could you please something like the below as your expression .

Sum({<OrderDate={">=$(=Date(Weekstart(today())-6,'MM/DD/YYYY'))<=$(=Date(Weekend(today())-7,'MM/DD/YYYY'))"}>}LineSalesAmount)

Kindly let me know if this worked.

[slink]

I apologize, I believe I worded the question wrong. I am looking for the dates/weekdays to show up as the x-axis labels for a graph, so I am looking for a way to show the past 7 days (excluding Saturday and Sunday). Your solution did help me with the data portion of it (thank you!), but now I cannot seem to figure out how to assign the dates to the graph if that makes sense. Thanks!