angelachen103-sigma-sql | Stripe Developers | Page 1

river pilot Apr 4, 2022, 11:04 PM

#

sinful drift Apr 4, 2022, 11:06 PM

#

I'm trying to get a breakdown of revenue by product and tierID-- tried joining invoices, subscriptions, prices, and products, but I get an over-inflated number. trying to see if I can use balance_transactions table instead but not sure how to join...any help would be appreciated!

river pilot Apr 4, 2022, 11:10 PM

#

I can try and give some pointers/sugestions, but if you need more specific SQL help this isn't the best place

#

Are you making sure to check that the invoices you're going through have a paid status?

sinful drift Apr 4, 2022, 11:12 PM

#

thanks for much karbi--yes I did, filtered by using WHERE invoice.status= 'paid'

river pilot Apr 4, 2022, 11:12 PM

#

What number are you actually comparing to?

sinful drift Apr 4, 2022, 11:13 PM

#

comparing to total monthly revenue for Feb from balanced_transactions table

#

it's the monthly summary and balance template in Stripe

#

also, do you know where would be the best place to get more specific SQL help? for future reference

river pilot Apr 4, 2022, 11:18 PM

#

You can try asking support (https://support.stripe.com/contact), but other than that there isn't really a good place to ask

sinful drift Apr 4, 2022, 11:19 PM

#

I see, okay

#angelachen103-sigma-sql