I am trying to create a line chart with x-axis Datetime and y-axis price. The stock historical data is in Supabase with the date datatype as timestampz. When I am trying to bind the date column, I am mapping date column from stock_history table (supabase) to x-axis. No errors are shown. However when i run in test mode, the app crashes.
Then i also tried to use the datetime format but i get this warning message every time i pick any format whatsoever.
In test mode i get assert error irrespective of any format i pick.
Appreciate any help. I am not sure how to fix this. Seems the user experience with date time should have been more elegantly handled between Supabase and Flutterflow. Or may be i am missing something.
Update: I tried using unixtimestamp in the hope that xaxis will purely a number list. So added a new column date_unix in supabase table stock_history.
Then updated as below on flutterflow.
And still failing.