Flexmonster - Navigate to URL on cell click

by Ian Sadovy

HTML

<script src="https://s3.amazonaws.com/flexmonster/2.2/flexmonster.js"></script>
<script src="https://s3.amazonaws.com/flexmonster/2.3/flexmonster.js"></script>
<link rel="stylesheet" href="https://s3.amazonaws.com/flexmonster/2.3/demo.css">
<div id="pivot-container"></div>

JavaScript

var pivot = $("#pivot-container").flexmonster({
  componentFolder: "https://s3.amazonaws.com/flexmonster/2.3/",
  width: "100%",
  height: 430,
  toolbar: true,
  cellclick: function(cell) {
    if (cell.member) {
    	window.open("http://flexmonster.com/");
    }
  },
  report: {
    dataSource: {
      dataSourceType: "csv",
      filename: "data/data.csv"
    },
    slice: {
      columns: [{
        uniqueName: "Color"
      }],
      rows: [{
        uniqueName: "Country"
      }, {
        uniqueName: "[Measures]"
      }],
      measures: [{
        uniqueName: "Price",
        format: "currency"
      }],
    },
    formats: [{
      name: "currency",
      currencySymbol: "$",
      currencySymbolAlign: "left",
      thousandsSeparator: ",",
      decimalPlaces: 2
    }],
    conditions: [{
      formula: "if(#value < 2000, 'trueStyle')",
      measure: "Discount",
      trueStyle: {
        backgroundColor: "#CCFFCC",
      }
    }, {
      formula: "if(AND(#value > 2000, #value < 4000), 'trueStyle')",
      measure: "Discount",
      trueStyle: {
        backgroundColor: "#FFFF99",
      }
    }],
    options: {
      configuratorActive: false
    }
  }
});