Spotfire shows all data on a visualization unless it is filtered or limited in some way. In the screenshot below, I would like to remove the period of time at the start of the time period where production is zero.
I will use the Limit with Expression feature. However, when working with dates in data limiting, an extra function is required to tell Spotfire the value is a date. See the steps below.
-
Right click on the visualization and select Properties
-
Go to the Data menu
-
Scroll down until you find Limit with Expression
-
Click the Edit button to launch the Custom Expression dialog
-
Enter this expression: [ProductionDate]>Date(2000,1,1)
-
Note that the format is year, month, day
Entering [ProductionDate]>= 1/1/2000 generates an error.
Entering [ProductionDate]>=’1/1/2000’ generates an error.
Entering [ProductionDate]>Date(2000,1,1) is the correct syntax.
The errors are created because the expression does not understand that 1/1/2004 is a date. Enclosing the date in single quotes converts it to a string, which is incorrect. You must enclose the date in the Date function to specify the value is a date.