Using a custom formula in an analysis

This topic describes an example that shows how to use a formula in an analysis.

Before you begin

Based on what your requirements are, create the formula using the Formula editor. All the formulas are listed in the Formulas page (Administration > Formulas).

Example: Use a custom formula in a Memory Analysis

This procedure illustrates how you can use a custom formula, using metrics from an entity and its child entity, and calculate the Memory Over-commit Ratio.

This example uses the formula in Sample 3 of the Sample formulas topic.

  1. Navigate to Workspace > All Domains > <domain name>.
  2. Expand the domain and click Works to access the domain's Works folder.
  3. Click Add and select Add analysis from the menu.
  4. In the Analysis wizard, select the Skip wizard and continue using the analysis editor check box in the Welcome step. For more information, see Creating-an-analysis.
  5. In the General tab, in the Name box, type Memory Analysis.
  6. For the Entity filter, choose Use a custom entity filter.
  7. In the Select entity filter step, select All entities in container domain.
  8. For Type, select Performance vs Time analysis.
  9. In the Template group step, select Cutsom.
  10. In the Template step, select All Collected Metrics.
  11. In the Time resolution step, select Day.
  12. In the Entity, metric and subresource filters tab, for the System type filter step, click Edit.
    1. From the Available items list, select Virtual Cluster - VMware and click >> to move the selection in the Selected items list.
    2. Click Apply. The System time filter now shows Virtual Cluster - VMware.
  13. In the Metric/Formula filter step, click Edit.
    1. From the Available items list, expand Formulas and select [F_10681_C] Memory Overcommit Ratio.
      This is the formula used in Sample 3.
    2. Click >> to move the selected formula to the Selected items list. The selection appears in the Selected items list.
    3. Click Apply. The Metric/Formula now shows [F_10681_C] Memory Overcommit Ratio.
  14. Click Save. The analysis is saved with the name Memory Analysis.
  15. In the Memory Analysis page, click Run now to run the analysis.
  16. Review the chart that shows the Memory Overcommit Ratio that is calculated using the [F_10681_C] Memory Overcommit Ratio formula that you selected in step 13.a, while creating the analysis.
    formula_in_analysis.png

Related topics

Viewing-and-adding-formulas

Sample-formulas

Manually-creating-an-analysis