Hey there, Awesome Customers!

Just a heads up: Our team will be out of the office on Monday, November 11th in observance of Armistice Day, but don’t worry—we'll be back in full swing on Tuesday, November 12th.

In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find tons of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel), which might just have the answers you need while we’re away.

Thanks a bunch for your understanding and support!

Warm regards,

TMS

Okay
  Public Ticket #1258009
count rows/pivottable function
Closed

Comments

  •  1
    darkallstar started the conversation
    July 30, 2017 at 6:09am

    is there a way to calculate row count to then be graphed? Or must it be done in sql?

  • [deleted] replied
    July 31, 2017 at 9:41am

    Hi darkallstar,

    Unfortunately not at this moment. it must be done on MySQL side. To prevent collisions with other table functions it would be the best to create MySQL VIEW from query that contains MySQL functions and use that as data source.