Generating Charts from a Dynamic Table (Using the Reporting Add-on)

Let's create a simple table populated with data and then generate simple charts using that data.

Ingredients

Guide

1. Let's start by creating a dynamic table which allows a user to enter data.
   Create a Table Data macro with the name "tableLog".

2. Inside that Table Data macro, create a table with two columns and two rows, like this:

   Assignee	Time Logged
   Assignee	Time Logged

3. Now create a Text Data macro under the "Assignee" column and a Number Data macro under the "Time Logged" column.

4. For the Text Data macro, set the Field Name parameter to "developer", type to "line", and Content Type to "wiki".

5. For the Number Data macro, set the Field Name parameter to "hours" and tick Allow decimal values.
   You should now have something that looks like this:
   
   

6. Now for the fun part! Let's create a pie chart with numbers provided by the dynamic table we created above.
   Create a Chart macro, and set the Content Orientation parameter to "vertical".

7. Create a Report Table macro within the Chart macro.

8. Within that Report Table macro, create a Local Reporter macro and set the Key to "data:tableLog".

9. Still within the Report Table macro, create a Report Column macro and set the Title to "colDeveloper".

   • Within the colDeveloper Report Column macro, create a Report Info macro and set the Key to "data:developer".

10. Now back within the Report Table macro, create another Report Column macro and set the Title to "colHours".

    • Within the colHours Report Column macro, create another Report Info macro and set the Key to "data:hours".

11. You should now have something that looks like this:
    
    

    

    
    Click Save.
    

12. Now, click Edit Contents and fill in some data to see the results!

Notes

Try playing around with the Chart macro parameters to change the pie chart into a bar chart or a time series chart.

Result

User-Provided Data

Generated Pie Chart