Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 05/09/2017 BIG Autumn SALE

    Use AUTUMN17 coupon code to buy our WordPress or Joomla! extensions with 25% discount. Hurry up! The offer is valid till 11 September.

  • 14/04/2017 Happy Easter

    Wish a Happy Easter and give 30% discount for all our WordPress and Joomla! extensions. Use EASTER17 coupon code. The offer is valid till 17 April.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

Pie Chart How-To
(1 viewing) (1) Guest
Go to bottomPage: 12
TOPIC: Pie Chart How-To
#56659
Pie Chart How-To 1 Year, 9 Months ago Karma: 0
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.
The administrator has disabled public write access.
 
#56662
Re:Pie Chart How-To 1 Year, 9 Months ago Karma: 667
Hello,

Try to use the following SQL query:

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

Regards,
ARI Soft
The administrator has disabled public write access.
 
#56679
Re:Pie Chart How-To 1 Year, 9 Months ago Karma: 0
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.

Last Edit: 2016/01/06 13:32 By Kskalous.
The administrator has disabled public write access.
 
#56682
Re:Pie Chart How-To 1 Year, 9 Months ago Karma: 667
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
The administrator has disabled public write access.
 
#56684
Re:Pie Chart How-To 1 Year, 9 Months ago Karma: 0
email sent! thanks!
The administrator has disabled public write access.
 
#56685
Re:Pie Chart How-To 1 Year, 9 Months ago Karma: 667
Try now please.

Regards,
ARI Soft
The administrator has disabled public write access.
 
Go to topPage: 12