Yourworldmap-sigma | Stripe Developers | Page 1

fading beacon Sep 16, 2021, 9:14 AM

#

@torpid skiff You can certainly do that, query against charges and join with customers so you can split by address_country if you collect the customer address in your integration, or split by card_address_country in charges.

torpid skiff Sep 16, 2021, 9:19 AM

#

That's nice that you understand what I'm talking about.

#

But from my side, i don't know actually how to do that.

#

I just need to make a report for the past month and pass it to my accountant. But I do still not figure out how to do that.

fading beacon Sep 16, 2021, 9:22 AM

#

I can't help you write the SQL query directly I'm afraid!

torpid skiff Sep 16, 2021, 9:24 AM

#

And where I can search for help with this question?

fading beacon Sep 16, 2021, 9:26 AM

#

what kind of help are you looking for? Unfortunately we can't write the query for you, you'd need to write some queries to extra the data you're looking for and tweak things until you're happy with it!

torpid skiff Sep 16, 2021, 9:28 AM

#

I just need somehow make a report for monthly sales, in which all transactions are divided by country.

fading beacon Sep 16, 2021, 9:33 AM

#

you can experiment writing queries using the tables I mentioned above and looking at the schemas for where the concept of 'transaction country' is, as I mentioned, card_address_country on charges is a good place to start.

torpid skiff Sep 16, 2021, 9:35 AM

#

Okay i'll try to do that, thank you.

torpid skiff Sep 16, 2021, 12:05 PM

#

Mate, i have spend 2 hours to make it work

#Yourworldmap-sigma