We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

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,576
    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,576
    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,576
    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