Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

Showing 146 of 4418

DateTimeNow Function in Limit Data Using Expression when in-database connection to SQL server is used

DateTimeNow Function in Limit Data Using Expression when in-database connection to SQL server is used is not available when Keep data external option is selected in connector. This limits the usage of Spotfire.
over 7 years ago in Spotfire / Custom Expressions 0 Future Consideration

Add support for quick calculations to Count/Unique e.g. cumulative sum based on count, difference based on counts

If you are working with a String column e.g. Product Name and you are looking at a unique count of product name by time, you can easily see how many unique products were sold e.g. per month. However, if you want to look at the cumulative unique pr...
over 7 years ago in Spotfire / Custom Expressions 0 Future Consideration

Way to calculate number of working week day

We're looking for a simple way to calculate the number of working weekdays. In Spotfire, there is no simple function, but in Tableau, there is a "Weekday"DateDiff("weekday",[ORDER DATE],[DELIVERY DATE])In Spotfire, the closest I got is this refere...
almost 8 years ago in Spotfire / Custom Expressions 3 Future Consideration

Lastperiods() with negative period numbers

Hi, The lastperiods function can only accept positive first parameter (which indicates the number of periods to include in the calc (as opposed to the previousperiod function which can take negative arguments). if you tried to use this function in...
almost 8 years ago in Spotfire / Custom Expressions 1 Future Consideration

Issue in getting the total count across the points

Hi, We are trying to get the total count of the failures across the map grids on map chart. Count of the failures in grids is achievable but inorder to compute the percentage of failures , the total count is required. There is no way to compute th...
about 8 years ago in Spotfire / Custom Expressions 1 Future Consideration

Show available functions for an In-Database Connection to SAP HANA

Functions like Case, If, All, AllPrevious Over etc. all work in Spotfire for in-database connection to SAP HANA. But they are not shown in the list of functions available. Our users need an easy to use interface without getting into details of wha...
about 8 years ago in Spotfire / Custom Expressions 2 Future Consideration

Refer to Marked items in a custom expression

The should be a way to refer to marked items in a custom expression. for example: sum(if([field1] in marking, 1, 0)) as [var1], sum(if([field1] not in marking, 1, 0)) as [var2] where marking is selected in a different visualization. I know that I ...
about 8 years ago in Spotfire / Custom Expressions 0 Future Consideration

Empty values changed to zero in cross table should be used in over calculation

In version 7.7 it is possible to change empty "---" values to 0 or some other value. When using over statement in cross table this values are not taken into account in calculation. For example, you would like to calculate the difference in sales b...
about 8 years ago in Spotfire / Custom Expressions / Visualization 0 Future Consideration

Remove function overwrite in calculated columns and custom expressions

Currently if you type in an expression for a calculated column or a custom expression and then go back to the beginning of an expression and type another function, the original function gets overwritten. This is very annoying. I would like this fe...
about 8 years ago in Spotfire / Custom Expressions 0 Future Consideration

Multiple expression columns in property controls.

While it is possible to plug an expression into a plot axis with a document property, often it is necessary to plug that calculation into two visualizations. The difficulty is that two (or more) expressions are required because of the visualizatio...
about 8 years ago in Spotfire / Custom Expressions 2 Future Consideration
This document (including, without limitation, any product roadmap or statement of direction data) illustrates the planned testing, release and availability dates for Spotfire products and services. It is for informational purposes only and its contents are subject to change without notice. Planning to implement - generally 6-12 months out. Likely to Implement - generally means 12-18 months out. Copyright © 2014-2023 Cloud Software Group, Inc. All Rights Reserved. Cloud Software Group, Inc. ("Company") follows the EU Standard Contractual Clauses as per the Company's Data Processing Agreement. Terms of Use | Privacy Policy | Trademarks | Patents | Contact Us