Date filter in reports.

Related products: None

Hi,

 

We had a use case where the data is being loaded into an object at 4:00 am and when the filter is set to show data for today, the reports will show no data for the time between 12:00am and 4:00am. Also the data cannot be loaded early due to some inconveniences.

So  a filter like “max of date” could be useful here to display the data for the day till the new data comes in. The aim is to avoid an empty object during the specific time period.

Hi @rvinny 

When data is loaded at 4 am, today filter should work.

The only condition where this might not work is with Timezones when the user’s and the tenant's timezone might not be the same. 


@rvinny did you see the comments here.


@sai_ram Yes @rakesh  The user case is more like when we have some widgets or reports on a dashboard to display the data for the latest day. So we use the filter like load date = today for them.

 

But the customer will load the data only at 4am. So until then the widgets and reports are showing as empty. Between 12 am to 4 am there is no data displayed since there is no data loaded “today”. These reports and widgets are only populated after 4 am once the data are loaded for the day.

 

So if we had a filter like date = max date, this would help keeping these reports and widgets populated by showing the latest data.