Alpha Software Blog

Alpha Anywhere 2.0 - Using Google Charts & 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 - 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 Webinar: How to Integrate ChatGPT with Alpha Anywhere
New Webinar: How to Integrate ChatGPT with Alpha Anywhere
Best Data Collection Software For Manufacturing [2023]: A 101 Guide
Best Data Collection Software For Manufacturing [2023]: A 101 Guide
Quickly Build High Performing Apps with New JSONForm in Alpha Anywhere
Quickly Build High Performing Apps with New JSONForm in Alpha Anywhere

The Alpha platform is the only unified mobile and web app development and deployment environment with distinct “no-code” and “low-code” components. Using the Alpha TransForm no-code product, business users and developers can take full advantage of all the capabilities of the smartphone to turn any form into a mobile app in minutes, and power users can add advanced app functionality with Alpha TransForm's built-in programming language. IT developers can use the Alpha Anywhere low-code environment to develop complex web or mobile business apps from scratch, integrate data with existing systems of record and workflows (including data collected via Alpha TransForm), and add additional security or authentication requirements to protect corporate data.