Atlassian Confluence

Extend Quizzes for Confluence with Table Filter and Charts Add-on

With Quizzes for Confluence you can create tests and quizzes to assess job candidates, evaluate the skills and knowledge of employees, set up training courses in Confluence. You can assign a quiz to participants (including people without a Confluence account) by sharing a quiz link via email or set up a page for self-enrollment to let users select and take quizzes at their pace.

Table Filter and Charts for Confluence provides filters, pivot tables, charts and graphs that you can use for basically any table in Confluence, including tables generated by Quizzes.

Banner

These capabilities can be a big help when working with tables of:

A quiz administrator can benefit by using the following features of Table Filter and Charts:

  • filters to easily find needed records in the report and hide report columns
  • exporting results to CSV and create custom reports in Excel
  • pivot tables to get ‘average’ and ‘total’ statistics of scores, statuses and results
  • graphs and charts to visualize the results data

Let’s learn more about Quizzes reports and see how they can be extended with Table Filter and Charts.

Quiz Reports

By default each quiz has two reports, Quiz Results and Quiz Questions. They can be used to:

  • view all quiz participants
  • track quiz completion and results
  • view answers of each participant
  • analyze what questions participants fail more often than others

Quiz administrators can also build Custom Quiz Results Reports and configure them based on their current needs. For example, you can create a report with:

Hint: To set up the results report of one particular quiz (e.g. to share it with participants), you can simply copy the report from a quiz administration page and paste it on another Confluence page.

Table Filter and Charts Macros

Table Filter and Charts works using three macros:

  • Table Filter – provides filters of different types
  • Pivot Table – summarizes table values
  • Chart from Table –  visualizes table data with dynamic graphs and charts

Table Filter and Charts macros

Here are some ideas for using Table Filter and Charts macros when you work with Quizzes.

3.Quiz Report

Sample Quiz Results Report

Table Filter

  • Dropdown Filter (for Status column) – to see participants who haven’t taken the quiz yet (select Not Started in the filter)
  • Free Text Filter (for a column with a single choice question) – to learn what participants answered the question wrong (type the correct answer option in the filter and revert it)
  • Number Filter (for Score column) – to browse participants who had a score within a given range (enter from and to values in the filter)
  • Date Filter (for Date Started column) – to view quiz submissions for a certain time period (enter from and to values in the filter)
  • Hide Columns Filter – to dynamically collapse and expand columns of the report

Pivot Table

  • Count by Result – to see how many participants have failed and passed the quiz
  • Average of Score – to get the average score for a quiz

Chart from Table

  • Pie Chart by Status – to view the breakdown of Completed, Not started, In Progress and Waiting for Review quiz submissions
  • Bar Chart by Question success rate – to see at a glance the questions with the lowest success rates (can be the most difficult or poorly written questions)

Below are step-by-step examples of combining Quizzes and Table Filter and Charts. You can adjust them to create your own combinations.

Filter Report with All Quizzes and All Participants

Report used: Quiz Results report with all quizzes and all participants

Filters used: 

  • Dropdown Filters for Quiz, Status, Results columns
  • Free text Filter for User column
  • Number Filter for Score column
  • Date Filter for Date Started column
  • Hide Columns Filter for the whole report 

Steps:

  1. Open the page with the report in the editor.
  2. Insert Table Filter macro and move Quiz Results Report macro inside Table Filter macro.
    4. TF+Quiz Results Report
  3. Save the page – you can set up the filters in the View mode.
  4. Add filters one by one by selecting columns you want to use for a filter and a filter type.
    5.Adding filters
  5. Save changes.
    6.Saving changes
  6. Now your report has the filtration panel.
    7.Global Report

Hint: Collapse the filtration panel when you don’t need it.

Summarize Report with All Quizzes of a Single Participant

Report used: Quiz Results report with all quizzes of a selected participant

Steps:

  1. Open the page with the report in the editor.
  2. Insert Pivot Table macro and move Quiz Results Report macro inside Pivot Table macro.
    8.Pivot Table+Quiz Results Report
  3. Save the page – you can manage the pivot table in the View mode.
  4. Select Count in Operation type, Status in Calculated column and Row labels.
    9.Pivot table settings
  5. Save changes.
  6. Your pivot table is ready.
    10.Pivot table

You can have a similar pivot table for Results column. Just change values in Calculated column and Row labels to Results.

Hint: You can hide the source table (the report itself) and/or the control panel to only view the pivot table. It can be useful when your pivot table is located on a dashboard.

Visualize Quiz Question Reports

Reports used: Quiz Question report on a quiz administration page

Chart used: Bar chart by Question

Steps:

  1. Open a quiz administration page in the editor.
  2. Insert Chart from Table macro above Quiz Questions Report macro and move Quiz Questions Report macro inside Pivot Table macro.
    11.Chart from Table + Quiz Results Report
  3. Save the page – you can manage graphs and charts in the View mode.
  4. Select Question in Label column and Success Rate in Values column.
  5. Choose Bar in Type.
  6. Set suitable height and width for the chart.
    12. Chart control panel
  7. Save changes.
  8. You will see a chart with questions and bars representing success rate (%).
    13. Bar Chart

Hints: 

  • Hide the chart control panel if you do not plan to often change types of graphs.
  • Sort Question report by Success Rate (click the ‘sort’ icon in the table header) to have chart updated and show bars from the lowest to highest rate and vice versa.

Combine Table Filter and Charts Macros to Empower Quiz Results Report

Reports used: Quiz Results report on a quiz administration page.

Macros used:

  • Table Filter: Dropdown Filters for Status, Results columns; Free text Filter for User column; Number Filter for Score column; Hide Columns Filter for the whole report
  • Pivot Table: Count by Result
  • Chart form Table: Pie chart by Result

Steps:

  1. Open a quiz administration page in the editor.
  2. Embed Quiz Results Report, Table Filter,  Pivot Table,  Chart from Table macros as shown below.14. Chart+Pivot+TF
  3. Save the page to continue in the View mode.
  4. Set up filters in the report (See the ‘Filter Report with All Quizzes and All Participants’ section).
  5. Generate a pivot table with Count by Result (See the ‘Summarize Report with All Quizzes of a Single Participant’ section).
  6. Configure a pie chart – just select Pie in Type – the chart will be built from the pivot table.
    15.Chart+pivot

Conclusion

Quiz administrators can use default Quiz reports as well as build custom reports suitable for their goals. Table Filter and Charts gives you powerful and easy-to-use tools to get the most out of Quizzes reports. Combining all 3 macros of Table Filter and Charts, you get filters, charts and pivot tables working together and dynamically updating as you change their settings.

Try Quizzes and Table Filter and Charts for free and have assessments, tests and courses right in your Confluence!

Recommended Articles