We have created a query but it is generating an error as it is returning more than the maximum amount of records allowed. Is there a way to add filters in dashboard to allow user to easily filter by periods and change to pull all data in multiple reports?
Also, I am trying to sum data to reduce the number of rows. Can someone advise how to fix my query?
Select "installment_id", SUM("subtotal") as 'Subtotal' From "coyuchi_subscription_installment" Where "status" = 'pending' Limit 100
Don't panic, but we found an error with your query.
Could not run query: explain select "installment_id", sum("subtotal") as 'subtotal' from "coyuchi_subscription_installment" where "status" = 'pending' limit 100 . ERROR: syntax error at or near "'Subtotal'" LINE 2: SUM("subtotal") as 'Subtotal' ^