Hi again @Jason_Tran, I tried with your code in the query bar on atlas charts and the field has been created but it seems there is no data. the chart stays empty. Here are some reference pictures. Usually I only use compass and atlas charts. For this task I want a bar chart that shows the profit per day. Base on the “Entry Date” Field. Note: Profit field can be negative too. And that should be represented in the chart aswell.
chart empty after applying the query: (this has happened to me in the past with other querys, idk If I’m missing something or any config, I tried with removing and adding the fields again, but that doesn’t work)