count today - 7 days

[#1]

Hi all

I have the following fields:

Date

Activity_id

I also have a table chart with the following expression: count(Activities_id).

I want to count (Activities_id) using set analysis, so that I'll count all the activities which were performed 7 days ago till today.

I'm not sure how I can do that... I'm using the following expression in order to count last week activities:

=count

(DISTINCT

  {$<[YearWeek_Num] = {$(=MAX([YearWeek_Num])-1)}>}

  [Activities_id]

)

can someone please advise?

thanks!

[#2]

Thanks!!!

[Digvijay_Singh]

I was trying to expression 

=Count({<Date1={">=$(=Date(today()-7))<=$(=Date(today()))"}>} Distinct Activity_ID),

It started working when I corrected my source date using preceding load,

Load Date#(Date,'DD/MM/YYYY') as Date1,

Unfortunately as of now I don't have licensed version so cannot see ur QVW, just check if you have similar problem. Thanks.