JSFiddle - React, Tailwind, and code Playground

by Ian Sadovy

HTML

<script src="https://s3.amazonaws.com/flexmonster/2.2/flexmonster.js"></script>
<div id="pivot-content"></div>

JavaScript

flexmonster.embedPivotComponent("https://s3.amazonaws.com/flexmonster/2.2/", "pivot-content", "100%", "600", {
  licenseKey: "Z53G-1T1WC3-1V1M-0L12-2M0A-1233-1I0Y-2Y2Q-1903-322S-0T2C-1I",
  jsPivotCreationCompleteHandler: onComplete
}, true);

var conditions = [{
  measure: "Price",
  formula: "if(#value > 0, 'trueStyle')",
  trueStyle: {
    "backgroundColor": "#0099FF",
    "color": "#000000",
    "fontFamily": "Arial",
    "fontSize": 12
  }
}, {
  measure: "Price",
  formula: "if(#value < 5000, 'trueStyle')",
  trueStyle: {
    "backgroundColor": "#FF0033",
    "color": "#000000",
    "fontFamily": "Arial",
    "fontSize": 12
  }
}, {
  measure: "Quantity",
  formula: "if(#value > 300, 'trueStyle')",
  trueStyle: {
    "backgroundColor": "#00CC66",
    "color": "#000000",
    "fontFamily": "Arial",
    "fontSize": 12
  }
}, {
  measure: "Quantity",
  formula: "if(#value < 300, 'trueStyle')",
  trueStyle: {
    "backgroundColor": "#FF0033",
    "color": "#000000",
    "fontFamily": "Arial",
    "fontSize": 12
  }
}];

function onComplete() {
  var report = {
    data: getData(),
    rows: [{
      uniqueName: "Color"
    }],
    columns: [{
      uniqueName: "Measures"
    }],
    measures: [{
      uniqueName: "Price"
    }, {
      uniqueName: "Quantity"
    }],
    conditions: conditions
  }
  flexmonster.setReport(report);
}

function getData() {
  return [{
    "Color": "green",
    "M": "September",
    "W": "Wed",
    "country": "Canada",
    "state": "Ontario",
    "city": "Toronto",
    "Price": 174,
    "Quantity": 22
  }, {
    "Color": "red",
    "M": "March",
    "W": "Mon",
    "Time": "1000",
    "country": "USA",
    "state": "California",
    "city": "Los Angeles",
    "Price": 1664,
    "Quantity": 19
  }, {
    "Color": "red",
    "M": "January",
    "W": "Mon",
    "country": "Canada",
    "state": "Quebec",
    "city": "Montreal",
    "Price": 1190,
    "Quantity": 292
  }, {
    "Color": "green",
    "D": "04/08/2014",
    "M": "August",
...