Heatmap

Customize cells

by Sundarapandiyan_pa

HTML

<link rel="stylesheet" href="https://s3.amazonaws.com/flexmonster/2.3/demo.css">
<script src="https://cdn.flexmonster.com/flexmonster.js"></script>

<div id="pivot-container"></div>

JavaScript

var colorScheme = [
  "#F8746D",
  "#FA9172",
  "#FBAE78",
  "#FDD17F",
  "#F7E683",
  "#DBE081",
  "#C3D980",
  "#9FCF7E",
  "#7DC57C",
  "#68BF7B"
]

var minValue = 0;
var maxValue = 15000;

function customizeCellFunction(cell, data) {

}

function getColorFromRange(value) {
  if (isNaN(value)) {
    value = minValue;
  }
  value = Math.max(minValue, Math.min(value, maxValue));
  var perc = (minValue + value) / maxValue;
  var colorIdx = Math.round((colorScheme.length - 1) * perc);
  return colorScheme[colorIdx];
}

var pivot = new Flexmonster({
  container: "pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  width: "100%",
  height: 600,
  toolbar: true,
  customizeCell: customizeCellFunction,
  report: {
    dataSource: {
      filename: "data/sales.csv"
    },
    slice: {
      rows: [{
        uniqueName: "Month"
      }, {
        uniqueName: "[Measures]"
      }],
      measures: [{
        "uniqueName": "Revenue",
        "aggregation": "sum"
      }]
    },
    formats: [{
      name: "",
      decimalPlaces: 2,
      currencySymbol: "$"
    }]
  }
});