Dashboard Tools

[Trucky]

I was wondering if anyone could recommend a 3rd party dashboard tool they are using with Alpha Anywhere connecting to a SQL database.

[Garry Flanigan]

Re: Dashboard Tools

Why not use Alpha? I did this for a client to show records for follow-up based on a due date. Without checking to be absolutely positive, it was based on a page builder with a number of grids, but could easily include other components such as reports.

[Michael1954]

Re: Dashboard Tools

Qlik connects to SQL databases and it has a free version.

But


You can do lot's of sexy things with the list control.

Check out snaking layout in the freeform.

You can also use panels



Panels to generate a dashboard.png

[Trucky]

Re: Dashboard Tools

Thanks for the comments. I agree Alpha is an option and I might end up doing that. I will look at Qlik and some other similar applications.

[njguy]

Re: Dashboard Tools

Also look at HighCharts ( http://www.highcharts.com/demo)

[Steve Workings]

Re: Dashboard Tools

If you're considering highcharts and a license, Fusioncharts might also be attractive.

[Pat Bremkamp]

Re: Dashboard Tools

I also use FusionCharts and since they use JSON and Alpha now has some excellent tools for JSON, it is quite easy to use.I have about 10 charts that the managers use daily.

[Michael1954]

Re: Dashboard Tools

Google charts are free and I have the xbasic for most charts.


Let me know if you would like a sample.

[Michael1954]

Re: Dashboard Tools

Pete problem getting back to you please use [email protected]

[Michael1954]

Re: Dashboard Tools

function drawChart() {


var graph = [
['Year', 'White', 'Red'],
['1929', 2, 0],
['1934', 6, 0],
['1937', 6, 0],
['1938', 6, 0],
['1943', 2, 0],
['1945', 6, 0],
['1946', 3, 0],
['1949', 6, 0],
['1953', 2, 0],
['1955', 6, 0],
['1957', 0, 2],
['1959', 0, 3],
['1960', 0, 1],
['1962', 5, 0],
['1963', 0, 2],
['1964', 0, 5],
['1965', 2, 6],
['1966', 0, 1],
['1968', 0, 10],
['1970', 0, 16],
['1971', 0, 1],
['1972', 0, 3],
['1974', 0, 2],
['1975', 6, 1],
['1976', 4, 5],
['1977', 1, 12],
['1978', 0, 1],
['1979', 0, 2],
['1980', 0, 1],
['1981', 0, 3]
]
// above is the return format I want from xbasic

graph = ({dialog.object}._data);
var data = google.visualization.arrayToDataTable(graph);

var options = {
title: 'Wine 2000-2014',
curveType: 'function',
legend: { position: 'bottom' }
};

var chart = new google.visualization.LineChart(document.getElementById('curve_chart'));

// here is where we play with onclick note you can mix "Alpha" with "Google"

function selectHandler() {
var selectedItem = chart.getSelection()[0];


if (selectedItem) {
var colour = selectedItem.column;
var year = data.getValue(selectedItem.row, 0);
var W_Qty = data.getValue(selectedItem.row, 1);
var R_Qty = data.getValue(selectedItem.row, 2);
var wine = ""
wine = "Red"
qty = R_Qty;
if(colour == 1) {
wine = "White"
qty = W_Qty
}

{dialog.Object}.setValue('Year',year );
{dialog.Object}.setValue('Colour',wine );
{dialog.Object}.setValue('Qty',qty );


//alert('The user selected ' + year + ' style ' + wine);
}
}

google.visualization.events.addListener(chart, 'select', selectHandler);






chart.draw(data, options);
}

[Michael1954]

Re: Dashboard Tools

{dialog.object}._data

Comes from the xbasic

dim sql as c
sql = <<%txt%
SELECT DISTINCT
wines.`Year`,
Sum(if(Color = "Red" , LEFT(wines.Quantity, (locate('x', wines.Quantity) - 1)) , 0 )) AS Red,
Sum(if(Color = "White" , LEFT(wines.Quantity, (locate('x', wines.Quantity) - 1)) , 0 )) AS White,
concat("['", wines.`Year` , "', ", Sum(if(Color = "White" , LEFT(wines.Quantity, (locate('x', wines.Quantity) - 1)) , 0 )) ," , ",Sum(if(Color = "Red" , LEFT(wines.Quantity, (locate('x', wines.Quantity) - 1)) , 0 )) , "]") AS rs
FROM wines
WHERE
wines.`Year` < 2014 AND
wines.`Year` <> 'NV' AND
wines.`Year` >= 2000
GROUP BY
wines.`Year`
ORDER BY
wines.`Year` ASC

%txt%

dim cn as sql::Connection
cn.open("::Name::MySQL_Wine")
dim flag as l
flag = cn.Execute(sql)
dim rs as sql::ResultSet
rs = cn.ResultSet
dim template as c


'here is the Google format just to help me
'[['Task', 'Hours per Day'],
'['Work', 11],
'['Eat', 2],
'['Commute', 2],
'['Watch TV', 2],
'['Sleep', 7]];


debug(1)

template = "['{js_escape(ds.data("Year"))}',{ds.data("White")}, {ds.data("Red")}],"

dim txt as c

txt = a5_mergedataintotemplate(template,rs)

txt = rtrim(txt,",")

txt = "[['Year', 'White', 'Red']," + txt + "]"



dim js as c
js = "{dialog.object}._data = " + txt + ";"

e.javascript = js

[Michael1954]

Re: Dashboard Tools

Screenshots of the code in a browser



Pete message reply.png

[Trucky]

Re: Dashboard Tools

Many thanks, Michael, I'll give Google charts a go and thanks to everyone else. I do have a Fusion Charts licence from a few years ago so I will also revisit it.

[Steve Workings]

Re: Dashboard Tools

John - FusionCharts has upgraded everything to be all Javascript. Kinda like Alpha, if it's something you bought 5 years ago then you'll want to get all updated first.

[nxlcomputers]

Re: Dashboard Tools

Steve,

I dropped a question for you on a thread over in the ver11 forum. I had a question on getting FusionCharts to render on the server.

https://www.alphasoftware.com/alphaf...t=fusioncharts

Andrew