Skip to main content
Question

Help Needed to convert Data Type

  • May 20, 2026
  • 1 reply
  • 18 views
W
Committed ⭐️

I am currently facing an issue where the dataset data type is set as string = true, whereas it should be false (numeric). As a result, the chart is not displaying any data due to the field being treated as a string.

However, when I download the dataset as a CSV file, the data is present. Could you advise if there is a quick fix on your side to convert the data type from string to numeric?

 

 

    1 reply

    Mithila Jayalath
    Expert ⭐️⭐️⭐️⭐️
    Forum|alt.badge.img+9
    • Mithila Jayalath
    • Expert ⭐️⭐️⭐️⭐️
    • May 20, 2026

    ​@Win Nie Choong the isString property in CDF is defined at the time a time series is created and cannot be modified afterward. This restriction applies across all interfaces, including the API, SDK, and Transformations.

    Recommended Solution:

    1. Delete the incorrectly typed time series.
    2. Recreate the time series with isString = false, explicitly setting the correct type during creation.
    3. Re-ingest the data points into the newly created numeric time series.

    If deleting and re-ingesting historical data is not practical:

    1. Create new time series with identical metadata but with isString = false.
    2. Use the Time Series /list API together with Data Point Subscriptions to copy or migrate data points from the existing string time series to the new numeric ones.
    3. Keep both series synchronized during the transition period until migration is complete.
    Terms & ConditionsAccessibility statement