I'm developing a dashboard to be implemented in a Mexican Plant, but, I'm having problems with the filter formulas and the timezone.
I need to show the current day's data but, because China is 14 hours more than Mexico, at 10:00 am my graphs turn white. Does anyone know how can I calculate the -6:00 timezone in a date field in order to use it in my filter?