I have a table called Trades. The data in the raw table starts on 2024-05-01. It ends on 2025-05-02.
When I create a summary by Date table, I get a number of errors and the incorrect. I get dates that don’t exist in the raw data and errors in all the summary fields.
I clicked reload data engine and it didn’t help.
Help please. My data is being help hostage.
I copied the Trades table structure to a new table called TradesBackup.
Then I copied the data from the Trades table to the TradesBackup table.
When I group TradesBackup by date, it worked the way it was supposed to. But I have a lot of summery tables and don’t want to have to recreated everything. There is something wrong on the backend of my Trades table.
Is there a way to fix it so I don’t have to redo my whole application?
That’s strange! Is it possible that in the Raw Data view of the table there are filters applied?
I deleted all the records in the Trades table and deleted the Trades_summary_Date table.
Then added all the records back to the Trades table.
I created a new Trades_summary_Date table and now its working.
But there was something wrong with the data in the background.
