The 'Ideas by' tab in the statistics area allows you to view the ideas that have been submitted, and breaks this information down by funnel phase, milestone stage, theme, idea status or tag.
In this article:
Using the 'Ideas by' tab
Exporting the data
Using the 'Ideas by' tab
The 'Ideas by' tab is in the statistics area of Community Analytics. To find it, click on Analytics in the Admin menu, then click on the Statistics tab.
Use the dropdown box at the top of the page to select how you would like to view the ideas. When you select the information that you'd like to see, the page will refresh and you will see a graph or chart showing the ideas submitted.
The table below explains what you will see for each 'Ideas by' option:
This option shows the number of ideas that have reached different stages of a funnel challenge that you select.
This will show how many ideas have been posted into different themes within a challenge. To learn more about themes, our guide to the challenge details area has a section on themes.
This option shows which ideas have reached the different stages of milestone challenge that you select.
Selecting the Ideas by status tab will show you how many ideas have been given specific idea statuses by moderators.
This chart shows the number of times a user has given a specific tag to an idea. The tags are arranged in descending order, starting from the left ie the tag that has been applied to the most ideas will be the leftmost bar on the graph, the next bar is the second-most comment tag, and so on.
When you click to view the ideas by status or tag, the graph will show information for all challenges by default. To see information for one specific challenge, use the Select a challenge drop-down menu to choose a challenge. This will update the information on the page.
Below the Ideas by chart, there is a table that shows a list of the ideas that the graph represents. You can click on the chart to change the ideas shown in the table, for example, if you are looking at a chart of ideas by funnel stage, if you click on the name of a phase, the table of ideas below the chart will show only the ideas in that phase.
Exporting data from the 'Ideas by' page
If you would like to view any of the information on this page when you are offline, you can export both the graph and the table of ideas underneath it.
Exporting the graph
You can export the graph in a variety of formats, depending on how you would like to use the file. If you would like an image of the graph, you can download it in the following file formats: .png, .jpg, .pdf document or SVG (a vector image format, for editing in programs such as the Adobe Creative Suite). If you would like the data used to draw the graph, you can download this as a .csv file.
To export the graph:
1. Select the challenge and the date range that you would like the graph to show.
2. Click the export icon at the top right of the graph, this will open up the options that you can choose from when exporting the graph.
3. Click on the format that you'd like to download the file.
If you click on the menu icon above the graph, you will see that you can also choose to print the graph without downloading an image or document file. When you click Print chart a print window will open in your browser, allowing you to select your print options.
Exporting the list of ideas
If you would like to export a list of ideas shown underneath the graph, scroll to the bottom of the page and click the Export Data button, underneath the table.
When you click the button, you will download a .csv file, which can be opened in Excel, Numbers, or a similar spreadsheet application.
The downloaded file has a list of all of the ideas that are in the on-screen table, as well as their associated comments, and the number of votes that they received.
As you can see from the image above, the column 'Type' indicates whether an item is an idea or a comment, and an idea is listed with its comments directly under it. In this example, The idea 'Masterful Manufacture' has four comments, which are shown in the four rows directly underneath the idea. The idea 'Know your customer' has one comment, which you can see in the row underneath the idea.