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?

Formatting Numbers from DB
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Formatting Numbers from DB
#51810
Formatting Numbers from DB 9 Years, 5 Months ago Karma: 0
im formatting the numbers that im getting from the database and its working for the data tables (500000 > 500,000) however its not working for the charts

is there a way to format the numbers in the tooltip for charts?
The administrator has disabled public write access.
 
#51820
Re:Formatting Numbers from DB 9 Years, 5 Months ago Karma: 746
Hello,

Could you provide a link to a page with the chart and an image where we can see what do you want to achieve?

Regards,
ARI Soft
The administrator has disabled public write access.
 
#51825
Re:Formatting Numbers from DB 9 Years, 5 Months ago Karma: 0
unfortunately its on an internal server but this is what the data looks like once its returned from the database:

Code:


Name   Bud.    Act.   Diff.
A      952       958      -6
B      150,618   156,424  -5,806  
C      15,298    16,813   -1,515  
D      185,290   185,709  -419  



it works perfectly in the data tables but its not working in the GCharts
its mistaking 150,618 for 150.618 (with a decimal)

so my question is... is it possible to format numbers on the GCharts so that it shows commas and is it possible to also add in a prefix like '$'
Last Edit: 2014/10/21 13:22 By jptarry.
The administrator has disabled public write access.
 
#51832
Re:Formatting Numbers from DB 9 Years, 5 Months ago Karma: 746
If you use "ARI GChart" widget. See "Choose table type -> ARI GChart -> Formatters" parameters section. For example set "Choose table type -> ARI GChart -> Formatters -> Column index" parameter to 1, "Choose table type -> ARI GChart -> Formatters -> Type" parameter to "Number" and populate "Choose table type -> ARI GChart -> Formatters -> Additional parameters" parameter with the following content:

Code:


prefix=$
decimalSymbol=,



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