Last refresh date does not update for incremental refresh

Q&A
,
1

Hello Team,

I have created a dataset and created a calculated field on the dataset level:
last_refreshed_at = addDateTime(30,‘MI’,(addDateTime(05,‘HH’,now())))

Now, I have setup an incremental refresh on hourly basis.

The situation is: My dataset is getting refreshed correctly but the last_refreshed_at field is having multiple dates as the incremental refresh does not update that field for all records.

Only fields which are updated during the last refresh window have the correct last_refreshed_at field.

I want this field to have the date when my dataset was last refreshed irrespective whether the record was updated or not.

Please help me out as my readers are having a lot of confusions due to this,

Thanks in advance,
ajinkya

2

Hi @ajinkya_ghodake

that is the expected behavior, as incremental refresh does not update any of the records outside the refresh window. You cannot get what you want with an incremental refresh.
You might want to create another calculated field at the analysis level that would populate an entire column with the last value from the last_refreshed_at

something like:

new_calculated_field = maxOver(last_refreshed_at, , PRE-AGG)

Try it and let us know,

GL

3

Works perfectly,
Thanks a ton @gillepa