Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
This seems to be working in the posted example. Don't seen any impact of selections.
=Count(DISTINCT {1<Record_ID = e({1<Record_ID = {"=Count({1<Year = {'<$(=Max({1}Year))'}>} Record_ID) > 0"}>})>} Record_ID)
Would be able to share an example where this isn't working?
remote to my laptop can ?
Remote to your laptop can? Not sure I understand bro
=Count(DISTINCT {1<Record_ID = e({1<Record_ID = {"=Count({1<Year = {'<$(=Max({1}Year))'}>} Record_ID) > 0"}>})>} Record_ID)
for my actual object, it required filter by a_rating_name = 'LOW', b_rating_name = 'LOW', so in the above expression , do i need to add this 2 fields in?
remote to my laptop. instead of providing the sample here. thats what i mean bro
Sure, I would add all filter that you might use
can you give me example. where to add in these fields?
May be here:
=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)
Sunny bro,
Not sure you know how to do this or not. There is 1 more requirement i am still do not know how to do.
- No. of records that changes detail in Category and Location. and what are those fields.
base on the example.qvw .
I am not sure I follow bro. There are too many things you are asking and I am not even sure if anything has been resolved yet or we are still dealing with the same issue?