I have a working Data Table connecting to a remote Db and all is working well for my intended use (awesome tool btw!)

I have a game that logs chats to a text file. I've written a parser that parses this chat log, and puts the data into a mysql DB. I then use ARI Data Tables to display that chat log on the front page of the site. Working great for that purpose.

I'd like to take this same DB and chart the 'top talkers' in a pie chart. All I get is either 'no data' or blank charts. I'm confused as to the settings required to get this to work.

www.f99th.com/index.php is the chat log.

I only have 4 columns in the DB
ID
user
MessageDate
Message

I'd like to show in a pie chart the breakdown of chat messages per user.

Hello,

Try to use the following SQL query:

SELECT
user,
COUNT(*) AS MessageCount
FROM
tbl
GROUP BY
user

Regards,
ARI Soft

Thank you. I have a chart being displayed now..

But "MessageCount" is now taking up 100% of the pie. It is not broken down per user.

Could you send an SQL dump of your table and screenshot(s) of module settings page by email or send a link to a page where pie chart is used and a temporary access to your J! backend?

Regards,
ARI Soft

email sent! thanks!

Try now please.

Regards,
ARI Soft