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


Recent Events
  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


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?

How to Make Pie/Bar Charts from ARIDataTables
(1 viewing) (1) Guest
Go to bottomPage: 1234
TOPIC: How to Make Pie/Bar Charts from ARIDataTables
#47898
Re:How to Make Pie/Bar Charts from ARIDataTables 10 Years, 4 Months ago Karma: 0
duh, What is appropriate format when I do not control the format coming from the MySQL database?
The administrator has disabled public write access.
 
#47899
Re:How to Make Pie/Bar Charts from ARIDataTables 10 Years, 4 Months ago Karma: 748
It is not possible to show graph based on data from a database if it is not formatted as it is required for graph.

It is possible to use "SQL -> Revert data" parameter to transform the following data:

Code:


#     | col1    | col2    | col3 

val 1 | val 1-1 | val 1-2 | val 1-3

val 2 | val 2-1 | val 2-2 | val 2-3



in the following way:

Code:


#     | val1    | val2    

col1  | val 1-1 | val 2-1

col2  | val 1-2 | val 2-2

col3  | val 1-3 | val 2-3



Regards,
ARI Soft
The administrator has disabled public write access.
 
#47900
Re:How to Make Pie/Bar Charts from ARIDataTables 10 Years, 4 Months ago Karma: 0
I already tried the the revert thing for SQL, it did nothing.

I am sorry, but you keep saying "formatted for graph" without defining what the correct format is and ignoring my requests about a guide or documentation. How is the base product able to create a valid table yet not graph that same data. I really don't get that. Table and graph are one in the same, just different views on the same data.

Look at my screen grab, what can possibly be wrong with such a simple dataset tailored specifically to creating a PIE chart. 6 regions of the world, each with a unique numerical amount associated.

If it cannot create a PIE on that how does it work for more complex data? I always tackle such things in steps. Get things working for simple then expand from there.
The administrator has disabled public write access.
 
#47901
Re:How to Make Pie/Bar Charts from ARIDataTables 10 Years, 4 Months ago Karma: 748
Send SQL dump of table(s) with a sample data which you use in the SQL query and screenshot(s) of module settings page by email so we can investigate the problem.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#47903
Re:How to Make Pie/Bar Charts from ARIDataTables 10 Years, 4 Months ago Karma: 0
Just sent via email.
The administrator has disabled public write access.
 
#47923
Re:How to Make Pie/Bar Charts from ARIDataTables 10 Years, 4 Months ago Karma: 748
Check your mail please.

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