Hitachi Vantara Pentaho Community Wiki
Skip to end of metadata
Go to start of metadata

Summary Calculations

  • CountDistinctFunctionCounts the distinct occurrences of an certain value of an column. This functionality is similar to the SQL distinct() function.
  • GroupCountFunctionA report function that counts groups in a report. If a null-group name is given, all groups are counted.
  • ItemAvgFunctionA report function that calculates the average of one field (column) from the data source
  • ItemColumnQuotientExpressionA report function that calculates the quotient of two fields (columns) from the current row.
  • ItemCountFunctionA report function that counts items in a report.
  • ItemHideFunctionHides equal values in a group where only the first changed value is printed.
  • ItemMaxFunctionA report function that calculates the maximum value of one field (column) from the data source.
  • ItemMinFunctionA report function that calculates the minimum value of one field (column) from the data source
  • ItemPercentageFunctionCalculates the percentage value of a numeric field.
  • ItemSumFunctionA report function that calculates the sum of one field (column) from the data source.
  • TotalCalculationFunctionA report function that stores the result of a calculation for a group or the complete report.
  • TotalGroupCountFunctionA report function that counts the total of groups in a report.
  • TotalGroupSumFunctionA report function that calculates the sum of one field (column) from the data source.
  • TotalGroupSumQuotientFunctionA report function that calculates the quotient of two summed fields (columns) from the data source.
  • TotalGroupSumQuotientPercentFunctionA report function that calculates the quotient of two summed fields (columns) from the data source.
  • TotalItemCountFunctionA report function that counts the total number of items contained in groups in a report.
  • No labels