Set Analysis Less than Date

[shasha3006]

Hi Good People,

want to ask, 

I want to create a set analysis  for results dated less than 12 months from the current date

this Is my script :

registered_date={"$(=Date(addmonths(MonthStart(Max(MakeDate(Year, Month))),-12),'YYYY-MM-DD'))"}

but, this didn't working.

can anyone help?

thanks 

[PrashantSangle]

can you explain little bit more?? Not working means what?? it is giving incorrect output or not giving any result.

Also, Share the screen shot of out put of what you are trying.

Regards,

Prashant Sangle

[vikasmahajan]

Hi,

Can you try following set analysis :

SUM({< registered_date = {"<=$(=Date(AddMonths(Max(registered_date ),-12),'MMM YYYY'))"} >}  Your Measure Field)

[shasha3006]

hi @PrashantSangle , 

i just want to change equal(red remarks)to < (less) than the date

so, I got the result that the data was less than the date  

[shasha3006]

hi @vikasmahajan ,

sorry, but its didn't work

i still get data more than 2022-03-01

[vikasmahajan]

can you attach sample data ?

Vikas

[shasha3006]

dear @vikasmahajan ,

i have data for delivery man, register date and avg spd

i want to the result of is delivery man who is register date less than 9 months (march 2021)  from current date (example , dec 2022) using set analysis

but when I try, I still got data more than march 2021

using this script

drop_salesman_registered_date={"<$(=Date(Addmonths(MonthStart(Max(MakeDate(Year, Month))),-1),'YYYY-MM-DD'))"}

😞

[vinieme12]

try below

drop_salesman_registered_date={"<$(=Date(MonthStart(MakeDate(Year, Month,1),-8),'YYYY-MM-DD'))"}

[shasha3006]

hi @vinieme12 , 

sorry its didnt work

[vinieme12]

can you post a FULL snapshot of your expression editor

also " didnt work"  what does this mean? did the expression fail or the results are  not as expected?