Hi,

Could you please provide me with the code for highcharts to parse a wpdatatables datetime column or provide a viable alternative for using dates & times in highcharts?

I have date & time variable data and I cannot find how to get high charts to interpret the wpdatatables datetime column as a time value and not a category. Google charts does a fine job of spacing data according to their respective temporal variances. 

Date format is "d Mon Y" and time format is 24hr. All times are in UTC.

Thanks!

Hey Milan!

Thanks for getting back to me! No worries on reply time, I'm a bit slow myself these days.

To restate: I want to use highcharts but with a datetime x axis. That's pretty much it. It seems like this should work if I only use date and not time. However, it seems like this "just works" with google charts, the graph is just not as readable as highcharts. I've attached 2 screenshots that might help show what I'm trying to do.

The reason I think this is a TMS thing, rather than just a highcharts thing is because it seems like the "datetime" data type should produce roughly similar behavior across all rendering engines and not be categorical on one engine but temporal on another. With that said, I think the solution will be some highcharts options. 

Thoughts?

Here's the code I have so far:

if (typeof wpDataChartsCallbacks == 'undefined') {

    console.log("wpDataChartsCallbacks Undefined");
    wpDataChartsCallbacks = {};
}
function general_highchart_format_callback(obj) {
    console.log("...callback 2 found");
    console.log(obj);
    obj.options.xAxis.type = "datetime";
    obj.options.xAxis.tickInterval = 8640000;
}
wpDataChartsCallbacks[2] = general_highchart_format_callback;

Thanks again for the help!

Hey Milan,

Apparently I can't attach sql docs and trying to do so from mobile deletes the chat message (or did for me anyway). Since this is the 2nd time I'm writing this I'll jump more to the point:

The chart is likely going to be impossible for you to reproduce exactly (especially since I can't share sql with you). However, I would hypothesize that any highcharts spline chart made with a datetime column for the x axis will have the same behavior.

If you'd like to see the chart in question, you can make an account at https://moodrecordor.org. It's free and should be straightforward but since we are still developing this, reach out to me if you have any troubles. If you'd like an admin account, let me know when a good time to arrange a call would be and I can walk you through the various layers in use.

To answer your questions:

yes, the table is on the same page as the chart.

yes, follow table filtering is enabled.

Other problems for reproducibility:

This app apparently requires a custom sql view as the wpdatatables plugin causes 500 errors when using more than about 20 columns from the wp database. Additionally the sql generated by the wpdt gui requires editing to change INNER JOIN statements to LEFT JOINs; otherwise no data is displayed and the site also crashes.

Thanks again for the help and let me know if you want me to elaborate on anything!

- Seon

Hey Milan,

First off, thank you for all the work you're putting into this! I really appreciate the effort to get this issue resolved.

Secondly, I'm so sorry about the link. In my haste, I misttyped the url. It's https://moodrecorder.org, with an "er".

Lastly, it looks like your tests are producing the expected result but are not testing the case I'm trying to solve. Try using that same test but make the time between the dates vary (i.e. not always 1 day apart).

For example, one date could be 7 days ago, the next could be 6 days ago, and the 3rd could be today. The hypothesis is that the distance between the points for t+7d and t+6d is the same as the distance between t+6d and t; while the correct behavior would be for t+7d <-> t+6d (1 day) to be 6 times shorter than t+6d <-> t (6 days). In other words what I'm seeing is that the space between points on the graph is always the same, regardless of the time between those points.

If you want a more detailed explanation, I can record a video but I doubt it's necessary, your test environment is pretty much there.

And yeah, I saw that bit about the mysql query before; I only include the part about LEFT JOINS if you wanted to pass the feedback along to whoever works on that generation :)

Thanks again!

- Séon

Hey Aleksandar!

Thanks for the reply and sorry for the late response!
My team and I are working to rebuild the table interface and offload the query to another server with it's own database. Once that's done I'll shoot you a link that you should be able to use for replicating the data from a json response along with a video on how to use it and the problems present.

Thanks for your patience while I work through all this :)

- Séon