Hey everyone!

With the holiday season upon us, we want to share our upcoming working hours:

After that, we’ll return to our regular schedule and assist you as quickly as possible.

In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find tons of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel), which might just have the answers you need while we’re away.

Thanks a bunch for your understanding and support!

Warm regards and happy holidays!

TMS

Okay
  Public Ticket #3486713
bad display wpdatacharts
Closed

Comments

  • Gurtner started the conversation

    Hello,

    I can't display the following graph correctly: (google chart)
    In the creation module wpdatachart I see this:

    6767466311.png

    fig: one

    and when I try to display the graph in the article, I see this :

    9814839446.png

    fig: two

    it only displays the first day instead of the 60 years of data

    It does the same thing with a different style of graph

    The graph comes from a csv file imported into wpdatatable with around 4000 lines. The table is displayed without any problem.
     I've looked to see if there's a way to influence the x axis, but I can't find it. Can you help me?

    Thanks 

    André

    Attached files:  one.png
      two.png

  •   Gurtner replied privately
  •  1,847
    Miloš replied

    Hi André,

    Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

    -

    I am delighted to hear that this has been resolved. 

    Thank you for letting us know.

    I am not sure what you modified exactly for the date Format, 

    but that is the default behaviour of the Chart Engine with our Table data.

    -

    I can just try to guess, since you said you have imported the CSV, i guess that was a Manual Table after that ?

    I will advise on how the charts pick up the number of rows from a connected Table in terms of "Table Pagination", and i hope that might help for any future issues like this.


    The charts are being created based on tables. If the table has our server-side processing enabled, 

    then only the rows shown in the table will be loaded on the chart.

    If the table is non-server-side, the chart will load all the rows, unless we enable "Follow table filtering" with the table on the same page.

    -

    Basically, if you have a Manual table; they have automatically server-side enabled, we can't disable it.

    So you would have to make another SQL Query based table, to pull data out of the Manual Table;

    then you have to disable server-side processing for it;

    and disable "Follow table filtering" - then the chart will load all rows ( if needed).

    -

    Or if it is a non-editable/non server side Table like Tables linked from a source file,

    for them the Chart always loads all rows in its data.


    In either case, we can see you found a workaround by editing the Date Format,

    we are glad to see that works for your use-case.

    Anything else that we could assist with, please don't hesitate to create new tickets.

    Thank you.

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables