Pie Chart...

[cavj1]

Hi All...

I'm trying to learn the charting capabilities of Alpha. I've watched some videos and have been reading the forum but I am getting stuck on some aspects of this function. Can you "drill" into a chart? For example if I double click on a piece of the pie can it bring me to sub-data that formed that piece of the pie? For example:

Pie chart gives me the totals of items sold for each company we work with. Double click that piece of pie it opens a new pie that shows me all of the different items that were sold.

So say Company A has 33% of the pie for $1,500. I double click on that piece of the pie to open a new pie that shows the items and percentage of each of those items that make up the 33%($1,500)...like Keyboards - 5% ($25), Mice 2% ($10), Motherboards 19%($324), etc...now remember the second pie chart for Company A would be based on 100% of Company A's sales.

Hope I'm making sense here.

Any ideas/direction to learn this would be greatly appreciated.

Thanks
Joe

[samt2046]

Re: Pie Chart...

Hi Joe, I have recently done a drill down from a Bar Chart to a detail list. It should work the same way if you want to drill down to another chart. From the original chart, you need to pass over the argument to the next chart to publish the data.

DH-03.jpg
DH-04.jpg

[Tbrondolo]

Re: Pie Chart...

HI Joe,

I use Google Visualizations. The attached UX shows how you can get the data row for the segment of the pie chart you click on. Once you have that you can fire an event or call back to produce the data for the next chart.

Tom

[cavj1]

Re: Pie Chart...

Thank you for the replies and examples. I'm sure I may have more questions but this is definitely some good info. Appreciate it.

[ujwalsaurav]

Re: Pie Chart...

This attachment didnot help me with onclick event and i was unable to open other chart.
So it would be helpful if you provide me with more information on how to connect two charts dynamically and drilling down them based oth the related information.

[ujwalsaurav]

Re: Pie Chart...Tom, How to achieve this "Once you have that you can fire an event or call back to produce the data for the "

Helo Tom,
We have tried out the below steps but we do not know how to proceed for next thing which is "Once you have that you can fire an event or call back to produce the data for the next chart."

1. We are able to use the java script file Google Visualizations
2. Previously it was throwing some java script error
3. SO we have done some configuration setting thru Alpha and resolve that
4. After that we need next help to open a new chart once after clicking each segment of chat.
Any immediate help would be appreciated...Waiting for your reply

Regards
Navneet

[Tbrondolo]

Re: Pie Chart...Tom, How to achieve this "Once you have that you can fire an event or call back to produce the data for the "

The attached ux shows a drill down example. it only works for Sleep slice of the pie.

Much of this depends on how your data is structured but the idea is to get an identifier from chart 1 that you can use to filter data to create chart 2. You have to map out your data so you are passing in valid identifiers for the callback to filter chart2 data. The UX here is a simple example to show how you can get at the data. There are probably more efficient ways of doing this.

The UX was created in a newer version of Alpha, if you have problems loading it let me know.

If you need more help with this or have a complex dataset send me a PM and maybe I can help.


Regards,
Tom






piechart2.zip

Helo Tom,
We have tried out the below steps but we do not know how to proceed for next thing which is "Once you have that you can fire an event or call back to produce the data for the next chart."

1. We are able to use the java script file Google Visualizations
2. Previously it was throwing some java script error
3. SO we have done some configuration setting thru Alpha and resolve that
4. After that we need next help to open a new chart once after clicking each segment of chat.
Any immediate help would be appreciated...Waiting for your reply

Regards
Navneet

[ujwalsaurav]

Re: Pie Chart...Tom, How to achieve this "Once you have that you can fire an event or call back to produce the data for the "

Thank you so much Tom for your quick response. Could you please share your mail ID so that I can share you our Code?
Regards
Navneet

[peteconway]

Re: Pie Chart...

Navneet, you have what you need, Work, Eat, Commute, Watch TV, Sleep would be CategoryNames of MyDailyActivities, just need to pass your var selectPie (or categoryname selected) to an argument let's say :WHAT_CATEGORY and filter your SQL QUERY in your xbasic function to return the filtered response to the client side function JSpieChart() in your javascript functions.

something like this.

function xpieChart as c (e as p)

dim js as c
dim cn as SQL::Connection
dim rs as SQL::ResultSet
DIM args as sql::arguments
args.add("CategoryName":,"WHAT_CATEGORY")
dim txt as c
dim template as c

//you will need to create the SQL query to ti SUM the numeric Values and group the ProductName ( not shown) for the actual SQL but the format goes like this.

IF cn.open("::NAME::MYBUSINESS") THEN
cn.PortableSQLEnabled = .f.
cn.execute("SELECT CategoryName, ProductName, SalesValue FROM MyDailyActivities GROUP BY PoductName, CategoryID ORDER BY CategoryName",args)
rs = cn.ResultSet
END IF

template = "['{js_escape(ds.data("ProductName"))}', {ds.data("SalesValue")}]," // insert values

txt = a5_mergedataintotemplate(template,rs)
txt = rtrim(txt,",")
txt = "[['ProductName', 'Value']," + txt + "]" // labels
js = "{dialog.object}._data_pop = " + txt + ";"
xpieChart = js
xpieChart = xpieChart + " JSchartTwo();" // return the response to the JSFunction.

end function

So call the xbasic function then call the JS client side function.

Hope this helps, its very late here to a bit blurry eyed. so may have some errors in the code but will will get the idea.