nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

📊 🏆 How to analyse points distribution in Excel/Google Sheets

Shauna

Happy Wednesday, friends! 🤓

When reviewing and analyzing points distribution, one of the things I like to do is take an export of users, and use excel/google sheets to tell me how many users are in each rank so I can figure out if the current structure makes sense (or if a proposed structure would make more sense!

Once I've got an export (read more here: https://success.vanillaforums.com/kb/articles/594-export-csv-files-from-api-calls -- let me know if a quick video of this would be helpful to you!), I use a COUNTIF function in excel/google sheets to figure out the # of users within each range and then I can play with that data from there!

Find more posts tagged with

Hey there! Want to contribute to this conversation?

You are currently in a limited view of the community, but there's so much more to discover! Need some support? Have a question to ask? Want to open a ticket? Please sign in to the community to participate!

Quick Links

Upcoming Events

AI Study Group for Customer Marketers
Join our AI Study Group for Customer Marketers. At each session we'll discuss what group members are experimenting with and learning, how we're using AI in our Customer Marketing efforts, and help one another problem solve. The group meets monthly, and is open to any community professionals interested in the topic of AI.…
Agentic Advocacy: Building an AI-Powered Community
What does an AI-powered community look like in practice? Mary Green of Infor will share how her team is using AI and Higher Logic Vanilla to improve three critical parts of the member experience: Routing unanswered questions to the right experts Creating onboarding experiences that community teams can easily update…