Creating a Computed Expression in a Chart
You can create computed expressions in charts to perform calculations on item data. This is particularly useful when you do not have permission or the ability to create a computed field in an item type that performs a similar calculation.
Example: Cost Summary of Active Projects
In a distribution chart, use aggregate functions to calculate a cost summary of active projects for each product.
For example, in the Edit Admin Chart window, the following aggregate expressions display in the Aggregation panel:
Summary of aggregate expressions:
• count() - displays the number of active projects for each product.
• max(“Product Health Value”) - displays the Health of each product by calculating the maximum value of the Product Health Value computed field in each active project.
• sum(“Total estimated Budget”) - displays the Total Estimated Cost of a product by calculating the sum of the Total Estimated Budget field in each active project.
• sum(“Total Actual Budget”) - displays the Total Actual Cost of a product by calculating the sum of the Total Actual Budget field in each active project.
• sum(“Total estimated Budget”)-sum(“Total Actual Budget”) - displays the Cost Variance for a product by calculating the difference between the Total Estimated Budget field and Total Actual Budget field in each active project.
The generated chart displays the following data:
