JungleDocs | Matrix function

In JungleDocs you can use the Matrix function for statistical data transformations. In this tutorial you will learn how to do this.

This function achieves statistical data transformations using data from grouped lists.

Command syntax forms are:

  • Matrix(listName; viewName; formula)
  • Matrix(listName; viewName)
  • Matrix(items; formula)
  • Matrix(items)
    • listName – list name.
    • viewName – view name.
    • formula – optional parameter. Formula will do some statistical data transformation with grouped list items. You can access grouped list items using parameter $Items. By default, formula is set to "Count($Items)". Count will return number of items.
    • items – you can specify any formula that will return a grouped list.
  1. For example, if you have a grouped list, enter a command in Excel template cell: =Repeater(Matrix("Tasks";"Histogram")).

  2. And your result will be a transformed table:

This command also supports 2 level grouping. Matrix rows will come from the first level of grouping and matrix columns will come from the second level of grouping. Cells will be the formula’s result.

  1. For example, we have data like this:

  2. We can use Matrix function to get a result like this:

    Sum function here will calculate group items by total field.
    This Excel data also can be used in Word charts.

Still need help? Contact Us Contact Us