howdykolache / admin

0 stars 0 forks source link

Data query request #83

Open ezl opened 2 years ago

ezl commented 2 years ago

@niall-p-gray can you pull some data from airtable for me? I'd like to have a table of

For each week from Jun-End of Sep: For each clients (who has non zero orders in that range) The number of kolaches they ordered for that week.

So, the output should be a csv or spreadsheet table where the columns are:

Client name, first week in jun, 2nd week in jun, ... , last week in sep

and each row contains something like:

groudnswell (madison), 342, 345,6243, ...