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 #2916218
How to create a chart
Closed

Comments

  • Eventik started the conversation

    Hi, 

    I was wondering how to create a chart for a specific product to show in front, how many products were sold in each day. 

  •  472
    Isidora replied

    Hi Eventik,

    Thank you for your purchase.

     Sorry for the late response, we have some agents that have contracted Covid-19, so our team is cut in half.

    You will need to create table for example that contain one string column(days) and all other have to be integers(each product) Like

    Date             Product1         Product2...

    01.01.2021        10                     5

    02.01.2021        11                     12

    ....

    If you have that data in database then you will need to create query that will return data in that format so you will be able to create chart like you need.

    Please be advised that preparing MySQL queries for you is not included in the plugin support.

    Best regards

    Kind Regards, 

    Isidora Markovic

    wpDataTables: FAQFacebookTwitterFront-end and back-end demoDocs

    Amelia: FAQFacebookTwitter |  Amelia demo sites | Docs

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

    Powerful FiltersGravity Forms Integration for wpDataTablesFormidable Forms Integration for wpDataTables

  • Eventik replied

    Hi, 

    If you look below I have three products and I would like to see the sales of each products individual on the day. The products are in woocommerce. But this one I manually created. How do i create wordpress query to create a table that constantly feeds data from the products. I see so many options but I dont know how to do it

    2342744640.png


  • Eventik replied

    How do I create a table like this from below?. 

    Date             Product1         Product2...

    01.01.2021        10                     5

    02.01.2021        11                     12

    ....


    4594667600.png
  •  472
    Isidora replied

    Hi Eventik,

    Thank you for your purchase.

    Sorry for the late response, we have some agents that have contracted Covid-19, so our team is cut in half.

    You can try to get data what you need with but choosing properties from post types that you need with our query constructor.

    Please note: this tool is not an ultimate query generator. It simply constructs a suggestion of a query. We are constantly working to improve it, but SQL is such a complicated and flexible language that full automation for constructing queries is next to impossible. Consequently, the more complicated the query, the higher is the probability that it will not return exactly what you need. So, you will often need to play around with the resulting query.

    If it is not returning data that you need you will need to make custom query to return data that you need.

    Please be advised that preparing MySQL queries for you is not included in the plugin support.

    You can check out a lot of examples how to create query to retrieve products from woocommerce on web or to get orders by day and probably you will need to adopt it for your needs.

    Best regards.

    Kind Regards, 

    Isidora Markovic

    wpDataTables: FAQFacebookTwitterFront-end and back-end demoDocs

    Amelia: FAQFacebookTwitter |  Amelia demo sites | Docs

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

    Powerful FiltersGravity Forms Integration for wpDataTablesFormidable Forms Integration for wpDataTables