Waterfall Chart : Actual Vs Total Plan

[eddieed]

Hi, we are trying to use the waterfall chart in our report. In our waterfall, we need to compare between Actual (cumulative across afew categories) and the last bar would be Total Plan for the year. Unforunately it seems that Fusion waterfall chart does not support that. Is there any way to work around this?

 

cheers

[Sanjukta]

Hi,

 

Welcome to FusionCharts Forum!

 

Could you please try setting the attribute "showSumAtEnd" to '1' in the <chart> element? Also, you can provide a distinct label for the summation column using the attribute "sumLabel".

 

Furthermore, you can set the attributes "isSum" and "cumulative" to '1' in the <set> element to solve your purpose.

 

The attribute "isSum" lets you set whether the <set> value should represent the sum of previous set values in the water fall chart. You can put a sum column at any position in the chart (barring the first position, as you need at least one data point to calculate sum).

 

The attribute "cumulative" lets you set whether the sum represents the cumulative sum (of all the columns to the left of this sum column) or non-cumulative sum (of all the columns to the left of this column, but after the last sum column).

 

In case you still have issues, please send us the XML as an attachment.

 

Hope this helps.

[eddieed]

Thanks. For the last column, it is a separate entity altogether. It has no corelation between the last column to the previous columns. Therefore, the last column is a

-> non cumulative or non sum

-> AND the most important part is the last column starts from ZERO position so that we can do a COMPARISON between the sum of previous columns and the last column.

 

cheers

 

Hi,

 

Welcome to FusionCharts Forum!

 

Could you please try setting the attribute "showSumAtEnd" to '1' in the <chart> element? Also, you can provide a distinct label for the summation column using the attribute "sumLabel".

 

Furthermore, you can set the attributes "isSum" and "cumulative" to '1' in the <set> element to solve your purpose.

 

The attribute "isSum" lets you set whether the <set> value should represent the sum of previous set values in the water fall chart. You can put a sum column at any position in the chart (barring the first position, as you need at least one data point to calculate sum).

 

The attribute "cumulative" lets you set whether the sum represents the cumulative sum (of all the columns to the left of this sum column) or non-cumulative sum (of all the columns to the left of this column, but after the last sum column).

 

In case you still have issues, please send us the XML as an attachment.

 

Hope this helps.

[eddieed]

Hi, is there anyone could help me with this?

 

thanks heaps!

[Sanjukta]

Hi,

 

Apologies for the inconvenience.

 

I am afraid, the Waterfall chart of the PowerCharts pack does not support this, as of now.

[Guest Angie]

Dear User,

 

We are delighted to announce that PowerCharts is now ready for your iPads and iPhones too. We have just released PowerCharts v3.2. Starting v3.2, PowerCharts has HighCharts embedded within it, and offers both Flash and JavaScript (HTML5) charting . The Flash charts are displayed on a majority of devices and the JavaScript charts on devices that do not support Flash, all of it without writing a line of code.

 

Automatic rendering of JavaScript charts on devices (like iPad and iPhone) where Flash player is not supported.

 

5 new chart types:

 

Heat Map Chart

 

Box and Whisker Chart

 

Step Line Chart

 

Error Line Chart

 

Error Scatter Chart

 

 

* Support for JSON data format.

 

* Support for LinkedCharts, where a single data source controls multiple charts.

 

* Interactive legends in charts allow selective showing/hiding of data series.

 

* Legends now support icons for each data series.

 

* Better management of labels on charts.

 

* Labels now have an auto rendering mode to prevent them from overlapping, the chart selects the best display mode depending on the length of the labels and the width of the chart.

 

* Long labels are truncated, with ellipses appended to the truncated end of each label, and a tooltip bearing the completed label text is displayed when the user hovers over a truncated label.

 

* Support for line breaks and wrapping in all text elements including: caption, sub caption, X-axis title, Y-axis title, Labels and tooltips.

 

* In Line charts, data values can now be positioned either above or below the dataplots. Automatic positioning of data values is also supported.

 

* In Step-line charts dataplots can be joined using vertical lines.

 

* Custom alignment of caption and sub caption using STYLES.

 

* Advanced print management using JavaScript.

 

* Additional options for efficient event handling using JavaScript.

 

* Support for dynamic update of chart properties using JavaScript(barring select scatter and drag charts).

 

* Charts now support % based sizes along with dynamic resizing (barring select scatter and drag charts).

 

 

Learn more about everything new in PowerCharts v3.2 at : http:/ www.fusioncharts.com/PowerCharts/

 

We would love to hear from you at: http://www.fusioncharts.com/contact/

[KiranVL]

Hi,

 

Is the above problem has been resolved?

 

For the last column, it is a separate entity altogether. It has no corelation between the last column to the previous columns. Therefore, the last column is a  non cumulative or non sum. I need to set calculated value in the last column.

AND the most important part is the last column starts from ZERO position so that we can do a COMPARISON between first and last column.

Edited February 24, 2014 by KiranVL

[Haritha]

Hi Kiran,

 

As said above, it is not possible to start the last column of Waterfall chart from the starting point of Y-axis value, as of now.

 

If you want to show some other calculated value in the last column and it should start from Y-axis starting position(Same as first column position), then as a workaround to your requirement, you may use Stacked Column 2D chart from FusionCharts XT pack, instead of Water fall chart. You may set the alpha/transparency of a dataset to 0 so that the stacked columns appear to look like going incrementally higher.

 

Please find an attached XML along with a screenshot of the Stacked Column 2D chart obtained. However, it is not possible to obtain connectors that you have in Water fall chart using this chart type.  

 

For information on Stacked Column 2D chart, refer : http://docs.fusioncharts.com/charts/contents/ChartSS/StCol2D.html

 

Also, if you want to use Water fall chart but do not want the last column to be the sum column, then you may set the attribute "showSumAtEnd" to 0.

 

Ref.

<chart .. showSumAtEnd='0' >

 

Hope this helps.

Data1.xml