FusionTime - Timestamp duplicate in fusionDataStore.createDataTable(data, schema)

[Pierre_M]

I use FusionTime for ploting time series and it works great but I noticed a bug with FusionTime recently.

As you can see in the attached screenshot, there is a shift in the plot after the 27th of october.

Looking more precisely, it appears that the probleme lays in the method fusionDataStore.createDataTable(data, schema).

My input data are :

const data = [
  ["2019-10-20", 1],
  ["2019-10-21", 2],
  ["2019-10-22", 3],
  ["2019-10-23", 4],
  ["2019-10-24", 5],
  ["2019-10-25", 6],
  ["2019-10-26", 7],
  ["2019-10-27", 8],
  ["2019-10-28", 9],
  ["2019-10-29", 10],
  ["2019-10-30", 11]
];

const schema = [
  {
    name: "Time",
    type: "date",
    format: "%Y-%m-%d"
  },
  {
    name: "Grocery Sales Value",
    type: "number"
  }
];

The result given by fusionDataStore.createDataTable(data, schema)._data is :

[
  [1571522400000, 1],
  [1571608800000, 2],
  [1571695200000, 3],
  [1571781600000, 4],
  [1571868000000, 5],
  [1571954400000, 6],
  [1572040800000, 7],
  [1572127200000, 8],
  [1572217200000, 9],
  [1572303600000, 10],
  [1572390000000, 11]
]

As you can notice, there is a duplicate in the timestamp 1572127200000.

A complete example of the problem is available in this sandbox : https://codesandbox.io/s/fusioncharts-timeserie-bug-example-4pbue?fontsize=14

Maybe a pb with summer/winter time ?

Thanks!

[Akash Biswas]

Hi Pierre,

 

The FT chart in the provided codesandbox sample does not have a shift in the plot after the 27th of October. It is showing the tooltip correctly for the respective plots, you can check the below screenshot of your provided sample :

Also there is no duplicate in the timestamp both the code and the sample provided.

 

Thanks,

Akash.

[Pierre_M]

Hello Akash,

Thank you for you answer.

It is weird because I tried the CodeSandBox on different computers but I still have the same problem. I also noticed the problem on the FusionCharts website (see screenshot enclosed).

On this example, the problem appears after the 26th of october 2014. This date is precisely the day of passing from "summer time" to "winter time" in Europe. This is why I believe the problem is linked to this ( https://en.wikipedia.org/wiki/Summer_time_in_Europe )

Is there something in the code that could explain the problem?

Thanks

Pierre

[Akash Biswas]

Hi Pierre,

 

The same sample in the FusionCharts website we are not getting such issue. Please check the below screenshot :

 

Thanks,

Akash.