Hey there, Awesome Customers!

Just a heads up: We'll be taking a breather to celebrate International Workers' Day (May 1st and 2nd - Wednesday and Thursday) and Orthodox Easter from Good Friday (May 3rd) through Easter Monday (May 6th). So, from May 1st to May 6th, our team will be off enjoying some well-deserved downtime.

During this time, our customer support will be running on a smaller crew, but don't worry! We'll still be around to help with any urgent matters, though it might take us a bit longer than usual to get back to you.

We'll be back in action at full throttle on May 7th (Tuesday), ready to tackle your questions and requests with gusto!

In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find loads of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel). These gems might just have the answers you're looking for while we're kicking back.

Thanks a bunch for your understanding and support!

Catch you on the flip side!

Warm regards,

TMS

Okay
  Public Ticket #2758531
Empty Values Blank Instead of Zero
Closed

Comments

  • Edmund Keith started the conversation
    April 23, 2021 at 7:43am

    Hi Guys, 

    You mention in the 1.7.1 release articles that there is now support for empty values: "Previously, when working with Integer, or Float columns, whenever you had an empty cell it was automatically converted to zero value. It didn’t always work for all of the tables, as sometimes no value just means no value – and not a zero – so we implemented support for blank values for all kind of tables. Sorting is still working, they are treated as ‘negative infinity’."

    The only problem is it's not clear how to actually implement this. I have a line graph with null values that need to be null. I have tried everything in the options to make this happen with no luck.

    The only thing I could find on this was a user ticket from October (https://tmsplugins.ticksy.com//ticket/2557131/) which suggested that the only way to do it was to edit the code and change a setting or two. Is there an easier way (like some sort of tick box option)? If not, can you please run me through exactly how to make null values disappear rather than revert to 0. 


    Many thanks

  •  2,499
    Aleksandar replied
    April 23, 2021 at 3:38pm

    Hello Edmund

    Thank you for your purchase.

    When charts are concerned, unfortunately, this is still the only way to use NULL values in a chart.

    You can also check out this ticket for more details: https://tmsplugins.ticksy.com/ticket/2640252/

    Basically, you'll need to use wpDataCharts callbacks on the page.

    • Every chart exposes several options that customize its look and feel. Charts usually support custom options appropriate to that visualization. wpDataChart callbacks allow adding options that are available in Google Charts API, Highcharts API, and Chart.js API. 
    • All necessary resources are available in charts engines API (depends on which one you use). Every engine has a different approach to chart settings. In wpDataChart callbacks, you have to adopt those settings to the wpDataChart object (you can take a look at examples for each engine in our documentation, and also in the Support help center). A huge number of examples for any area of programming can be found on stackoverflow.com (typing your problem in google and at the end add "site: stackoverflow.com" and Google will search only that website). Also, a lot of examples of charts, chart settings, and customization can be found on jsffidle.net (typing in google for example "line chart highcharts jsffidle")
    • Please note that using hooks or wpDataTable and wpDataChart callbacks requires a certain level of programming skills and included support refers only to advice.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

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

    Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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

  • Edmund Keith replied
    April 26, 2021 at 7:30am

    Hi Aleksandar.

    Thanks for getting back to me.

    I'm not a developer and although I used to do a bit of HTML and some python, I am pretty lost when it comes to JS. I might be able to figure out the code snippet itself, but I wouldn't even know how to access the JS file to edit it, or where to insert the snippet in the file.

    Is it on your guys' road map to add a drop-down option for null values? I like the product you guys have made, but this does seem like a bit of an oversight, especially given that Google Data Studio (which I imagine uses the same engine as your Google charts) has the option to render null values either as line breaks, as 0 or use linear interpolation.

  •  2,499
    Aleksandar replied
    April 27, 2021 at 9:15am

    Hello again Edmund

    We use free libraries of chart engines, and they don't have all options paid engines do, so changes need to be made using wpDataChart callbacks, which, unfortunately, do require some coding skills.

    Google Data Studio is Google's, as well as Google charts, so it's rather expected that they are using full support for their own charts. Our developers will work on more options when it comes to wpDataCharts, but I don't know when or even if this will be added as a drop-down option, but I can promise that I will forward it to our development team for review.

    You can also add it as a feature suggestion on this page, so our developers receive a vote from a customer in this regard. More votes a suggestion receives, more likely it will be developed sooner.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

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

    Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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

  • Edmund Keith replied
    April 27, 2021 at 9:53am

    Thanks, Aleksandar. I appreciate you being honest in the reply.

    I've filled in the suggestion form and will keep my fingers crossed. For now, I'm just going to screenshot a Google Data Studio chart and put it in my Wordpress post.

  •  2,499
    Aleksandar replied
    April 27, 2021 at 12:52pm

    You're welcome, Edmund

    Sorry I couldn't be of more assistance here, but I am glad to hear that you found a workaround that will work for you.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

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

    Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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