I have an app that saves stuff to firebase. Amongst other things datetime and date. I choose this in FlutterFlow. Works lika a charm. I see it in the firebase correctly as well. Saved in UTC. I then use the export to bigquery, and from there to Looker Studio. Here the problem starts. They are shown as pure UTC, and that is not what the user saw when entering it.
I know I can manipulate it in BigQuery and in Looker Studio. But when I have users all over the world it will be a freaking nightmare.
I figure the easiest way is to save the datetime and date as regular old strings alongside the UTC one in firebase. Use the UTC one in app for sorting and filtering and show the strings in Looker Studio. Of course cast them there so Looker Studio understands that they are dates.
This will give me the added value to compare countries in the future. Like how often something happens 8 o clock at night, world wide.
Any thoughts on this? Is this a really stupid way to go about it? What are my alternatives?
If anyone hasn't seen this I highly recommend it: https://www.youtube.com/watch?v=-5wpm-gesOY
Cheers
Martin