I am attempting to riff on the example widget for Bucketing by Gift Size, as presented in Take Your Tessitura Analytics Skills to the Next Level and I'm getting stuck due to an error I don't fully understand.
When I go to build out the filtered value formula using Contribution Count and Amount (just like at 13:10 in the video), I'm getting an error message which I think is telling me that the same measure is used more than once. My Contribution Amount field is coming up slightly differently than in his example, which makes me wonder if something got patched or otherwise changed.
Has anyone else encountered this and found a workaround? My end goal would be to have a count of donors giving $XX and up in a given year.
I could be wrong, but I think the issue is that your formula uses more than one VALUES (measures). After the comma, you need a FIELD (dimension), not another Value (measure).
I wish the Analytics directions/webinars did a better job distinguishing between VALUES and FIELDS. The concepts are there, but not clearly pointed out.
The Contribution Cube only has the following VALUES available: Amount, Balance Amount, Contribution Count, and Received Amount.
Your formula uses two VALUES. You are using "Amount" (Total Amount) and "Contribution Count."
I am assuming you are attempting to use the following syntax:
Maybe try:
( SUM ( [CONTRIBUTION COUNT], [FUND] ) )
Duplicate it and change Contribution Count to Amount.
( SUM ( [AMOUNT], [FUND] ) )
Oops, I now see what you were attempting to do. My assumptions were not correct.
Here is a screenshot from the Webinar.
Your formula has "Total Amount" instead of "Amount." Maybe that is the issue?
That's want I've been wondering about. When I click Contribution Values>Amount it comes up as "Total Amount". That's some of what had me wondering if I'm seeing the results of a patch or something.
Kate, I am getting the same issue as you. When you add "Amount" it shows "Total Amount". Either something has changed or we are missing some concept/step.
I finally figured it out. You have to first start with SUM([Amount]) as the Values part of the Bar Chart.
You then can a the comma and right parentheses to the left of "[Amount]"
Add the "[Contribution Count]" part of the formula.
Finally, add the left most parentheses.
You can then follow along with the example in the webinar.
Note that in the webinar they changed the design of the Bar Chart to Stacked to get the final result seen.
That totally works. It hadn't even occurred to me that the order in which the elements were added would matter. Thank you!
Hi Kate and Neil,
I'm not sure if this is helpful but I came across this kooky Analytics nomenclature a little while ago. [Total Amount] = SUM(Amount)
When you build a value field in the widget value editor eg: "amount" it will wrap it in the default function SUM and you get SUM(Amount)
However when you Pencil into the Edit Formula window, and select a data type from the Data Browser Analytics will write the entire formula in square brackets for you like [Total Amount] for the default SUM function. Total amount is actually short hand for SUM(Amount) and means the same thing. It does the same for Average, Max etc.
If you just want to get your simple data browser elements back so you can write your own functions the way to get around it is
Thanks for the information Heath! All of these small details help.
Indeed! All tips welcome.
My pleasure. Can save a lot of frustration