Alpha Anywhere 2.0 - Using Google Charts as an Alternative to the Built-in Chart Controls

Adding Client-Side Charts to Your Business Intelligence Dashboards with Alpha Anywhere and the Google Chart AP

business intelligence dashboards, alpha anywhere
In Alpha Anywhere, the UX Component contains a powerful built-in chart control (based on the Microsoft .NET visualization library) which enables the creation of robust business intelligence dashboards fast.

This is a 'server-side' control, meaning that the chart is rendered on the server and then the resulting image is sent to the browser. However, there may be times when you want 'client-side' charting (i.e. charts that are rendered using JavaScript).

The Google Chart API is perfect for this. (Note: There are number of high quality open source JavaScript libraries that you can choose from).

In this video we show how you can use the Google Chart API to add client-side charts to your UX component-created business intelligence dashboards.

Watch the video:Part 1, Part 2

Using SQL data in a Google Chart

In previous videos we have shown ho easy it is to use Google Charts in a UX component by simply copying code from the Google Charts API documentation. However, in all of the example in the Google Chart API documentation, the data plotted by the chart is static (i.e. it is hard coded into the Javascript).

Of course, in a real application, it is likely that you will want to query a SQL database to get the data to be plotted on the chart. In this video we show an example of how this can be done.

Watch Video - Part 1
Watch Video - Part 2
Watch Video - Part 3
Download Component 
Alpha Anywhere 2.0 - UX Component - Powerful Client-side Grouping and List Navigator
Enhancements to the code editors in Alpha Anywhere 2.0

About Author

Richard Rabins
Richard Rabins

Co-founder of Alpha Software, Richard Rabins focuses on strategy, sales, and marketing. Richard also served as CEO of SoftQuad International from 1997 to 2001, when it owned Alpha. In addition to his 30 years with the company, Richard played a key role as co-founder, and served as president and chairman of the Massachusetts Software Council (now the Massachusetts Technology Leadership Council), the largest technology trade organization in Massachusetts. Prior to founding Alpha, Richard was a project leader and consultant with Information Resources, Inc. (IRI), and a management consultant with Management Decision Systems, Inc. Richard holds a master's degree in system dynamics from the Sloan School at MIT, and a bachelor's degree in electrical engineering and master's degree in control engineering from University of the Witwatersrand in Johannesburg, South Africa. He has served on the boards of Silent Systems, Legacy Technology and O3B Networks, and is co-founder of Tubifi

Related Posts
New: Alpha Anywhere
New: Alpha Anywhere "Developer2Developer" Interview Series
Alpha Software Named Top 20 App Development Software
Alpha Software Named Top 20 App Development Software
Mobile Apps for Vital Gas and Electrical Safety Inspections
Mobile Apps for Vital Gas and Electrical Safety Inspections


Subscribe To Blog

Subscribe to Email Updates