Multiple lines for a single series

I have a chart which is populated with two timeseries data arrays. However, on the chart which is displayed, there are multiple lines for each series.
You can see this in the image below.
There is only one data point for each timestamp per series, and it is once per minute.

I cannot seem to remove the mulitple lines for each series, so any help would be appreciated.


Hi.
Welcome to the forum.

It looks like your array isn’t sorted by time. I’m not shure until I see (a part of) your data.

Chris

Thanks for the quick response, and suggestion.

Here is the SQL select that is extracting the data
select sampleDateTime * 1000 as 'TS(ms)', sampleTemp, sampleHumidity from sensorReadings where (sensorID = 'SHT-af286f247437' and (sampleDateTime >=1635634800 and sampleDateTime <1635807600)) order by 'TS(ms)' asc

The output is then transformed by a change node using the following code

(
  $series := [
    { "field": "sampleTemp", "label": "Temperature" },
    { "field": "sampleHumidity", "label": "Humidity" }
  ];
  $xaxis := "TS(ms)";
  [
    {
      "series": $series.label,
      "data": $series.[
        (
          $yaxis := $.field;
          $$.payload.{
            "x": $lookup($, $xaxis),
            "y": $lookup($, $yaxis)
          }
        )
      ]
    }
  ]
)

Which generates the array of arrays 'Series' and 2-dimensional 'Data'. The timestamps in the array look to be in the correct order - there are 1500+ data points in each of the series, here is some of it tho.

[{"series":["Temperature","Humidity"],"data":[[{"x":1635634823000,"y":59.18},{"x":1635634884000,"y":59.15},{"x":1635634944000,"y":59.25},{"x":1635635004000,"y":59.07},{"x":1635635065000,"y":59.13},{"x":1635635125000,"y":59.11},{"x":1635635185000,"y":59.13},{"x":1635635245000,"y":59.09},{"x":1635635306000,"y":59.09},{"x":1635635366000,"y":59.15},{"x":1635635426000,"y":59.13},{"x":1635635487000,"y":59.04},{"x":1635635547000,"y":59.02},{"x":1635635607000,"y":59.1},{"x":1635635668000,"y":59.06},{"x":1635635728000,"y":59.11},{"x":1635635788000,"y":58.96},{"x":1635635849000,"y":59.14},{"x":1635635909000,"y":57.54},{"x":1635635969000,"y":56.68},{"x":1635636030000,"y":56.02},{"x":1635636090000,"y":55.8},{"x":1635636150000,"y":55.36},{"x":1635636210000,"y":55.46},{"x":1635636250000,"y":55.63},{"x":1635636491000,"y":56.33},{"x":1635636551000,"y":56.82},{"x":1635636612000,"y":56.65},{"x":1635636310000,"y":55.95},{"x":1635636732000,"y":57.14},{"x":1635636793000,"y":57.38},{"x":1635636853000,"y":57.56},{"x":1635636913000,"y":57.64},{"x":1635636973000,"y":57.29},{"x":1635637034000,"y":57.05},{"x":1635637094000,"y":57.06},{"x":1635637154000,"y":57.18},{"x":1635637215000,"y":57.19},{"x":1635637275000,"y":57.4},{"x":1635637335000,"y":57.65},{"x":1635636672000,"y":57.11},{"x":1635637456000,"y":57.64},{"x":1635637516000,"y":57.79},{"x":1635637577000,"y":57.83},{"x":1635637637000,"y":58.1},{"x":1635637697000,"y":57.99},{"x":1635637758000,"y":58.16},{"x":1635637818000,"y":58.15},{"x":1635637878000,"y":58.19},{"x":1635637938000,"y":58.12},{"x":1635637999000,"y":58.1},{"x":1635638059000,"y":58.02},{"x":1635638119000,"y":58.3},{"x":1635638180000,"y":58.36},{"x":1635638240000,"y":58.18},{"x":1635636431000,"y":56.05},{"x":1635638361000,"y":58.09},{"x":1635638421000,"y":58.05},{"x":1635638481000,"y":57.93},{"x":1635638542000,"y":57.98},{"x":1635638602000,"y":58},{"x":1635638662000,"y":57.92},{"x":1635638723000,"y":58.15},{"x":1635638783000,"y":58.32},{"x":1635638843000,"y":58.19},{"x":1635638904000,"y":58.2},{"x":1635638964000,"y":57.92},{"x":1635638300000,"y":58.04},{"x":1635639084000,"y":57.49},{"x":1635639145000,"y":57.73},{"x":1635639205000,"y":57.72},{"x":1635639265000,"y":57.81},{"x":1635639326000,"y":57.81},{"x":1635639386000,"y":57.79},{"x":1635639446000,"y":57.78},{"x":1635639507000,"y":57.68},{"x":1635639567000,"y":57.55},{"x":1635636370000,"y":55.86},{"x":1635639688000,"y":57.74},{"x":1635639748000,"y":57.65},{"x":1635639808000,"y":57.58},{"x":1635639024000,"y":57.8},{"x":1635637396000,"y":57.47},{"x":1635639627000,"y":57.62},{"x":1635639848000,"y":57.23},{"x":1635640089000,"y":56.75},{"x":1635640149000,"y":56.66},{"x":1635640209000,"y":56.51},{"x":1635640270000,"y":56.28},{"x":1635640330000,"y":56.21},{"x":1635640390000,"y":56.18},{"x":1635640451000,"y":56.05},{"x":1635640511000,"y":56.15},{"x":1635640571000,"y":56.12},{"x":1635640632000,"y":56.1},{"x":1635640692000,"y":56.26},{"x":1635640752000,"y":56.21},{"x":1635640813000,"y":56.21},{"x":1635640873000,"y":56.26},{"x":1635640933000,"y":56.12},{"x":1635640994000,"y":56.25},{"x":1635639968000,"y":56.88},{"x":1635641114000,"y":55.93},{"x":1635641174000,"y":55.86},{"x":1635641235000,"y":55.62},{"x":1635641295000,"y":55.49},{"x":1635641355000,"y":55.09},{"x":1635641416000,"y":54.87},{"x":1635641476000,"y":55.04},{"x":1635641536000,"y":55.26},{"x":1635641597000,"y":55.31},{"x":1635641657000,"y":55.65},{"x":1635641717000,"y":55.63},{"x":1635641778000,"y":55.75},{"x":1635640029000,"y":57.07},{"x":1635641898000,"y":56.32},{"x":1635641959000,"y":56.09},{"x":1635642019000,"y":56.09},{"x":1635642079000,"y":56.1},{"x":1635642140000,"y":56.29},{"x":1635642200000,"y":56.54},{"x":1635642260000,"y":56.36},{"x":1635642320000,"y":56.23},{"x":1635642381000,"y":56.69},{"x":1635642441000,"y":56.46},{"x":1635642501000,"y":56.25},{"x":1635642562000,"y":56.35},{"x":1635642622000,"y":56.11},{"x":1635642682000,"y":56.44},{"x":1635642743000,"y":56.32},{"x":1635642803000,"y":56.62},{"x":1635642863000,"y":56.58},{"x":1635642924000,"y":56.58},{"x":1635642984000,"y":56.39},{"x":1635643044000,"y":56.45},{"x":1635643105000,"y":56.59},{"x":1635643165000,"y":56.61},{"x":1635643225000,"y":56.38},{"x":1635643286000,"y":56.53},{"x":1635643346000,"y":56.71},{"x":1635643406000,"y":56.55},{"x":1635641054000,"y":55.84},{"x":1635641838000,"y":56.05},{"x":1635639908000,"y":56.89},{"x":1635643445000,"y":56.43},{"x":1635643687000,"y":56.69},{"x":1635643747000,"y":56.66},{"x":1635643807000,"y":56.61},{"x":1635643867000,"y":56.59},{"x":1635643928000,"y":56.82},{"x":1635643988000,"y":56.56},{"x":1635644048000,"y":56.52},{"x":1635644109000,"y":56.65},{"x":1635644169000,"y":56.64},{"x":1635644229000,"y":56.86},{"x":1635643626000,"y":56.97},{"x":1635644350000,"y":56.52},{"x":1635644410000,"y":56.75},{"x":1635644471000,"y":56.58},{"x":1635644531000,"y":56.7},{"x":1635644591000,"y":56.49},{"x":1635644652000,"y":56.71},{"x":1635644712000,"y":56.7},{"x":1635644290000,"y":56.79},{"x":1635644832000,"y":56.32},{"x":1635644893000,"y":56.19},{"x":1635644953000,"y":56.14},{"x":1635645013000,"y":55.97},{"x":1635645074000,"y":56.07},{"x":1635645134000,"y":55.97},{"x":1635645194000,"y":56.24},{"x":1635644772000,"y":56.5},{"x":1635645315000,"y":56.24},{"x":1635645375000,"y":56.35},{"x":1635645436000,"y":56.48},{"x":1635645496000,"y":56.32},{"x":1635645556000,"y":56.28},{"x":1635645617000,"y":56.22},{"x":1635645677000,"y":56.2},{"x":1635645737000,"y":55.92},{"x":1635645798000,"y":56.04},{"x":1635645858000,"y":56.26},{"x":1635645918000,"y":56.14},{"x":1635645255000,"y":56.28},{"x":1635646039000,"y":56.14},{"x":1635646099000,"y":56.03},{"x":1635646159000,"y":55.93},{"x":1635646220000,"y":55.95},{"x":1635646280000,"y":55.87},{"x":1635646340000,"y":55.83},{"x":1635646401000,"y":55.96},{"x":1635646461000,"y":55.67},{"x":1635646521000,"y":55.81},{"x":1635646582000,"y":55.83},{"x":1635646642000,"y":55.87},{"x":1635645978000,"y":56.28},{"x":1635646763000,"y":55.78},{"x":1635646823000,"y":55.67},{"x":1635646883000,"y":55.64},{"x":1635646943000,"y":55.67},{"x":1635647004000,"y":55.53},{"x":1635643566000,"y":56.82},{"x":1635646702000,"y":55.77},{"x":1635643506000,"y":56.55},{"x":1635647043000,"y":55.48},{"x":1635647284000,"y":56.04},{"x":1635647345000,"y":55.79},{"x":1635647405000,"y":55.62},{"x":1635647465000,"y":55.9},{"x":1635647526000,"y":55.63},{"x":1635647164000,"y":55.77},{"x":1635647646000,"y":55.78},{"x":1635647707000,"y":55.78},{"x":1635647767000,"y":55.5},{"x":1635647827000,"y":55.44},{"x":1635647888000,"y":55.42},{"x":1635647948000,"y":55.41},{"x":1635648008000,"y":55.53},{"x":1635648069000,"y":55.32},{"x":1635648129000,"y":55.51},{"x":1635648189000,"y":55.4},{"x":1635648249000,"y":55.37},{"x":1635648310000,"y":55.44},{"x":1635648370000,"y":55.43},{"x":1635648430000,"y":55.29},{"x":1635648491000,"y":55.45},{"x":1635648551000,"y":55.46},{"x":1635648611000,"y":55.32},{"x":1635648672000,"y":55.43},{"x":1635648732000,"y":55.52},{"x":1635648792000,"y":55.5},{"x":1635648853000,"y":55.39},{"x":1635648913000,"y":55.51},{"x":1635648973000,"y":55.6},{"x":1635649034000,"y":55.93},{"x":1635649094000,"y":55.64},{"x":1635649154000,"y":55.87},{"x":1635649215000,"y":55.87},{"x":1635649275000,"y":55.88},{"x":1635649335000,"y":55.71},{"x":1635649395000,"y":55.72},{"x":1635649456000,"y":56.15},{"x":1635649516000,"y":56.13},{"x":1635649576000,"y":56.03},{"x":1635649637000,"y":56.1},{"x":1635649697000,"y":56.06},{"x":1635649757000,"y":56.24},{"x":1635649818000,"y":56.14},{"x":1635649878000,"y":56.01},{"x":1635649938000,"y":56.32},{"x":1635649999000,"y":56.31},{"x":1635650059000,"y":56.26},{"x":1635650119000,"y":56.3},{"x":1635650180000,"y":56.28},{"x":1635650240000,"y":56.09},{"x":1635650300000,"y":56.1},{"x":1635650360000,"y":55.99},{"x":1635650421000,"y":56.04},{"x":1635650481000,"y":56.14},{"x":1635650541000,"y":56.24},{"x":1635650602000,"y":56.41},{"x":1635647586000,"y":55.64},{"x":1635647224000,"y":55.86},{"x":1635647104000,"y":55.58},{"x":1635650641000,"y":56.43},{"x":1635650882000,"y":56.22},{"x":1635650943000,"y":56.36},{"x":1635651003000,"y":56.37},{"x":1635651063000,"y":56.11},{"x":1635651123000,"y":56.25},{"x":1635651184000,"y":56.35},{"x":1635651244000,"y":56.35},{"x":1635651304000,"y":56.39},{"x":1635651365000,"y":56.3},{"x":1635651425000,"y":56.33},{"x":1635651485000,"y":56.36},{"x":1635651546000,"y":56.34},{"x":1635651606000,"y":56.19},{"x":1635650701000,"y":56.46},{"x":1635651727000,"y":56.11},{"x":1635651787000,"y":56.21},{"x":1635651847000,"y":56.43},{"x":1635651908000,"y":56.18},{"x":1635651968000,"y":56.43},{"x":1635652028000,"y":56.43},{"x":1635652089000,"y":56.21},{"x":1635652149000,"y":56.2},{"x":1635652209000,"y":56.22},{"x":1635652269000,"y":56.25},{"x":1635652330000,"y":56.42},{"x":1635651666000,"y":56.37},{"x":1635652450000,"y":56.43},{"x":1635652511000,"y":56.39},{"x":1635652571000,"y":56.5},{"x":1635652631000,"y":56.34},{"x":1635652692000,"y":56.23},{"x":1635652752000,"y":56.37},{"x":1635652812000,"y":56.16},{"x":1635652390000,"y":56.78},{"x":1635652933000,"y":56.22},{"x":1635652993000,"y":56.12},{"x":1635653054000,"y":56.21},{"x":1635653114000,"y":56.2},{"x":1635650762000,"y":56.43},{"x":1635653234000,"y":56.12},{"x":1635653295000,"y":56.07},{"x":1635653355000,"y":56.22},{"x":1635653415000,"y":56.35},{"x":1635653476000,"y":56.3},{"x":1635653536000,"y":56.25},{"x":1635653596000,"y":56.11},{"x":1635653657000,"y":56.26},{"x":1635653717000,"y":56.38},{"x":1635653777000,"y":56.35},{"x":1635653838000,"y":56.23},{"x":1635653898000,"y":56.22},{"x":1635653958000,"y":56.19},{"x":1635654019000,"y":56.21},{"x":1635654079000,"y":56.33},{"x":1635654139000,"y":56.23},{"x":1635654200000,"y":55.9},{"x":1635652873000,"y":56.25},{"x":1635653174000,"y":56.14},{"x":1635650822000,"y":56.3},{"x":1635654239000,"y":55.96},{"x":1635654480000,"y":55.69},{"x":1635654540000,"y":55.87},{"x":1635654601000,"y":56.1},{"x":1635654661000,"y":56.07},{"x":1635654721000,"y":56.21},{"x":1635654782000,"y":56.26},{"x":1635654842000,"y":54.61},{"x":1635654902000,"y":55.07},{"x":1635654963000,"y":54.9},{"x":1635654299000,"y":56.13},{"x":1635655083000,"y":55.07},{"x":1635655143000,"y":55.23},{"x":1635655204000,"y":55.39},{"x":1635655264000,"y":55.33},{"x":1635655324000,"y":55.57},{"x":1635655385000,"y":55.71},{"x":1635655445000,"y":55.76},{"x":1635655505000,"y":55.92},{"x":1635655023000,"y":55.05},{"x":1635655626000,"y":55.92},{"x":1635655686000,"y":56.09},{"x":1635655747000,"y":56.08},{"x":1635655807000,"y":56.02},{"x":1635655867000,"y":56.33},{"x":1635655928000,"y":56.32},{"x":1635655988000,"y":56.44},{"x":1635656048000,"y":56.27},{"x":1635656109000,"y":56.67},{"x":1635656169000,"y":56.95},{"x":1635655566000,"y":55.9},{"x":1635656289000,"y":57.21},{"x":1635656350000,"y":56.84},{"x":1635656410000,"y":56.87},{"x":1635656470000,"y":56.82},{"x":1635654359000,"y":55.9},{"x":1635656591000,"y":56.94},{"x":1635656651000,"y":56.81},{"x":1635656712000,"y":56.86},{"x":1635656772000,"y":56.9},{"x":1635656832000,"y":57.09},{"x":1635656893000,"y":56.91},{"x":1635656953000,"y":56.9},{"x":1635657013000,"y":56.86},{"x":1635657074000,"y":56.76},{"x":1635657134000,"y":58.17},{"x":1635657194000,"y":57.38},{"x":1635657254000,"y":56.86},{"x":1635657315000,"y":57.07},{"x":1635657375000,"y":56.88},{"x":1635657435000,"y":57.25},{"x":1635657496000,"y":57.59},{"x":1635657556000,"y":56.91},{"x":1635657616000,"y":56.9},{"x":1635656229000,"y":55.92},{"x":1635657737000,"y":57.31},{"x":1635657797000,"y":57.17},{"x":1635657677000,"y":56.89},{"x":1635656531000,"y":56.96},{"x":1635654420000,"y":55.78},{"x":1635657837000,"y":57.14},{"x":1635658078000,"y":57.29},{"x":1635658138000,"y":57},{"x":1635658017000,"y":57.31},{"x":1635658259000,"y":56.86},{"x":1635658319000,"y":56.85},{"x":1635658379000,"y":57.07},{"x":1635658440000,"y":56.59},{"x":1635658500000,"y":56.48},{"x":1635658560000,"y":56.52},{"x":1635658621000,"y":56.49},{"x":1635658681000,"y":56.59},{"x":1635657897000,"y":57.22},{"x":1635658802000,"y":56.52},{"x":1635658862000,"y":56.68},{"x":1635658922000,"y":56.97},{"x":1635658983000,"y":56.7},{"x":1635659043000,"y":56.65},{"x":1635659103000,"y":56.81},{"x":1635659163000,"y":56.93},{"x":1635659224000,"y":56.77},{"x":1635657957000,"y":58.46},{"x":1635659344000,"y":56.57},{"x":1635659405000,"y":56.49},{"x":1635659465000,"y":56.75},{"x":1635659525000,"y":56.47},{"x":1635659586000,"y":56.67},{"x":1635659646000,"y":56.48},{"x":1635659706000,"y":56.48},{"x":1635659767000,"y":56.52},{"x":1635658198000,"y":57.02},{"x":1635659887000,"y":56.29},{"x":1635659948000,"y":56.39},{"x":1635660008000,"y":56.25},{"x":1635660068000,"y":56.25},{"x":1635660128000,"y":56.28},{"x":1635660189000,"y":56.2},{"x":1635660249000,"y":56.21},{"x":1635660309000,"y":56.31},{"x":1635660370000,"y":56.25},{"x":1635660430000,"y":56.28},{"x":1635660490000,"y":56.1},{"x":1635660551000,"y":56.09},{"x":1635660611000,"y":56.08},{"x":1635659284000,"y":56.37},{"x":1635660732000,"y":55.99},{"x":1635660792000,"y":56.03},{"x":1635660852000,"y":56.05},{"x":1635660913000,"y":56.03},{"x":1635660973000,"y":56.14},{"x":1635661033000,"y":55.94},{"x":1635661094000,"y":55.94},{"x":1635661154000,"y":56.14},{"x":1635661214000,"y":56.11},{"x":1635661274000,"y":56.24},{"x":1635661335000,"y":56.07},{"x":1635660671000,"y":55.96},{"x":1635659827000,"y":56.44},{"x":1635658741000,"y":56.59},{"x":1635661395000,"y":56},{"x":1635661434000,"y":55.86},{"x":1635661675000,"y":54.89},{"x":1635661736000,"y":54.47},{"x":1635661796000,"y":54.72},{"x":1635661856000,"y":54.51},{"x":1635661917000,"y":54.25},{"x":1635661555000,"y":55.6},{"x":1635662037000,"y":54.75},{"x":1635662098000,"y":55},{"x":1635662158000,"y":54.84},{"x":1635662218000,"y":54.96},{"x":1635662279000,"y":55.09},{"x":1635661494000,"y":55.63},{"x":1635662399000,"y":55.06},{"x":1635662459000,"y":55.14},{"x":1635662520000,"y":55.3},{"x":1635662580000,"y":55.12},{"x":1635662640000,"y":55.19},{"x":1635662701000,"y":55.15},{"x":1635662761000,"y":55.34},{"x":1635662821000,"y":55.19},{"x":1635662882000,"y":55.24},{"x":1635662942000,"y":55.14},{"x":1635663002000,"y":55.21},{"x":1635663063000,"y":55.42},{"x":1635663123000,"y":55},{"x":1635663183000,"y":55.17},{"x":1635663244000,"y":55.25},{"x":1635663304000,"y":55.15},{"x":1635663364000,"y":55.21},{"x":1635663424000,"y":55.34},{"x":1635661615000,"y":55.65},{"x":1635663545000,"y":55.23},{"x":1635663605000,"y":55.04},{"x":1635663666000,"y":55.32},{"x":1635663726000,"y":55.59},{"x":1635663786000,"y":55.35},{"x":1635663847000,"y":55.32},{"x":1635663907000,"y":55.34},{"x":1635663967000,"y":55.15},{"x":1635664028000,"y":55.17},{"x":1635664088000,"y":55.26},{"x":1635664148000,"y":55.03},{"x":1635664209000,"y":55.32},{"x":1635664269000,"y":55.24},{"x":1635664329000,"y":55.18},{"x":1635664390000,"y":55.5},{"x":1635664450000,"y":55.56},{"x":1635664510000,"y":55.71},{"x":1635664570000,"y":55.17},{"x":1635664631000,"y":55.32},{"x":1635664691000,"y":55.34},{"x":1635664751000,"y":55.16},{"x":1635664812000,"y":55.32},{"x":1635664872000,"y":55.07},{"x":1635664932000,"y":54.98},{"x":1635664993000,"y":54.95},{"x":1635661977000,"y":54.63},{"x":1635663485000,"y":55.17},{"x":1635662339000,"y":54.98},{"x":1635665032000,"y":55.11},{"x":1635665273000,"y":54.99},{"x":1635665333000,"y":55.01},{"x":1635665394000,"y":55.11},{"x":1635665454000,"y":55.01},{"x":1635665514000,"y":54.9},{"x":1635665575000,"y":55.02},{"x":1635665635000,"y":54.99},{"x":1635665695000,"y":54.9},{"x":1635665756000,"y":54.68},{"x":1635665816000,"y":54.87},{"x":1635665876000,"y":55.13},{"x":1635665936000,"y":55.21},{"x":1635665997000,"y":55.26},{"x":1635666057000,"y":55.3},{"x":1635666117000,"y":55.22},{"x":1635666178000,"y":55.28},{"x":1635666238000,"y":55.04},{"x":1635666298000,"y":55.02},{"x":1635666359000,"y":54.72},{"x":1635666419000,"y":54.85},{"x":1635666479000,"y":54.76},{"x":1635666540000,"y":54.79},{"x":1635666600000,"y":54.76},{"x":1635665213000,"y":54.79},{"x":1635666721000,"y":54.99},{"x":1635666781000,"y":55.03},{"x":1635666841000,"y":54.91},{"x":1635666901000,"y":54.78},{"x":1635666962000,"y":54.74},{"x":1635665092000,"y":55.04},{"x":1635667082000,"y":54.81},{"x":1635667143000,"y":54.72},{"x":1635667203000,"y":54.73},{"x":1635667263000,"y":54.72},{"x":1635667324000,"y":54.73},{"x":1635667384000,"y":54.73},{"x":1635667444000,"y":54.69},{"x":1635667505000,"y":54.6},{"x":1635667565000,"y":54.77},{"x":1635667625000,"y":54.73},{"x":1635667686000,"y":54.68},{"x":1635667022000,"y":54.74},{"x":1635667806000,"y":54.58},{"x":1635667867000,"y":54.71},{"x":1635667927000,"y":54.69},{"x":1635667987000,"y":54.79},{"x":1635668047000,"y":54.54},{"x":1635668108000,"y":54.61},{"x":1635668168000,"y":54.76},{"x":1635668228000,"y":54.67},{"x":1635668289000,"y":54.63},{"x":1635668349000,"y":54.51},{"x":1635668409000,"y":54.6},{"x":1635668470000,"y":54.47},{"x":1635668530000,"y":54.59},{"x":1635668590000,"y":54.59},{"x":1635665152000,"y":54.97},{"x":1635666660000,"y":54.7},{"x":1635667746000,"y":54.6},{"x":1635668629000,"y":54.48},{"x":1635668871000,"y":54.54},{"x":1635668931000,"y":54.33},{"x":1635668991000,"y":54.49},{"x":1635669052000,"y":54.54},{"x":1635669112000,"y":54.6},{"x":1635669172000,"y":54.67},{"x":1635669233000,"y":54.61},{"x":1635669293000,"y":54.67},{"x":1635669353000,"y":54.61},{"x":1635669413000,"y":54.66},{"x":1635669474000,"y":54.76},{"x":1635669534000,"y":54.76},{"x":1635669594000,"y":54.61},{"x":1635669655000,"y":54.81},{"x":1635669715000,"y":54.63},{"x":1635669775000,"y":54.94},{"x":1635669836000,"y":54.9},{"x":1635668810000,"y":54.57},{"x":1635669956000,"y":54.91},{"x":1635670017000,"y":54.93},{"x":1635670077000,"y":54.75},{"x":1635670137000,"y":54.85},{"x":1635668690000,"y":54.67},{"x":1635670258000,"y":54.83},{"x":1635670318000,"y":54.77},{"x":1635670379000,"y":54.78},{"x":1635670439000,"y":54.98},{"x":1635670499000,"y":54.95},{"x":1635670559000,"y":54.81},{"x":1635670620000,"y":54.94},{"x":1635670680000,"y":55.15},{"x":1635670740000,"y":54.96},{"x":1635669896000,"y":54.87},{"x":1635670861000,"y":55.04},{"x":1635670921000,"y":55.15},{"x":1635670982000,"y":55.01},{"x":1635671042000,"y":55.05},{"x":1635671102000,"y":55.09},{"x":1635671163000,"y":55.18},{"x":1635671223000,"y":55.18},{"x":1635671283000,"y":55.06},{"x":1635671344000,"y":55.14},{"x":1635671404000,"y":55.12},{"x":1635671464000,"y":55.2},{"x":1635671525000,"y":55.13},{"x":1635671585000,"y":55.11},{"x":1635671645000,"y":55.31},{"x":1635671705000,"y":55.28},{"x":1635671766000,"y":55.25},{"x":1635671826000,"y":55.31},{"x":1635671886000,"y":55.61},{"x":1635671947000,"y":55.79},{"x":1635672007000,"y":55.91},{"x":1635672067000,"y":55.96},{"x":1635672128000,"y":55.71},{"x":1635672188000,"y":55.78},{"x":1635670801000,"y":55.11},{"x":1635670198000,"y":54.7},{"x":1635668750000,"y":54.77},{"x":1635672227000,"y":55.73},{"x":1635672468000,"y":55.84},{"x":1635672529000,"y":55.79},{"x":1635672589000,"y":55.69},{"x":1635672649000,"y":55.87},{"x":1635672710000,"y":55.77},{"x":1635672770000,"y":55.8},{"x":1635672830000,"y":55.76},{"x":1635672891000,"y":55.96},{"x":1635672951000,"y":55.81},{"x":1635673011000,"y":55.63},{"x":1635673072000,"y":55.67},{"x":1635672287000,"y":55.7},{"x":1635673192000,"y":55.61},{"x":1635673253000,"y":55.71},{"x":1635673313000,"y":55.81},{"x":1635673373000,"y":55.6},{"x":1635672348000,"y":55.81},{"x":1635673494000,"y":55.78},{"x":1635673554000,"y":55.93},{"x":1635673614000,"y":55.68},{"x":1635673675000,"y":55.8},{"x":1635673735000,"y":55.76},{"x":1635673795000,"y":55.63},{"x":1635673856000,"y":55.67},{"x":1635673433000,"y":55.7},{"x":1635673976000,"y":55.78},{"x":1635674037000,"y":55.82},{"x":1635674097000,"y":55.85},{"x":1635674157000,"y":55.81},{"x":1635674218000,"y":55.59},{"x":1635674278000,"y":55.82},{"x":1635674338000,"y":55.76},{"x":1635674398000,"y":55.69},{"x":1635674459000,"y":55.67},{"x":1635674519000,"y":55.79},{"x":1635674579000,"y":55.53},{"x":1635674640000,"y":55.63},{"x":1635674700000,"y":55.58},{"x":1635674760000,"y":55.55},{"x":1635674821000,"y":55.61},{"x":1635674881000,"y":55.59},{"x":1635674941000,"y":55.49},{"x":1635675002000,"y":55.5},{"x":1635675062000,"y":55.58},{"x":1635675122000,"y":55.55},{"x":1635675183000,"y":55.42},{"x":1635675243000,"y":55.46},{"x":1635675303000,"y":55.6},{"x":1635675364000,"y":55.45},{"x":1635675424000,"y":55.64},{"x":1635675484000,"y":55.64},{"x":1635675544000,"y":55.63},{"x":1635675605000,"y":55.64},{"x":1635675665000,"y":55.74},{"x":1635675725000,"y":55.76},{"x":1635675786000,"y":55.87},{"x":1635673916000,"y":55.74},{"x":1635672408000,"y":55.92},{"x":1635673132000,"y":55.7},{"x":1635675825000,"y":55.82},{"x":1635676066000,"y":56.05},{"x":1635676126000,"y":56.12},{"x":1635676006000,"y":56.07},{"x":1635676247000,"y":56.2},{"x":1635676307000,"y":56.1},{"x":1635676368000,"y":56.08},{"x":1635675885000,"y":56.01},{"x":1635676488000,"y":56.16},{"x":1635676549000,"y":56.15},{"x":1635676609000,"y":56.35},{"x":1635675945000,"y":56.02},{"x":1635676730000,"y":56.25},{"x":1635676790000,"y":56.31},{"x":1635676850000,"y":56.37},{"x":1635676910000,"y":56.29},{"x":1635676971000,"y":56.3},{"x":1635677031000,"y":56.29},{"x":1635677091000,"y":56.25},{"x":1635676669000,"y":56.34},{"x":1635677212000,"y":56.23},{"x":1635677272000,"y":56.25},{"x":1635677333000,"y":56.31},{"x":1635677393000,"y":56.31},{"x":1635677453000,"y":56.52},{"x":1635677514000,"y":56.52},{"x":1635676428000,"y":56.08},{"x":1635677634000,"y":56.4},{"x":1635677695000,"y":56.45},{"x":1635677755000,"y":56.46},{"x":1635677815000,"y":56.52},{"x":1635677875000,"y":56.4},{"x":1635677936000,"y":56.58},{"x":1635677996000,"y":56.57},{"x":1635678056000,"y":56.63},{"x":1635677152000,"y":56.17},{"x":1635678177000,"y":56.66},{"x":1635678237000,"y":56.6},{"x":1635678298000,"y":56.66},{"x":1635678358000,"y":56.77},{"x":1635678418000,"y":56.73},{"x":1635678479000,"y":56.69},{"x":1635677574000,"y":56.34},{"x":1635678599000,"y":56.61},{"x":1635678660000,"y":56.65},{"x":1635678720000,"y":56.71},{"x":1635678780000,"y":56.69},{"x":1635678117000,"y":56.57},{"x":1635678901000,"y":56.84},{"x":1635678961000,"y":56.73},{"x":1635679021000,"y":56.79},{"x":1635679082000,"y":57.02},{"x":1635679142000,"y":56.85},{"x":1635679202000,"y":56.89},{"x":1635678539000,"y":56.68},{"x":1635679323000,"y":56.98},{"x":1635679383000,"y":56.79},{"x":1635679263000,"y":56.89},{"x":1635678841000,"y":56.85},{"x":1635676187000,"y":56.18},{"x":1635679422000,"y":56.86},{"x":1635679664000,"y":56.86},{"x":1635679724000,"y":56.93},{"x":1635679784000,"y":57},{"x":1635679483000,"y":56.91},{"x":1635679905000,"y":57.13},{"x":1635679965000,"y":57.09},{"x":1635680026000,"y":57.03},{"x":1635680086000,"y":57.02},{"x":1635679603000,"y":56.86},{"x":1635680207000,"y":57.13},{"x":1635680267000,"y":57.04},{"x":1635680327000,"y":57.11},{"x":1635680388000,"y":57.19},{"x":1635680448000,"y":57.06},{"x":1635680508000,"y":57.16},{"x":1635679845000,"y":57.04},{"x":1635680629000,"y":57.2},{"x":1635680689000,"y":57.23},{"x":1635680749000,"y":57.11},{"x":1635680810000,"y":57.11},{"x":1635680870000,"y":57.2},{"x":1635680930000,"y":57.1},{"x":1635680991000,"y":57.16},{"x":1635679543000,"y":56.95},{"x":1635681111000,"y":57.2},{"x":1635681172000,"y":57.16},{"x":1635681232000,"y":57.2},{"x":1635681292000,"y":57.23},{"x":1635681353000,"y":57.24},{"x":1635681413000,"y":57.24},{"x":1635681473000,"y":57.2},{"x":1635681533000,"y":57.02},{"x":1635681594000,"y":57.18},{"x":1635681654000,"y":57.17},{"x":1635681714000,"y":57.13},{"x":1635681775000,"y":57.19},{"x":1635680146000,"y":57.02},{"x":1635681895000,"y":57.18},{"x":1635681956000,"y":57},{"x":1635682016000,"y":57.26},{"x":1635682076000,"y":57.13},{"x":1635682137000,"y":57.15},{"x":1635682197000,"y":57.2},{"x":1635682257000,"y":57.2},{"x":1635682318000,"y":57.28},{"x":1635682378000,"y":57.4},{"x":1635682438000,"y":57.48},{"x":1635682499000,"y":57.42},{"x":1635682559000,"y":57.44},{"x":1635682619000,"y":57.6},{"x":1635682679000,"y":57.51},{"x":1635682740000,"y":57.51},{"x":1635682800000,"y":57.65},{"x":1635682860000,"y":57.6},{"x":1635682921000,"y":57.56},{"x":1635682981000,"y":57.64},{"x":1635681835000,"y":57.19},{"x":1635680568000,"y":57.13},{"x":1635681051000,"y":57.04},{"x":1635683020000,"y":57.74},{"x":1635683261000,"y":57.49},{"x":1635683322000,"y":57.6},{"x":1635683382000,"y":57.61},{"x":1635683442000,"y":57.71},{"x":1635683503000,"y":57.87},{"x":1635683563000,"y":57.85},{"x":1635683623000,"y":57.73},{"x":1635683684000,"y":57.74},{"x":1635683744000,"y":57.76},{"x":1635683804000,"y":57.76},{"x":1635683865000,"y":57.76},{"x":1635683925000,"y":57.83},{"x":1635683985000,"y":57.67},{"x":1635683201000,"y":57.65},{"x":1635684106000,"y":57.83},{"x":1635684166000,"y":57.7},{"x":1635684226000,"y":57.64},{"x":1635684287000,"y":57.74},{"x":1635684347000,"y":57.8},{"x":1635683141000,"y":57.61},{"x":1635684468000,"y":57.76},{"x":1635684528000,"y":57.77},{"x":1635684588000,"y":57.78},{"x":1635684649000,"y":57.82},{"x":1635684709000,"y":57.65},{"x":1635684769000,"y":57.76},{"x":1635684830000,"y":57.69},{"x":1635684890000,"y":57.92},{"x":1635684950000,"y":57.72},{"x":1635685011000,"y":57.74},{"x":1635685071000,"y":57.78},{"x":1635685131000,"y":57.72},{"x":1635685191000,"y":57.69},{"x":1635685252000,"y":57.78},{"x":1635685312000,"y":57.78},{"x":1635685372000,"y":57.74},{"x":1635685433000,"y":57.73},{"x":1635685493000,"y":57.94},{"x":1635685553000,"y":57.92},{"x":1635685614000,"y":57.91},{"x":1635685674000,"y":57.92},{"x":1635685734000,"y":57.83},{"x":1635685795000,"y":57.78},{"x":1635685855000,"y":57.78},{"x":1635685915000,"y":57.76},{"x":1635685976000,"y":57.82},{"x":1635686036000,"y":57.86},{"x":1635686096000,"y":57.75},{"x":1635686157000,"y":57.84},{"x":1635686217000,"y":57.85},{"x":1635686277000,"y":57.82},{"x":1635686337000,"y":57.89},{"x":1635686398000,"y":57.87},{"x":1635684046000,"y":57.74},{"x":1635686518000,"y":57.83},{"x":1635686579000,"y":57.91},{"x":1635686458000,"y":57.82},{"x":1635683080000,"y":57.64},{"x":1635684407000,"y":57.76},{"x":1635686618000,"y":57.8},{"x":1635686859000,"y":57.8},{"x":1635686919000,"y":57.82},{"x":1635686980000,"y":57.86},{"x":1635687040000,"y":57.78},{"x":1635687100000,"y":57.83},{"x":1635687161000,"y":57.83},{"x":1635687221000,"y":57.92},{"x":1635687281000,"y":57.92},{"x":1635687342000,"y":57.95},{"x":1635687402000,"y":57.83},{"x":1635687462000,"y":57.83},{"x":1635687523000,"y":57.91},{"x":1635687583000,"y":57.86},{"x":1635687643000,"y":57.92},{"x":1635687704000,"y":57.81},{"x":1635687764000,"y":57.95},{"x":1635687824000,"y":57.88},{"x":1635687884000,"y":57.89},{"x":1635687945000,"y":57.84},{"x":1635688005000,"y":57.89},{"x":1635688065000,"y":57.88},{"x":1635688126000,"y":57.81},{"x":1635688186000,"y":57.85},{"x":1635688246000,"y":57.86},{"x":1635688307000,"y":57.87},{"x":1635688367000,"y":57.87},{"x":1635688427000,"y":57.89},{"x":1635688488000,"y":57.75},{"x":1635688548000,"y":57.85},{"x":1635688608000,"y":57.96},{"x":1635688669000,"y":57.89},{"x":1635688729000,"y":57.89},{"x":1635688789000,"y":57.92},{"x":1635688850000,"y":57.79},{"x":1635688910000,"y":57.99},{"x":1635688970000,"y":57.95},{"x":1635689030000,"y":58.03},{"x":1635689091000,"y":57.92},{"x":1635689151000,"y":57.87},{"x":1635689211000,"y":57.94},{"x":1635689272000,"y":57.96},{"x":1635689332000,"y":57.89},{"x":1635689392000,"y":57.78},{"x":1635689453000,"y":57.91},{"x":1635689513000,"y":57.92},{"x":1635689573000,"y":57.83},{"x":1635689634000,"y":57.98},{"x":1635689694000,"y":57.94},{"x":1635689754000,"y":57.85},{"x":1635689815000,"y":58.03},{"x":1635689875000,"y":57.92},{"x":1635689935000,"y":57.96},{"x":1635689995000,"y":57.96},{"x":1635690056000,"y":57.94},{"x":1635690116000,"y":57.99},{"x":1635690176000,"y":57.95},{"x":1635686739000,"y":57.81},{"x":1635686799000,"y":57.86},{"x":1635686678000,"y":57.74},{"x":1635690216000,"y":57.87},{"x":1635690457000,"y":57.91},{"x":1635690517000,"y":58.05},{"x":1635690578000,"y":57.88},{"x":1635690638000,"y":57.92},{"x":1635690698000,"y":57.93},{"x":1635690336000,"y":57.87},{"x":1635690819000,"y":57.94},{"x":1635690879000,"y":57.89},{"x":1635690939000,"y":57.98},{"x":1635691000000,"y":57.96},{"x":1635691060000,"y":58.01},{"x":1635691120000,"y":58.04},{"x":1635691181000,"y":57.97},{"x":1635691241000,"y":57.93},{"x":1635690397000,"y":57.92},{"x":1635691362000,"y":58},{"x":1635691422000,"y":57.92},{"x":1635691482000,"y":57.94},{"x":1635691543000,"y":57.99},{"x":1635691603000,"y":57.96},{"x":1635691663000,"y":57.94},{"x":1635691724000,"y":57.98},{"x":1635691784000,"y":57.92},{"x":1635691844000,"y":58.01},{"x":1635691904000,"y":57.91},{"x":1635691965000,"y":58.11},{"x":1635692025000,"y":57.89},{"x":1635692085000,"y":58.02},{"x":1635692146000,"y":57.98},{"x":1635692206000,"y":58.05},{"x":1635692266000,"y":57.99},{"x":1635692327000,"y":58.09},{"x":1635692387000,"y":57.98},{"x":1635692447000,"y":58.09},{"x":1635692508000,"y":58.23},{"x":1635692568000,"y":58.14},{"x":1635692628000,"y":58.04},{"x":1635690758000,"y":57.93},{"x":1635692749000,"y":58},{"x":1635692809000,"y":58.05},{"x":1635692869000,"y":58},{"x":1635692689000,"y":58.09},{"x":1635692990000,"y":58.09},{"x":1635693050000,"y":58.09},{"x":1635693111000,"y":57.92},{"x":1635693171000,"y":57.97},{"x":1635693231000,"y":58.07},{"x":1635693292000,"y":58.05},{"x":1635693352000,"y":57.99},{"x":1635693412000,"y":58.01},{"x":1635693473000,"y":57.96},{"x":1635693533000,"y":58.04},{"x":1635693593000,"y":58.16},{"x":1635693654000,"y":58.14},{"x":1635693714000,"y":58},{"x":1635693774000,"y":58},{"x":1635692930000,"y":58.06},{"x":1635691301000,"y":57.98},{"x":1635690276000,"y":57.89},{"x":1635693813000,"y":58.02},{"x":1635694055000,"y":58.12},{"x":1635694115000,"y":58.09},{"x":1635694175000,"y":58.18},{"x":1635694236000,"y":58.18},{"x":1635694296000,"y":58.14},{"x":1635694356000,"y":58.12},{"x":1635694417000,"y":58.15},{"x":1635694477000,"y":58.24},{"x":1635694537000,"y":58.09},{"x":1635693994000,"y":58.15},{"x":1635694658000,"y":58.19},{"x":1635694718000,"y":58.23},{"x":1635694778000,"y":58.23},{"x":1635694839000,"y":58.18},{"x":1635694899000,"y":58.26}]]}]

{"x":1635694417000,"y":58.15},
{"x":1635694477000,"y":58.24},
{"x":1635694537000,"y":58.09},
{"x":1635693994000,"y":58.15},
{"x":1635694658000,"y":58.19},
{"x":1635694718000,"y":58.23},
{"x":1635694778000,"y":58.23},
{"x":1635694839000,"y":58.18},
{"x":1635694899000,"y":58.26}

oh, wow - that's a good set of eyes. I guess thats a result of the transformation code, rather than the SQL data result - but I'll go have a look and see if I can find the root of that

Thank you.

And another one:


The human brain is quite good in pattern recognition.
Let the numbers scroll in-front of your eyes and most of us will spot any unusual parts.

I've checked the result from the SQL and as expected it's correct, so it's something so awry in the transformation code - in fact, I've updated the parameters, and I have a duplicate of the timestamp appearing, so something is clearly broken in the code segment - do you have any better (or more common) code to convert the SQL output to an input format suited for the chart node?

Oh, I was wrong - the SQL output was skewed - for some reason the order by wasn't handling the 13 digit timestamp value - so I changed it to sort based on the Unixepoch, and it's perfect now.

I'll give Chris credit for the solution, but do acknowldege Colin's good eyes as well. :slight_smile:
Thank you both.

1 Like

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.