KB - Wijmo 5 - Waterfall Grid

A sample showing how to create a waterfall chart with FlexChart.

by Joel Parks

HTML

<link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css">
<link rel="stylesheet" href="http://cdn.wijmo.com/5.latest/styles/wijmo.min.css">
<script src="http://cdn.wijmo.com/5.latest/controls/wijmo.min.js"></script>
<script src="http://cdn.wijmo.com/5.latest/controls/wijmo.input.min.js"></script>
<script src="http://cdn.wijmo.com/5.latest/controls/wijmo.grid.min.js"></script>
<script src="http://cdn.wijmo.com/5.latest/controls/wijmo.chart.min.js"></script>
<script src="http://cdn.wijmo.com/5.latest/controls/wijmo.chart.analytics.min.js"></script>
<script src="http://cdn.wijmo.com/5.latest/controls/wijmo.chart.interaction.min.js"></script>
<script src="http://cdn.wijmo.com/5.latest/controls/wijmo.chart.finance.min.js"></script>
<script src="http://cdn.wijmo.com/5.latest/interop/angular/wijmo.angular.min.js"></script>
<!-- mark this as an Angular application and give it a controller -->
<div ng-app="app" ng-controller="appCtrl" class="container">


  <p>And this is a <b>FlexChart</b> control showing the same data:</p>
  <div id="chart" style="min-width: 310px;height:400px" class="wj-control wj-flexchart wj-state-focused"></div>
</div>

CSS

.wj-flexgrid {
   height: 150px;
   margin-top: 10px;
 }
 
 .wj-flexchart {
   height: 300px;
 }

JavaScript

var app = angular.module('app', ['wj']);
app.controller('appCtrl', function($scope) {
  
  var data = [];
	var legend = 'Forecast: 2018';
	var ranges = [{ start: 15, end: 61 }, { start: 61, end: 26 }, { start: 26, end: 78 }, { start: 78, end: 53 }];
	var difference = [];
	var months = ['Q1','Q2','Q3','Q4'];
  for (var i = 0; i < months.length; i++) {
		var sMin = ranges[i].start;
		var sMax = ranges[i].end;
		var sDif = sMax - sMin;
		difference.push(sDif);
    data[i] = {
      x: i,
      xAxis: months[i],
      forecastSeries: sDif,
      forecast: {
        max: sMax,
        min: sMin
      }
    }
  }
	console.log(difference);
  
  var constant = data.length>5? 0.25:0.15;
  
  var chart = new wijmo.chart.FlexChart("#chart");
  chart.initialize({
  	legendToggle: true,
    itemsSource: data,
    bindingX: 'xAxis',
    axisY: {
      min: 0,
      max: 100
    },
    chartType: wijmo.chart.ChartType.Column,
    series: [{
      name: legend,
      binding: "forecastSeries"
    }]
  });
	
  chart.itemFormatter = function(engine, hitTestInfo, defaultFormat) {
    var count = chart.collectionView.items.length;
    var range = chart.axisX.actualMax - chart.axisX.actualMin;
    var scale = count / range;
    var shift = scale * constant;
    if (hitTestInfo.chartElement == wijmo.chart.ChartElement.SeriesSymbol) {
      var item = hitTestInfo.item;
      if (hitTestInfo.name === legend) {
        var ptmaxForecast = chart.dataToPoint(item.x - shift, item.forecast.max);
        var ptminForecast = chart.dataToPoint(item.x - shift, item.forecast.min);
				if(item.forecastSeries > 0) {
					engine.drawLine(ptmaxForecast.x, ptmaxForecast.y, ptminForecast.x, ptminForecast.y, null, {
						stroke: 'blue',
						strokeWidth: 20
					});
				} else {
					engine.drawLine(ptmaxForecast.x, ptmaxForecast.y, ptminForecast.x, ptminForecast.y, null, {
						stroke: 'red',
						strokeWidth: 20
					});
				}
      }
    }
  };
});