How to display new and deleted records using expression?

[jim_chan]

Hi guys,

I have 2 years of data loaded in. Now client want to know what is the created record_id. But unfortunuatelty, under status - there's no value of "NEW" but just have 'deleted' and 'active'

So, how to  display new records using expression?

Rgds,

Jim

[jim_chan]

Yes we r still dealing with the issue. i still couldnt get the figure right. here;s the screeenshot on what i have clicked to filter. it has "Sunny Help" and also the Actual figure.

Sunny 's expression:

=Count(DISTINCT {1<record_id = e({1<record_id = {"=Count({1<Year = {'<$(=Max({1}Year))'}>} record_id ) > 0"}>}), A_Rating_Name = {'LOW'},B_Rating_Name= {'LOW'}>} record_id )

Actual Result expression:

=Count(DISTINCT {<record_id = e({<record_id= {"=Count({<Year = {'<$(=Max(Year ))'}>} record_id) > 0"}>}), A_Rating_Name = {'LOW'}, B_Rating_Name= {'LOW'}>} record_id)