Set expression not working as intended

[#1]

I have the following expression in a chart, which members here told me would only show data from the past 7 weeks

sum({<[Paid in full date]={">=$(=Date(Today()-7))<=$(=Date(Today()-1))"},[Customer] = >}

date([Paid in full date])

-

date([Invoice date])

) / Count( {<[Paid in full date]={">=$(=Date(Today()-7))<=$(=Date(Today()-1))"},[Customer] = >}Count)

However, I want to test with data in the last 6 days, so I replaced the 7 with a 6, but nothing appeared.

Here are my dates

Any ideas?

[#2]

I just did the math by hand and you're right. Thanks!

[sunny_talwar]

Doing the math by hand is always a great idea.... you will see how much insights you will gain by doing that. I am glad you did take time to do this.

Best,

Sunny