Baby's first post!
I'm working to create a robust membership dashboard, and one of the first things I made was a widget that tracks how many unique constituent ID's are in each membership level. I'm getting the information I need, but analytics automatically sorts the levels alphabetically, but I want to reorder these by giving level (from lowest to highest). I also tried using the membership level rank, but it orders it as "1, 10, 11, 2, 3, etc." which gets me closer but I want the names of the levels and I'd still need to reorder manually.
Thanks!
Hi Lynette,
I want to clarify what you're looking for- you want a count of Membership IDs, broken out by Membership Level, and then sorted by giving level? Are you using Memberships as Giving Levels?
Each membership level is a giving level in that the level is dependent on the amount the person gives.
Ok, that makes sense. You'd want a count of Membership IDs, broken out my Membership Level, then sorted Highest to Lowest in terms of giving amount.Short answer is I'm not sure!Longer answer is that I'm wondering about using 'Membership Amount' as a lever to pull.
Could you use the average of the 'Amount'? Or the Max?If we don't have a precise lever to pull (some metric that says "this is the order of giving amounts"), then we'll have to get creative with finding another way to create such a lever. I'll keep thinking on this.
I tried using the amount but it makes everything look wacky. In a pivot table I can create a row with the membership rank and sort it by descending and that puts the levels in the order that I want, but when I try to make this any other kind of graph I can't get it to play nice.