How to count on fields that have changes in value.

[jim_chan]

Hi guys,

I have a requirement:

- display total no of records - i assume is count(record_ID) ?

- display records that have made changes of the total of number records?

I have attached a sample qvw with inline data. 

Please help guys.

Rgds,

Jim

[sunny_talwar]

This will give you a comma separated list of Record_ID which changed

=Concat(DISTINCT {<Record_ID = {"=Len(Trim(Only(Rating))) = 0"}>}Record_ID, ', ')

[jim_chan]

wow.... Sunny! thanks!!! all works!

[jim_chan]

I have a question, Sunny.

I created a filter called - rating, so it has 10.20,30. so when i select 20. it wont show me any result....

why is it so?

Rgds

Jim

[sunny_talwar]

The way the expression is structured, it gave you that result. May be try this:

=Concat(DISTINCT {<Record_ID = {"=Len(Trim(Only({<Rating, Record_ID = P(Record_ID)>}Rating))) = 0"}>}Record_ID)

[jim_chan]

Sunny Bro, for the Year...is it logical if i allow user to select filter Year?

[sunny_talwar]

Is it logical? I guess it would depend on user needs, right? I am not sure what exactly are you looking for?

[jim_chan]

for instance, user access the dashboard, user clicks on year 2016 to see what record_id's rating has changed.

[sunny_talwar]

Sure, that seems logical.

[jim_chan]

but i cant see it from here. is it bcos the record_id's has no changes in 2016?

[jim_chan]