Last modified by: Inclusion Support -

Aggregate

Aggregrate.png

  • Aggregate function allows you to display totals, averages, counts, minimums, maximums and more for your data columns.

    • For a report which includes groupings, an aggregate will appear at each grouping level.

  • The required fields when creating adding aggregate values are as follows:

    • Data Column: Select the column from the drop down menu.

    • Aggregate Function: Select the function you wish to use.

      // <![CDATA[ function toggle02() { var ele = document.getElementById("aggregate"); var text = document.getElementById("disaggregate"); if(ele.style.display == "block") { ele.style.display = "none"; text.innerHTML = "[see list]"; } else { ele.style.display = "block"; text.innerHTML = "[hide list]"; } } // ]]> [see list]
      Sum
      Average
      Standard Deviation
      Count
      Distinct Count
      Minimum
      Maximum
    • Click Add.

  • Note that multiple functions can be added to a single data column.

Print Friendly and PDF

Head back to the Inclusion Support Home Page.

Contact the Includables!

1 (866) 884-3451
includables@inclusionsystem.ca