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] ) )