Rolling 12 months

[#1]

I am confused!

I am trying to make a chart that shows the number of visits over the course of the last 12 months.  My expression works until I include the 12 month piece....

count({<[Appt Arrived Flag]={1}, [BHN Dept Name]={'Health Centers'},Month={'>=(Date(floor(max(Month))-365))'}>}CountAppt)

If I take the expression:

=Date(floor(max(Month))-365)

and put it into a text box, it works!  (I get 8/1/2012)

But when I add it as part of the set analysis I get NOTHING!

[#2 · Accepted solution]

Nevermind... I answered my own question 2 minutes after I posted it!

count({<[Appt Arrived Flag]={1}, [BHN Dept Name]={'Health Centers'}, [Appt Datetime]={'>=$(=Addmonths(max([Appt Datetime]),-12))'}>}CountAppt)

[MayilVahanan]

HI

=Date(floor(max(Month))-365) gives date.

So you map with date in set analysis , not with month

count({<[Appt Arrived Flag]={1}, [BHN Dept Name]={'Health Centers'},DateField={'>=$(=AddYears(Max(DateField),-1))'}>}CountAppt)

Hope it helps

[#4]

Hi,

Try this :

<month={"<= $(=date(floor(max(month())-365)) "}>

Regards

DAAM