How do I modify the field functions?

This article explains how to edit the field functions in an EPM Live Analytics report.   The steps are applicable whether you are building a new report or updating an existing report.

Functions allow you to perform calculations on the data and can be chosen from the drop down menu based on the data type of the selected Field.

1. Navigate to the EPM LiveAnalytics Reports Page

  1. On the navigation menu, select Reports to open the Business Intelligence Center.
  2. Click EPM Live Analytics.

2. Open Report Designer

  1. If you are on the Reports landing page, hover over a report to show the Print and Edit icon buttons.  Click the Edit icon.  -- Or --
  2. If you are already viewing a report, click the Open in Designer icon.

3. Available Numeric Functions

  • . . . No function used
  • Average:Average the values in a column
  • Count: Counts the number of values in a column
  • Count Distinct: Counts the number of distinct values in a column
  • Maximum: Takes Maximum value of a field
  • Minimum: Takes Minimum value of a field
  • Sum: Sums the values in a column
  • Sum Distinct: Sums the rows with distinct values in a column
  • Group: Groups field values together for aggregating

4. Available Date/Time Functions

  • . . . No function used
  • Average:Average the values in a column
  • Count: Counts the number of values in a column
  • Count Distinct: Counts the number of distinct values in a column
  • Maximum: Takes Maximum value of a field
  • Minimum: Takes Minimum value of a field
  • Sum: Sums the values in a column
  • Sum Distinct: Sums the rows with distinct values in a column
  • Group(Day): 23; day of month
  • Group(Month): 01 (signifying January)
  • Group(Year): 2012
  • Group(Month Name): July
  • Group(Date): 7/4/2012
  • Group(Day of Week): Sun or Mon
  • Group(Year & Month): 2012 -07
  • Group(Year & MN): 2012 - Jul
  • Group(Week): Jul 01 – Jul 07 (Sunday to Saturday of Week)
  • Group(Year & Quarter): 2012–Q3
  • Days Old: 342 (Number of Days from Today’s Date)
  • Average(Days Old): 650 (Averages the Number of Days from Today's Date)
  • Sum(Days Old): 782 (Sums the Number of Days from Today's Date)
  • Group: Groups field values together for aggregating

5. Available Text Functions

  • . . . No function used
  • Count: Counts the number of values in a column
  • Count Distinct: Counts the number of distinct values in a column
  • Maximum: Takes Maximum value of a field
  • Minimum: Takes Minimum value of a field
  • Group: Groups field values together for aggregating

Comments

0 comments

Please sign in to leave a comment.