Skip to Main Content
Spotfire Ideas Portal

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
      Drop here to upload
    • 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.

    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...
    about 9 years ago in Spotfire / Custom Expressions 0 Future Consideration
    15 MERGED

    Set start of week in calculations independent of regional settings

    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...
    about 9 years ago in Spotfire / Custom Expressions 0 Future Consideration
    7 MERGED

    enforce numerical representation of the decimal

    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 2 years ago in Spotfire / Visualization 2 Future Consideration