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

Add-ons
Platform

Server, Data Center

Macros
Suppliers

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:

    AssigneeTime 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.
    Set the Data 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".

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

  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

AssigneeTime Logged


Ziana


10


Justin


5


Hashimi


8


Muhtadi


1


Dave


9

Generated Pie Chart