To simplify the code using SQL Queries, it would be easy to use this syntax :
"with my_table (C1) as (select column1 from table_dept) select C1 from my_table"
Database : SQLServer
"Type to Search field" be set via API/script for list box property controls
Can the "Type to Serch field" be set via API/script? e.g. Document.Properties["control1"].Search = 'ABC OR GHI'
I have a List Box Property control with unique values in a column. Is it possible to get a filter/filterering scheme to update the pro...
over 9 years ago
in Spotfire / API
0
Future Consideration
This is useful for creating single selection filters. We have a use case for users being able to move through values in a filter ONE AT A TIME. The list box (single selection) property control achieves this but falls short because the selectable v...
over 9 years ago
in Spotfire / Filters
0
Future Consideration
Stacked bars labels displayed, no matter the importance of the data value
When I am using combination charts (x = time, y = count of validation), I use stacked bars to show for example the proportion of male and female who validated, per time period. When there is not so much validations compared to the other months (an...
Enhance Scripting Default Options to Show Dialog box when Application is Not Responding
Problem: (version 7.6) When a report has a longer running ironpython, the Spotfire application goes into a windows (Not Responding) state. Windows then displays a dialog box prompting the user to Close the Application or Wait for the Program to re...
In scatter plot line connections it's sometimes very hard to identify where the line connection starts and ends. Start and end caps or markers would be a great enhancement for the line connection. Options should be size, shape and color.
When filtering with != or <>, do not remove null/empty values unless it was specified.
When the condition for != or <> is filtered on, it should not filter out null/empty values unless it was specified in the condition. For example, if there is a field called "Number" with a list of numbers 1,2,3,4,5,6,,7,8 (null between 6 and...
almost 2 years ago
in Spotfire / Filters
1
Future Consideration
up/down key to change column in column selector PRIVATE
It is possible to change column by pressing up/down key after activated column selector in spotfire 6.5, and lots of customers(Toshiba) got used to it and heavily relied on it. Unfortunately this behavior changed to opening column select window af...
One of our users made the following suggestion:
It would be fantastic to be able to colour lines based on value - i.e. the line actually changes colour as the y value varies, or colouring is more versatile on combination charts - for example sep...
Data wrangling function to merge multiple dataframes to fill and replace
Often, multiple sources of data have different level of 'complete cases' - dataset #1 may have 60% filled entries, while dataset #2 may have the remaining 20% that are missing from #1 (both datasets may have all or some columns matching). Currentl...