After running a challenge, you can download and look at your challenge information. If you're a free user, this data will only be your personal data. However, if you're an Impact/Inspire Admin, Citizen Science, or Campus Admin, you'll be able to pull your challenge data in its entirety.
Here are the steps on how to pull a report:
Log into your Dashboard
Make sure you're logged in as an Impact Admin (if you're in the correct admin role, you'll see "view as member")
Click on "Reports" on the menu bar
Select your challenge(s) in the Challenge drop-down menu
Adjust the dates to make sure you encompass your entire challenge range
Click on "Generate Report" and wait for the system to generate
Then Click on "Download CSV" on the right side of the screen
That will pull a CSV of every piece of litter in your challenge.
To sort a list of participants, open the CSV in Excel (or any other spreadsheet software) and run a PivotTable. Here's how to do that:
Select all items in your spreadsheet. You can click on the triangle at the top left of the column headers to quickly select all
Click on the "Insert" menu in the menu bar and then click on the PivotTable icon
Click on "OK" on the popup contextual menu
From here, select "Litter" and move it to the "Values" box. Then select "Full Name" and drag it to the "Rows" Box.
Then double click on "Sum of Litter" in cell B3 to open the "Value Field Settings" popup menu. Click on "Count" in the "summarize value field by" section and click "OK"
Then to sort by largest to smallest litter numbers, right-click on any cell in the B column to open the contextual menu. Highlight Sort>Sort Largest to Smallest
After that your list should be complete!
There are many other ways to slice and dice your data. For example, you can sort by Join code, Display Name, or Tags. Simply move different datasets between the different values to figure out the best way to display the data for your needs. Here is an article that helps explain how to use PiviotTables in more detail.
If you have any questions or need any more help, please reach out to your Client Success Manager!