chart multi column data

[Cristiano]

Hi,

I need to create a series of graphs based on a table of historical data with Alpha Five V11. I created a form based of the data on a table that are searched by some variables. I have filtered the records and returns the result. Now my problem is that I do not able to create charts obtained by this selection. Can anyone tell me where I'm wrong?

[Stan Mathews]

Re: chart multi column data

Your attachment contains the test workspace definition but not the table or its support files. The table seems to be stored in another directory (not a good practice).

[Cristiano]

Re: chart multi column data

Hi Steve ,

Thank You your reply,

on effect during the duplication of the workspace I forgot to duplicate also the table.
you can find on the new attach

[Stan Mathews]

Re: chart multi column data

I see two fields graphed, what is it you want to do?


graph.png

[Cristiano]

Re: chart multi column data

Hi Steve,

The table is the historical data of a Company from year 2005 to 2011 (and than will be 2012 ; 2013; 2014 and so on ) When search using the combo boxor the supplier or client or month or the year I need to see the graphic of two field named :FATTURATO and GRANDTOT . As I do not see any other manual or seminar for to understand how work the Chart data component, I thought I had to use 2 fields with multiple colum for chart . It's wrong ?

[Tom Patten]

Re: chart multi column data

Go to Chart Properties and goto "Data Columns" and define your data there.

~ Tom

[Cristiano]

Re: chart multi column data

Hi Tom,

is not so easy like you say .The chart have to represent the query result arising from the four research variables and it's just Because I do not know this component that I'm not in a position to obtain a satisfactory result . I tried many times but with poor results

[Tom Patten]

Re: chart multi column data

I needed to create a dashboard showing the past 6 months of data. I ended up creating a new dbf table just for the charts. I then fill the table as needed by the user to refresh the data.

[Cristiano]

Re: chart multi column data

Hi Tom,

It is exactly what asked to me the customer. The table that I had previously attached, (test1.rar) (now used only for the chart) should show a graph based on the selections from the variables (supplier, customer, month, year), but as mentioned not knowing working with this componente, I was stranded in the development

[Tom Patten]

Re: chart multi column data

My wife thinks we should travel to Venice to assist, but I attached a zip file of my approach in a private email.

Hope it helps.

Tom

[Cristiano]

Re: chart multi column data

Hi Tom,

thank you for your mail. Your approach it's very helpful for me because I could learn some things that were wrong . But as my sample do you think that I can use the my search variable using the ' ARGUMENT ' and ' ARUMENT BINDING' to create each time different charts ?

Thankyu

[Tom Patten]

Re: chart multi column data

I was unable to make the query approach work. In general I found working with charts to be very difficult. So I simplified and created one database devoted to serving the Chart. It works great. But the user has to push a button to update the charts, actually only the current month's chart, but the script updates the past six months. For my usual user, it doesn't take long. Another advantage of using a dedicated dbf file, is if you need update the table structure, just copy the default chart_dbf file to the user, and when they click to update it will replace the default data with their information. Some of my expressions to fill the chart_dbf are long and complicated, but they seem to run just fine.

I suppose if you want to automatically create a different chart each time, you could put code on the form's Init action to push the "Update" button on the form.

Hope this helps.

~ Tom

[Cristiano]

Re: chart multi column data

Thank you Tom,

I think there should be a possibility to use variables, asking at the user which filter they want to use in the query