CSV is not exported correctly by Apex Charts Widget

1

Olá, @alvarolb and @jaimebs

When exporting data from the Apex Charts Widget, the hour, minute and second corresponding to the exported data are not informed.

CSV (Timestamp records do not inform the hour, minute and second):

image
image538×507 5.59 KB

Widget Apex Chart

image
image750×465 33.9 KB

We tried changing the Apex Charts configuration, but nothing works correctly.

Apex Charts documentation:

var options = {
    series: series,
    chart: {
        type: 'line',
        zoom: {
            enabled: true
        }
    },
    zoom: {
        type: 'x',
        enabled: true,
        autoScaleYaxis: true
    },
    toolbar: {
 export: {
          csv: {
            filename: 'name_teste',
            columnDelimiter: ';',
            headerCategory: 'data_hora',
            headerValue: 'value',
            dateFormatter(timestamp) {
              return new Date(timestamp).toDateString()
            }
          },
        }
    },
    stroke: {
        curve: 'straight',
        width: 4
    },
    grid: {
        row: {
            colors: ['#f3f3f3', 'transparent'],
            opacity: 0.5
        },
    },
    xaxis: {
        type: 'datetime',
        tooltip: {
            enabled: false
        },
        labels: {
            datetimeUTC: false
        }
    },
    yaxis: {
        labels: {
            "formatter": function (val) {
                return val;
            }
        }
    },
    tooltip: {
        x: {
            format: 'dd/MM/yyyy HH:mm:ss'
        }
    }
};

Is it possible to change the Apex Charts export (CSV) configuration, or is there a lock?

2

same problem here…

3

Hi Tom,

This worked for me, at the display code → chart>toolbar>export>csv>

            export: {
                csv: {
                    filename: undefined,
                    columnDelimiter: ',',
                    headerCategory: 'ts',
                    headerValue: 'value',
                    categoryFormatter(x) {
                        return new Date(x).toString()
                    }
                }

The code that formats the date is → 

                    categoryFormatter(x) {
                        return new Date(x).toString()
                    }

Hope this helps