Count the date for 7 rolling days.

[iahmadmca1]

Team,

I am using the expression for count the 7 rolling days.so I request to everyone please suggest me to do the 7 rolling days.

Please find the below expression and make it 7 rolling days.based on file date.

=num(If(AMPM='AM',

  Only({<AMPM = {PM}>} TOTAL<[TGB Name], f_date> Counts) /Only({<AMPM = {AM}>} TOTAL<  [AMI TGB ID]> Counts)-1,

  Only({<AMPM = {AM}>} TOTAL<[TGB Name],f_date> Counts)/ Only({<AMPM = {PM}>} TOTAL< [AMI TGB ID]> Counts) -1

),'#.##%')

Thanks,

Irshad Ahmad

[Anil_Babu_Samineni]

You can use like below

Count({<Date={‘>=$(=Date(Max(DateField)-7))<=$(=Date(Max(DateField)))’}>} Measure)

[hariprasadqv]

Try Rangesum() with above() for last 7 records. It will work.

[iahmadmca1]

Thanks Anil for the reply.

[iahmadmca1]

Thanks Hari for the reply.

[iahmadmca1]

Hi Anil,

could you please use my expression which I post and make it correct because I try to use the expression which you have sent but is showing error.please correct of my expression based 7 days rolling.

Thanks,

Irshad Ahmad

[Anil_Babu_Samineni]

May be like this?

=Num(Count({<Date={‘>=$(=Date(Max(DateField)-7))<=$(=Date(Max(DateField)))’}>} If(AMPM='AM',

  Only({<AMPM = {PM}>} TOTAL<[TGB Name], f_date> Counts) /Only({<AMPM = {AM}>} TOTAL<  [AMI TGB ID]> Counts)-1,

  Only({<AMPM = {AM}>} TOTAL<[TGB Name],f_date> Counts)/ Only({<AMPM = {PM}>} TOTAL< [AMI TGB ID]> Counts) -1

), Measure),'#.##%')

[iahmadmca1]

Thank you Anil !