Date formats? Invalid data types?

  • Resolved mbzo2006

    (@mbzo2006)


    4 years ago

    Hi there, I downloaded Visualizer to see how it works. So far unable to plot anything.
    Try a simple two column CSV.
    COLUMN A is a list of dates in the following format: dd-mm-yy
    COLUMN B is a list of values, where the decimal is represented by a comma (123,45)

    Import = Invalid data types

    Ok, so changed date format to dd/mm/yy and changed the , decimals to . (123.45)

    Import = Invalid data types

    Looked at the Column.csv file for clues on how to format data but the sample file data has no dates, no decimals. Florence,371282,607906,655875

    Is there a workaround for this?

    • This topic was modified 4 years ago by mbzo2006.
    • This topic was modified 4 years ago by mbzo2006.
Viewing 15 replies - 1 through 15 (of 17 total)
  • Plugin Contributor contactashish13

    (@rozroz)

    Please share the CSV that you are using. Have you verified that the format of the file is similar to the format of the sample CSVs (first row contains headings and second row data type)?

    Thread Starter mbzo2006

    (@mbzo2006)

    Hi there, thanks for the reply.
    How about these formats?
    Test#1
    Test#2

    • This reply was modified 4 years ago by mbzo2006. Reason: Added links
    Thread Starter mbzo2006

    (@mbzo2006)

    UPDATE:
    Tried another method using Google Spreadsheet as instructed how to:

    Importing the sheet link also throws an error (“Invalid data type on the second row”)

    This is the link to the csv data
    Google Spreedsheet Data

    Not sure what is wrong

    Thread Starter mbzo2006

    (@mbzo2006)

    CLOSER:
    I realized too late that it was necessary to manually specify the data type in row 2.
    That explains the error.
    So a new spreadsheet later, it almost works. It seems that the DATE is being read
    mm/dd/yyyy – and not the familiar dd/mm/yyyy format.

    GOOGLE SPREADSHEET DATA

    Apologies for posting a different issue in the same post.

    • This reply was modified 4 years ago by mbzo2006.
    • This reply was modified 4 years ago by mbzo2006.
    Plugin Contributor contactashish13

    (@rozroz)

    We always recommend reading instructions before using the plugin ??

    Have you looked at the advanced settings and tried changing the date format there?

    Thread Starter mbzo2006

    (@mbzo2006)

    Where are these advanced settings located?
    Can you explain in more detail?
    Preview of column graph and Settings panel

    In Google Spreadsheets I can change the Locale to use the desired date format (dd/mm/yyyy)

    What else?

    • This reply was modified 4 years ago by mbzo2006.
    • This reply was modified 4 years ago by mbzo2006.
    Thread Starter mbzo2006

    (@mbzo2006)

    FYI – here are two plots of the same data.
    1) Excel line chart
    2) Visualizer WordPress line chart

    Each point (number) should be a monthly value.

    While I can change the horizontal axis format in Visualizer, the data is still plotted incorrectly.

    How to fix this?

    // The data
    Data,Valor
    date,number
    01/01/2018,116.96
    01/02/2018,120.57
    01/03/2018,115.64
    01/04/2018,109.94
    01/05/2018,113.50
    01/06/2018,104.00
    01/07/2018,103.48
    01/08/2018,104.38
    01/09/2018,106.79
    01/10/2018,107.91
    01/11/2018,114.50
    01/12/2018,127.80
    01/01/2019,128.64
    01/02/2019,139.39
    01/03/2019,125.53
    01/04/2019,121.71
    01/05/2019,117.01
    01/06/2019,107.38
    01/07/2019,110.92
    01/08/2019,114.58
    01/09/2019,112.19
    01/10/2019,111.82
    01/11/2019,118.64
    01/12/2019,121.26
    01/01/2020,121.27
    01/02/2020,131.79
    01/03/2020,124.58
    01/04/2020,111.97
    01/05/2020,96.82
    01/06/2020,100.43
    01/07/2020,102.84

    Thread Starter mbzo2006

    (@mbzo2006)

    Hi there @rozroz, is this not possible?
    I saved the data (above) in a new csv file and imported the file. However the line plot is still wrong;
    Days and months are inverted.
    Horizontal axis settings is d/M/yy
    Wordpress general settings also is d/m/Y.

    Plugin Support Vytis

    (@bvytis)

    Hi @mbzo2006,

    I have tried using the numberFormat in the plugin to set date format and it works as expected: https://prnt.sc/vfn8rj

    The date is being converted. Could you check and verify that it doesn’t work on your end?

    Thread Starter mbzo2006

    (@mbzo2006)

    Hi there Vytis, thanks for taking time to look at this issue

    Your screenshot seems to confirm that Visualizer displays the data incorrectly.

    As you can see, your plot shows three spikes, which is wrong.

    Your screenshot should look more like the plot in Excel, see below:

    Excel line chart

    Unfortunately, I could not reproduce this plot in Visualizer.

    Any assistance you can offer is greatly appreciated.

    Regards

    Plugin Support Vytis

    (@bvytis)

    Hi @mbzo2006,

    I have misunderstood your issue at first, apologies for that.

    May you please share the file that you are using again? I can no longer access it using: https://docs.google.com/spreadsheets/d/e/2PACX-1vSl6em_U1EPiQWuSAKrEXOsSnsWNpvyZ35m9yyORMn08Y5JuW0kQIVr9xjxvRnbADY3Q18bDMQUbdh7/pub?output=csv

    Thanks!

    Thread Starter mbzo2006

    (@mbzo2006)

    Hi Vytis,
    Could be a network issue.
    The data file can be downloaded as a CSV here:
    https://www.mediafire.com/file/sqwvgmf7bcfnlxm/ICC_json_serie-sgs-4393-test.csv/file

    If required, here is the link to the shared Google spreadsheet:
    https://docs.google.com/spreadsheets/d/e/2PACX-1vT29wtDbHLc1_npfedN0DVex4yFOJtf_b1MBRM-R-cDFOCo6WqewdpWtUBtOmvXNiajJFaGmkAz8NWq/pubhtml

    regards,

    Thread Starter mbzo2006

    (@mbzo2006)

    Hi Vytis,
    Is there a solution for this?

    Thread Starter mbzo2006

    (@mbzo2006)

    Hi @bvytis ,
    I′m still interested to know if there is a solution or workaround.
    Regards,

    Plugin Support Vytis

    (@bvytis)

    Hi @mbzo2006,

    Sorry for the delay but I can’t make the date reformatted with the out of the box settings of the plugin so the easiest way is to change your source file and use mm/dd/yyyy format to show the data correctly.

Viewing 15 replies - 1 through 15 (of 17 total)
  • The topic ‘Date formats? Invalid data types?’ is closed to new replies.