So I have kept the cache interval as 1 day. But I believe the table is updating every midnight (00.00 hrs) as we have not mentioned the time anywhere yet.
Is there any way to fix a time when the 24 hr period refreshes itself? Like 10 pm everyday.
I see an option for time zone selection just above the cache interval option in the table properties, but I am not sure of all the effects this time zone can have in my solution.
To select the option to refresh everyday at 10PM shall I select a time zone 2 hrs behind my time zone and put the cache interval as 24 hrs? Can it impact the notifications and event frames true for time in any ways if event frames are dependent on the table data. Please advice.