In cases, where we need to refresh a report surpassing the Cache everytime, we can create a report with a column hidden and making the column formula as-
CURRENT_TIMESTAMP
This will make the report run every time, for every change in second.
CURRENT_TIMESTAMP
This will make the report run every time, for every change in second.
