Support » Plugin: wpDataTables - Tables & Table Charts » Summary or Pivot style table?

  • Resolved markmidmo

    (@markmidmo)


    I have a table that I’ll gladly convert to your product if you have the option I’m needing.

    This table is raw data containing individuals, the date of the competitions they participated in and scores. The current data is over 4,000 rows with a couple hundred unique individuals.

    I’d like to be able to present the individuals and their total points scored, with highest at the top, descending. Rarely would anyone look back at the raw data – though it would be needed.

    Data is added on-going at random times so can’t control when data needs refreshed.

    Historically we’ve done it in Excel and used a pivot table to create the summary, then uploaded that. That solution works but doesn’t not give us real-time updates as fly records are coming into the coordinator.

    Can any of your product or add-ons do this?

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Hello Markmidmo
    I do something the same as you but use and report via Microsoft Access and then use the paid version of wpDataTables to display the records.. currently 55000 rows of data with 10 fields and 1500 individuals … works perfectly via SQL.

    Plugin Author wpDataTables

    (@wpdatatables)

    Hello there.

    Thanks for reaching out.

    It sounds like rather simple table, and like @alexanderweb mentioned – if you have a lot of data, you could store it in the database, and use SQL Query based tables to pull that data and display it in tabular form.

    Linking to existing data source like Excel, CSV or Google Spreadsheet works only up to a certain number of rows (no exact number, but 2.000 – 3.000 is a good guess). After that, the tables start to slow down, and will eventually break. Also, the tables linked to existing data source are not editable.

    Kind regards.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Summary or Pivot style table?’ is closed to new replies.