Time series stock price charting

Troubleshooting

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.

Screenshot 2024-11-22 at 11.24.14 AM.png
45.14KB

Then i also tried to use the datetime format but i get this warning message every time i pick any format whatsoever.

Screenshot 2024-11-22 at 11.08.31 AM.png
205.28KB

Screenshot 2024-11-22 at 11.27.49 AM.png
352.97KB

In test mode i get assert error irrespective of any format i pick.

Screenshot 2024-11-22 at 11.28.50 AM.png
362.47KB

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.

Screenshot 2024-11-22 at 12.08.31 PM.png
210.5KB

Then updated as below on flutterflow.

Screenshot 2024-11-22 at 12.09.32 PM.png
338.87KB

And still failing.

Screenshot 2024-11-22 at 12.11.59 PM.png
485.3KB

What have you tried so far?

This is supabase view of stock_history.

Screenshot 2024-11-22 at 11.08.31 AM.png
205.28KB

Did you check FlutterFlow's Documentation for this topic?
Yes
3