Hello everyone,
I am quite new to Analytics and it would be very helpful if you can help with my question.
I try to look at how many donations fall into a range of amount, e.g.
>£1,000
£500-1000
£100-500
£10-100
<£10
I couldn't find the button to show that in my widget - is there anyway to do so?
Many thanks!
Cherie
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 RobichauxThe 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 wiseI 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?
Hi Amanda,
Try changing Nathanael's formula from [# of unique Contribution ID] to [Total Amount].
Thank you so much Laurel! I just have time to revisit it now and your answer is very helpful. I wonder if we can change the giving ranges ourselves, or it is a fixed preset feature?
These are configurable: Division Range Setup (tessitura.com)