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 #2413188
CreateingTables from CTPs
Closed

Comments

  • Reinhard started the conversation

    Dear Support

    i created an Invoice (CustomPostType) with fields, like Invoice Positions. I love to create now a Pie Chart, with Amount of open Invoices and paid Invoices.

    But without a Amount Filed. Because i do calculate the total Amount every time i create a PDF Invoice.

    So i think i have to deserialize those Fields somehow.

    Maybe with a Formula Column?

    I'm now also trying to filter alle for just to see "invoice"-type.

    Do you have any Manual about this. So i know how to do this?

    Thanx a lot in adv.

      Reinhard

  • Reinhard replied

    I also can not create a Donat-Chart :-(

  •  2,576
    Aleksandar replied

    Hello Reinhard

    To create charts, you need integer or float columns, while only one string-type column should be used for axis labels

    I see that your table contains a lot of serialized data, and you need to unserialize that before you can put it to use.

    I cannot tell you how to do that since that can be achieved with customization, and custom queries. Those queries can be run in the database, by creating a view; or from within the plugin. If you go for the view, you need to create a view, and in the plugin's UI create a new SQL query based table with

    SELECT * FROM viewName

    This is all custom, and unfortunately I can't help you with it. Please take a look at charts on our documentation and sandbox sites, and see how they look like. You can also try prepairing a manual table with simple values to verify the charts do actually work.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    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