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 #889622
Creating Table/Query to display a sports standings table
Closed

Comments

  •  3
    Jason started the conversation

    I'm using wpDataTables to display the scores for the upcoming college wrestling season

    (seen here: http://www.mattalkonline.com/2016-17-college-dual-meet-scores/)

    What I want to do with this data is to create standings (or sports tables) that display the total wins and losses of each team. I did this last year on my site using an embed of a google spreadsheet, but I believe a database would be more flexible. 

    Are there queries out there that will total the wins and losses by team (or total up each name in each field and total it and display like a win-loss record?)

    Here is last year's embed. http://www.mattalkonline.com/college-wrestling-standings-15-16/

    My sheet last year was in Google Sheets, so I ran formulas to tabulate them. Is anyone here familiar on how to do that or if wpDataTables can handle it?

    If wpDataTables can't handle it, I might just be better off doing it the old way. I love this plugin, and I'm a novice with MySQL though, so the learning curve has been tough. Appreciate any input.

  • [deleted] replied

    Hi Jason,

    Our plugin are capable of showing most of the results that you can get in database management software like phpMyAdmin or Workbench. 

    MySQL is supporting some of mathematical operations as well as aggregate functions but please keep in mind that if you are using functions in your queries we are strongly suggesting you to use MySQL VIEW.

    You should be able to find appropriate queries or at least parts of it on web and if can't manage it yourself we can offer you to hire one of our developers to help you with it as paid customization service.