Product: TIBCO Spotfire®
How to find the difference between two selected minimum and maximum values.
This is an example of selecting a two date value and finding the affiliated integer values and then taking the two integer values and finding the difference between them.
Create a text area to be able to select a minimum date and a maximum date, setting a document property. You also need to find the max and min values for each date. The two expressions used are:
MinValue: Min([Weight]) over ([Mfg Date])
MaxValue: Max([Weight]) over ([Mfg Date])
Then create a column to only show the value per the dates selected:
SelectedMin: If(DocumentProperty("MinDate")=[Mfg Date],[MinValue])
SelectedMax: If(DocumentProperty("MaxDate")=[Mfg Date],[MaxValue])
Create a column to show the difference between the two selected dates:
Diff: Max([SelectedMax]) - Min([SelectedMin])
Comments
0 comments
Article is closed for comments.