Ubidots Community

Date Range Excluding Today

I’m trying to create a daily summary, (variable’s aggregate sum, period 1 day) of the last 30 days, but I would like to exclude today, as today’s data is incomplete. Is there a way to accomplish this (without manually picking the date selector to exclude today)?

Hello @drths ,

It makes sense that one would want to exclude an incomplete data point, but unfortunately no, it’s not possible to exclude today’s date from the pre-built date pickers. The only way to do this would be to manually select the dates excluding today or build an UbiFunction (only for Professional licenses and above) where you calculate the values only when the day has ended, so that you get the readings of complete data sets for the day.

Best regards,
Sebastián

Okay, I’ll look into a workaround