The 'FirstValidBefore' function is not visible inside the function list in TIBCO Spotfire Analyst
book
Article ID: KB0076453
calendar_today
Updated On:
Products
Versions
Spotfire Analyst
7.11.x and above
Description
The 'FirstValidBefore' function is not visible inside the function list of the calculated column/Custom expression window but if you use it by manually typing it then it works fine.
Issue/Introduction
The 'FirstValidBefore' function is not visible inside the function list inside Spotfire client.
Environment
All Supported OS
Resolution
To avoid any older analysis file(s) from breaking or getting invalid by renaming of function, we kept 'FirstValidBefore' hidden and don't promote it in the user interface(UI). Below is the reference image which actually explains the working method of 'LastValidBefore' function: