mbzo2006

Thank you (@plantprogrammer) and (@bsfherman) for your excellent suggestions. Kind regards, m’b

Hi there, thanks for the feedback. Look forward to future updates!
Regards,

Thanks for your feedback.
Disabling the GDPR plugin seems to remove the error from the console.
Will check the jQuery.validator as suggested.
Thanks again.
Regards,

Sure, here is the page
Many thanks!

Hi @martynasma, it seems that the issue is resolved.

Hi @martynasma, thanks in advance for your help.

You can see an example here.

The column and pie charts are copied from the demos: https://www.amcharts.com/demos/

• This reply was modified 3 years, 11 months ago by mbzo2006.
• This reply was modified 3 years, 11 months ago by mbzo2006.

Closed (not solved)

Ok, thanks for the reply. Unfortunately, international date formats are what we use.
I will close this topic.
Kind regards,

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

Hi Vytis,
Is there a solution for this?

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,

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

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.

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

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, 5 months ago by mbzo2006.
• This reply was modified 4 years, 5 months ago by mbzo2006.