Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Create a bar or line graph of spending by month/quarter

Topic Labels: Formulas
155 0
Showing results for 
Search instead for 
Did you mean: 

Hi - I’m trying to track spending for various entities by date, to allow the creation of a chart of spending by month.

Our database has a list of Advertisers. And each of those Advertisers is linked to many Advertisements. Each Advertisement has already been assigned a dollar value and each record also has a date.

How would I create a chart for each advertiser for what they’ve spent in a given date range — ideally by month and/or quarter?

I’ve been able to create a cumulative sum of ad spending per Advertiser, but I’m stumped on breaking it down by month.

Any help much appreciated! Thanks!

0 Replies 0