RE: [flexcoders] Waterfall chart
Hi Tom. The best way to do this is to pre-process your dataprovider into a synthetic one that has all of the summed values in it. Use that as the dataprovider for the chart, and set the various min/max fields of the series appropriately. Ely. -Original Message- From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Tom Fitzpatrick Sent: Wednesday, October 05, 2005 6:35 AM To: flexcoders@yahoogroups.com Subject: [flexcoders] Waterfall chart Importance: High I'd like to make a "waterfall" chart (at least that's one name for it) - a version of the stacked bar chart. The first column is the total of three values. The next three columns represent the three separate values that make up the total, but instead of stacking they "float" next to each other at the appropriate height and with the appropriate color and tooltip info. My question is - can the values in the ColumnSeries be determined using a function - kind of like a labelFunction for charts? This would enable me to calculate the value for the "total" column and the starting and ending values for the three floating columns. Or is there an easier/better way to accomplish this? - Tom Yahoo! Groups Sponsor ~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/nhFolB/TM ~-> -- Flexcoders Mailing List FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com Yahoo! Groups Links Yahoo! Groups Sponsor ~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/nhFolB/TM ~-> -- Flexcoders Mailing List FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/flexcoders/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [flexcoders] Waterfall chart
Thanks, Ely. Can you point to or provide a simple example of dataprovider preprocessing? If my data structure is as follows: ... I can see that I need to perform some math on the "result" nodes to create the new dataProvider: - add a node that is the sum of the "apple" "orange" and "banana" values - set the minValue for "orange" as the yValue of "apple', and set the yValue of "orange" as "apple" plus "orange" - set the minValue for "banana" as the yValue of "orange" and set the yValue of "banana" the same as "total" The "generating chart data" example in the docs seems close, but it's based on random values rather than manipulating a real xml source. Another question while I'm at it: is it possible to change the spacing for just one of four columns in a cluster? I'd like to "total" column to be separated from the "waterfall" by a space. - Tom At 01:00 PM 10/5/2005, you wrote: >Hi Tom. The best way to do this is to pre-process your dataprovider into >a synthetic one that has all of the summed values in it. Use that as the >dataprovider for the chart, and set the various min/max fields of the >series appropriately. > > >Ely. > > >-Original Message- >From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On >Behalf Of Tom Fitzpatrick >Sent: Wednesday, October 05, 2005 6:35 AM >To: flexcoders@yahoogroups.com >Subject: [flexcoders] Waterfall chart >Importance: High > >I'd like to make a "waterfall" chart (at least that's one name for it) >- a version of the stacked bar chart. The first column is the total of >three values. The next three columns represent the three separate values >that make up the total, but instead of stacking they "float" next to >each other at the appropriate height and with the appropriate color and >tooltip info. > >My question is - can the values in the ColumnSeries be determined using >a function - kind of like a labelFunction for charts? This would enable >me to calculate the value for the "total" column and the starting and >ending values for the three floating columns. Or is there an >easier/better way to accomplish this? > >- Tom > > > > > > > >-- >Flexcoders Mailing List >FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt >Search Archives: >http://www.mail-archive.com/flexcoders%40yahoogroups.com >Yahoo! Groups Links > > > > > > > > > >-- >Flexcoders Mailing List >FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt >Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com >Yahoo! Groups Links > > > > Yahoo! Groups Sponsor ~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/nhFolB/TM ~-> -- Flexcoders Mailing List FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/flexcoders/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [flexcoders] Waterfall chart
Sure Tom. You've got the basics in your outline below. Basically, you want something like: Function genDP(original:Array):Array { var result:Array = []; for(var i=0;imailto:[EMAIL PROTECTED] On Behalf Of Tom Fitzpatrick Sent: Thursday, October 06, 2005 7:17 AM To: flexcoders@yahoogroups.com Subject: RE: [flexcoders] Waterfall chart Importance: High Thanks, Ely. Can you point to or provide a simple example of dataprovider preprocessing? If my data structure is as follows: ... I can see that I need to perform some math on the "result" nodes to create the new dataProvider: - add a node that is the sum of the "apple" "orange" and "banana" values - set the minValue for "orange" as the yValue of "apple', and set the yValue of "orange" as "apple" plus "orange" - set the minValue for "banana" as the yValue of "orange" and set the yValue of "banana" the same as "total" The "generating chart data" example in the docs seems close, but it's based on random values rather than manipulating a real xml source. Another question while I'm at it: is it possible to change the spacing for just one of four columns in a cluster? I'd like to "total" column to be separated from the "waterfall" by a space. - Tom At 01:00 PM 10/5/2005, you wrote: >Hi Tom. The best way to do this is to pre-process your dataprovider >into a synthetic one that has all of the summed values in it. Use that >as the dataprovider for the chart, and set the various min/max fields >of the series appropriately. > > >Ely. > > >-Original Message- >From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On >Behalf Of Tom Fitzpatrick >Sent: Wednesday, October 05, 2005 6:35 AM >To: flexcoders@yahoogroups.com >Subject: [flexcoders] Waterfall chart >Importance: High > >I'd like to make a "waterfall" chart (at least that's one name for it) >- a version of the stacked bar chart. The first column is the total of >three values. The next three columns represent the three separate >values that make up the total, but instead of stacking they "float" >next to each other at the appropriate height and with the appropriate >color and tooltip info. > >My question is - can the values in the ColumnSeries be determined using >a function - kind of like a labelFunction for charts? This would enable >me to calculate the value for the "total" column and the starting and >ending values for the three floating columns. Or is there an >easier/better way to accomplish this? > >- Tom > > > > > > > >-- >Flexcoders Mailing List >FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt >Search Archives: >http://www.mail-archive.com/flexcoders%40yahoogroups.com >Yahoo! Groups Links > > > > > > > > > >-- >Flexcoders Mailing List >FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt >Search Archives: >http://www.mail-archive.com/flexcoders%40yahoogroups.com >Yahoo! Groups Links > > > > Yahoo! Groups Sponsor ~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/nhFolB/TM ~-> -- Flexcoders Mailing List FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com Yahoo! Groups Links Yahoo! Groups Sponsor ~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/nhFolB/TM ~-> -- Flexcoders Mailing List FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/flexcoders/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [flexcoders] Waterfall chart
Ely - thanks. I had already come up with a somewhat less efficient solution, so this helps. The Cartesian tip was helpful also - though the offset settings are a bit cryptic at first. - Tom At 12:55 PM 10/6/2005, you wrote: >Sure Tom. You've got the basics in your outline below. Basically, you >want something like: > >Function genDP(original:Array):Array >{ > var result:Array = []; > for(var i=0;i var v:Object = result[i] > result[i] = { > sum: v.apple + v.orange + v.banana, > apple: v.apple, > orangeMin: v.apple, > orangeMax: v.orange + v.apple, > ... > } > } > return result; >} >Regarding clustering...you can't tweak the clustering behavior in >ColumnChart, but all the clustering is doing is setting the offset and >columnWidthRatio properties of the individual ColumnSeries objects to >make them line up. So if you used a CartesianChart with some >ColumnSeries in it, you could manually set the offset/columnWidthRatio >properties to whatever you wanted. > >Ely. > > > >-Original Message- >From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On >Behalf Of Tom Fitzpatrick >Sent: Thursday, October 06, 2005 7:17 AM >To: flexcoders@yahoogroups.com >Subject: RE: [flexcoders] Waterfall chart >Importance: High > >Thanks, Ely. Can you point to or provide a simple example of >dataprovider preprocessing? > >If my data structure is as follows: > > > > > > > > ... > > >I can see that I need to perform some math on the "result" nodes to >create the new dataProvider: > >- add a node that is the sum of the "apple" "orange" and >"banana" values >- set the minValue for "orange" as the yValue of "apple', and set the >yValue of "orange" as "apple" plus "orange" >- set the minValue for "banana" as the yValue of "orange" and set the >yValue of "banana" the same as "total" > >The "generating chart data" example in the docs seems close, but it's >based on random values rather than manipulating a real xml source. > >Another question while I'm at it: is it possible to change the spacing >for just one of four columns in a cluster? I'd like to "total" column to >be separated from the "waterfall" by a space. > >- Tom > >At 01:00 PM 10/5/2005, you wrote: > >Hi Tom. The best way to do this is to pre-process your dataprovider > >into a synthetic one that has all of the summed values in it. Use that > >as the dataprovider for the chart, and set the various min/max fields > >of the series appropriately. > > > > > >Ely. > > > > > >-Original Message- > >From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On > > >Behalf Of Tom Fitzpatrick > >Sent: Wednesday, October 05, 2005 6:35 AM > >To: flexcoders@yahoogroups.com > >Subject: [flexcoders] Waterfall chart > >Importance: High > > > >I'd like to make a "waterfall" chart (at least that's one name for it) > >- a version of the stacked bar chart. The first column is the total of > >three values. The next three columns represent the three separate > >values that make up the total, but instead of stacking they "float" > >next to each other at the appropriate height and with the appropriate > >color and tooltip info. > > > >My question is - can the values in the ColumnSeries be determined using > > >a function - kind of like a labelFunction for charts? This would enable > > >me to calculate the value for the "total" column and the starting and > >ending values for the three floating columns. Or is there an > >easier/better way to accomplish this? > > > >- Tom > > > > > > > > > > > > > > > >-- > >Flexcoders Mailing List > >FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt > >Search Archives: > >http://www.mail-archive.com/flexcoders%40yahoogroups.com > >Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > >-- > >Flexcoders Mailing List > >FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt > >Search Archives: > >http://www.mail-archive.com/flexcoders%40yahoogroups.com