I get this error when I try and change the Net Vol...
# announcements
r
I get this error when I try and change the Net Volume by Quarter report to monthly. I should add that I am unselecting Quarter and selecting month. • f405 • (psycopg2.ProgrammingError) column "stripe_balance_transactions.created_quarter" does not exist LINE 1: ...BY "stripe_balance_transactions.created_year" ASC,"stripe_ba... ^ [SQL: 'SELECT "stripe_balance_transactions"."type" "stripe_balance_transactions.type","stripe_balance_transactions"."created_month" "stripe_balance_transactions.created_month","stripe_balance_transactions"."created_year" "stripe_balance_transactions.created_year",COALESCE(SUM("stripe_balance_transactions"."net_amount"),0) "stripe_balance_transactions.total_transaction_net_amount" FROM "stripe_balance_transactions" "stripe_balance_transactions" WHERE "stripe_balance_transactions"."type"=\'charge\' GROUP BY "stripe_balance_transactions.type","stripe_balance_transactions.created_month","stripe_balance_transactions.created_year" ORDER BY "stripe_balance_transactions.created_year" ASC,"stripe_balance_transactions.created_quarter" ASC LIMIT 50;'] (Background on this error at: http://sqlalche.me/e/f405) • SELECT "stripe_balance_transactions"."type" "stripe_balance_transactions.type","stripe_balance_transactions"."created_month" "stripe_balance_transactions.created_month","stripe_balance_transactions"."created_year" "stripe_balance_transactions.created_year",COALESCE(SUM("stripe_balance_transactions"."net_amount"),0) "stripe_balance_transactions.total_transaction_net_amount" FROM "stripe_balance_transactions" "stripe_balance_transactions" WHERE "stripe_balance_transactions"."type"='charge' GROUP BY "stripe_balance_transactions.type","stripe_balance_transactions.created_month","stripe_balance_transactions.created_year" ORDER BY "stripe_balance_transactions.created_year" ASC,"stripe_balance_transactions.created_quarter" ASC LIMIT 50;
d
Thanks for the report! This looks like a bug with our default Stripe report. Can you please file an issue in https://gitlab.com/meltano/dashboard-stripe and ping me?
If you open the “`stripe_balance_transactions`” report builder, you should be able to put together a “Net Volume By Month” report manually as well. It also looks like one is included by default already 🙂