Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Custom Expressions
Created by Guest
Created on Feb 6, 2016

Location invariant value formats in expressions


*Goal:*
As an author, I need to control the exact format of my data so that I can properly configure the rest of my analysis. Regional language and cultural settings are client dependent and therefore dates and decimal separators change depending on my client computer/browser configuration.

I need an option to have the dates and decimal separators NOT be dependent on local cultural settings, but be globally defined and static within Spotfire

*Details:*
For example, if I need to use a date column as an input to an expression or script I might need to ensure that the date is in the format MM/DD/YYYY and cannot change.

The forum post mentioned above was due to an expression expecting a period separator with an expression like: when [My Binned Column Name]="x _ 0.00"
But that was failing when a comma separator was used due to local client setting since the binned column was named "x _ 0,00"

There are many other examples where this type of control would be extremely valuable for authors.

Applicable to local installed client and Web Player.

  • Attach files
  • Guest
    Reply
    |
    Feb 9, 2024

    This seems to be similar to:
    SPF-I-288

    SPF-I-714

    TS-I-8988

    SPF-I-26

    TS-I-7379 ?

    TS-I-6172 ?

  • Guest
    Reply
    |
    Aug 17, 2016

    Have it depend on the Spotfire server time settings. so everything is in line and everyone receives the same outputs.

    also, week numbers can differ now when using the client  with different locale.

44 MERGED

Lock date formatting, culture settings, of an analysis.

Merged
I would like to lock (set explicitly) the date formatting, or value formatting at all, within an analysis opened in the Web Player. Currently the different language/culture settings in the web browsers will make it impossible for them to work with...
over 8 years ago in Spotfire / Custom Expressions 0 Future Consideration
15 MERGED

Set start of week in calculations independent of regional settings

Merged
On using date hierarchies, is Spotfire's definition of a WEEK's start and end days (e.g., Monday to Sunday) entirely dependent on the regional settings of the computer being used? We have a bar chart that presents the weekly volume of IT service r...
over 8 years ago in Spotfire / Custom Expressions 0 Future Consideration
7 MERGED

enforce numerical representation of the decimal

Merged
Our international organisation has different language settings in local machines, and in the servers. This leads to confusion with the use of the decimal point or comma. Can in the presentation of the report a setting be added to enforce the decim...
over 1 year ago in Spotfire / Visualization 2 Future Consideration