Data cleaning

Whichever way to upload your data you choose, be sure to follow these basic rules:

  1. Numbers should not be mixed with any symbols, sign or string such as $, €, USD, %, ºC, etc.

    Wrong: $12345, 15ºC, 39USD

    Good: 12345, 15, 39

  2. Use the period as a decimal mark.
    Wrong: 123,45

    Good: 123.45

  3. Always sort the first column (x-axis) in ascending order.
    i.e. the x-axis data should be arranged from the smallest to the largest number or from the old date to the new date.

  4. Valid date formats:
    Date values should have a consistent format using one of the following formats:

    • YYYY/mm/dd
    • dd/mm/YYYY
    • mm/dd/YYYY
    • dd/mm/YY
    • mm/dd/YY
    • Number (Unix epoch time in milliseconds)

    If none of the formats above have been used for date values, everviz will try to parse the value of the cell based on core Date functions, and this can cause unexpected behavior.

Did you find what you were looking for? Thank you! There was a problem submitting your feedback. Please try again later.