A range of contribution amount and the count of contribution

Hi Cherie,

Are you also looking at a specific time frame? I have a widget where I was looking at people who increased their donation amount over $250 in the last three years. I have formulas for each year that are filtered by amount and year:

This is saying give me the total amount of contributions, filtered by the fiscal year. You can filter the second item in the formula by clicking on it. To filter the first item in your forumula (in this case the amount), click the funnel icon in the formula:

So you would have a series of formulas that say:

([Total Amount], [Fiscal Year]) (or whatever time frame you want to look at).

Each formula would then get filtered by amount. You can rename the formulas to make it clear what you are looking at. 

I hope that helps. You can also add dashboard or widget-level filters if you only want to look at specific funds, etc.

Anne Robichaux
The Historic New Orleans Collection

Thank you so much for your help Anne Your formula can help as that's what I will be looking for next!

What I am trying to do here is e.g. for donation amount under £10, there are 4 donations, under £20 and >= £10 is 34, etc. I tried to use the filter for the amount, but that didn't give me what I want...

Hi Cherie, can you please show me your formula? 

Anne

I think you could use something like the following:

( [# of unique Contribution ID] , [Amount1] )

This would ask "how many gifts had an amount between $0 and $100" (then sliced by the rows you have in place).

You would then adjust that formula as needed to segment out your gift levels.

Hi, in my Analytics we have 2 fields I use for this

Last FY Giving Range to get the information needed for our Annual Report

On the Dashboard filter I limit my criteria to what I want Campaign wise
I also run a second one by sort name and include constituent id so I can sort alpha and then export with each record having their range

Does anyone happen to have the formula or tips for trying to do this by gift, not by donor total? For example, I want to see the total number of gifts made in a range, the total number of donors AND the total aggregate amount of those gifts. I've managed to get the number of gifts and number of donors, but cannot get the total amount of gifts. Every time I think I get it, I find an error and the math is not math-ing. 

Without seeing how your widget is set up, can you add another value to a pivot table with contribution amount?

Without seeing how your widget is set up, can you add another value to a pivot table with contribution amount?