Spotfire Ideas Portal
See attached.
Allow expressions in search to mark rows. At least basic boolean operators. This would make it more efficient to mark relevant data for insights.
Examples:
-"Hourly Rate > 40" or "Hourly Rate greater than 40" would mark rows where values in "Hourly Rate" column are greater than 40, allowing me to quickly/easily see highest paid employees
-"Sales after January 10th" would mark dates after Jan 10th
-"Top 10 Salespeople by Revenue" would do a "top 10" Sum(Revenue) OVER Salespeople
-"Outliers in Sales" would mark outliers in a Sales column
-"Format Temperature #.##" would format Temperature column as a Real with 2 sig figs
-"Filter out/to Northwest" would filter the page to data to exclude/include "Northwest" in a Region column (not necessarily an expression)
-"Moving average of stock price" would either add a moving average to existing combination chart, or suggest creating a combination chart with stock price + moving average over time (not necessarily an expression)
No problem. I've added examples and included one where "OVER" function may be useful. Thanks.
Thanks Neil, that makes sense. Would you please update the description to reflect the more advanced use cases you describe in your comment?
...not "Limit By"... I meant "Limit Data through expression" as in the Visualization Properties > Data menu
Hi Niklas,
I'm looking for a little more like what is possible through "Limit By" expressions. I suppose the result of the expression would need to be a boolean for each applicable row.
For example, in my attached screenshot previously, "Hourly Rate > $40" or "Hourly Rate greater than 40" would mark all rows where values in the "Hourly Rate" column is greater than $40. This would help me when I'm trying to find a particular insight quickly, like highest paid employees.
Another example might be "Sales after January 10th"
I'm not sure if full expression capabilities are needed (like OVER and NEST)... I can't think of examples where that'd be useful currently. Also, a user may end up using the sentence "Hourly Rate over 40" instead of "greater than" which could cause issues.
Neil - many thanks for contributing your idea. The Spotfire Find actually allows you to search using AND/OR/NOT, wildcards etc.
https://docs.tibco.com/pub/sfire-analyst/10.0.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/index.htm#t=search%2Fsearch_searching_in_tibco_spotfire.htm
Is this what you need?