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 #2845789
Total not working with group by
Closed

Comments

  • Tan started the conversation
    August 10, 2021 at 9:17am

    The calculation for total of a column was not working correctly when SQL source contain group by. You may refer to attachment for my sql script and the generated output.

    Thank You,

    YY

  • [deleted] replied
    August 11, 2021 at 1:57pm

    Hi Tan,

    thank you for reaching out to ussmile.png

    If the wp_ source (SQL ID) matches, please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just make sure to mark the reply as PRIVATE so that nobody can see it except us.

  •   Tan replied privately
  • [deleted] replied
    August 13, 2021 at 1:16pm

    Hi Tan!

    Thank you so muchsmile.png 

    I tested several options however, none with satisfactory results - it still sums only the value of the row where id is 1 as it grouped per id. My senior colleague would like to check out this case, so I have forwarded it to him. He will contact you as soon as possible.

  • Tan replied
    August 14, 2021 at 4:05pm

    Hi Ivana,

    I've figured out the solution by constructing MySQL view using join and group by statement. The calculation is working fine now.

    Cheers!

  • [deleted] replied
    August 15, 2021 at 2:15pm

    Hi Tan,

    thank you for letting me know that you've found a solutionsmile.png

    If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.