Spotfire Ideas Portal
Add a new idea Subscribe
Status Future Consideration
Product Spotfire
Categories Custom Expressions
Created by Guest
Created on Feb 8, 2023

RELATED IDEAS

Add ability to reference already created values that are defined in a custom expression

Being able to reference already created values that are defined in a custom expression. For example you might use the below custom expression code. I will create an average voltage and standard deviation voltage variables for my typical process. I will then use them to calculate a CPK.

LET TypAvgVoltage = Avg( If([Process]="Typ", [Reference Voltage])) OVER All(),

LET TypStdDevVoltage = StdDev( If([Process]="Typ",[Reference Voltage])) OVER All(),

LET SpecUpperLimit = TypAvgVoltage + 6*TypStdDevVoltage,

(StatisticalUpperLimit-Avg([Reference Voltage])) / 3*StdDev([Reference Voltage]) as [CPKU]

  • Attach files
      Drop here to upload
    This document (including, without limitation, any product roadmap or statement of direction data) illustrates the planned testing, release and availability dates for Spotfire products and services. It is for informational purposes only and its contents are subject to change without notice. Planning to implement - generally 6-12 months out. Likely to Implement - generally means 12-18 months out. Copyright © 2014-2023 Cloud Software Group, Inc. All Rights Reserved. Cloud Software Group, Inc. ("Company") follows the EU Standard Contractual Clauses as per the Company's Data Processing Agreement. Terms of Use | Privacy Policy | Trademarks | Patents | Contact Us