How to compare the id for the current date and the previous month

[shruthibk]

Hi all,

I need to compare the id's in the script level only. i tried to use peek and previous function this will compare by row wise not with previous month.

sample data attached

Thanks,

Shruthi

[sunny_talwar]

Why is this 0?

[annafuksa1]

you should to use above function in chart, previous in script

please look at example in my app

[Anonymous · Accepted solution]

Hi,

Flag_Table:

LOAD *,

    if( Previous(ID)=ID and AddMonths(previous(Date),1)=Date,1,0) as Flag_Test

Resident Date

order by ID, Date;

drop table Date; 

Where the date is the table you have, but you need to ensure that you read the data as data, with DATE#(Date,'MM/DD/YYYY') as Date.

Best regards,

Cosmina

[shruthibk]

ya it should be 1

[sunny_talwar]

Did you look at the cocosmina‌'s response? It should have worked for you.... Is it not working?

[shruthibk]

Thank you