API call runQuery

Slice configuration

HTML

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

<button onclick="runQuery()">Run query</button>
<div id="pivot-container"></div>

JavaScript

var pivot = new Flexmonster({
	container: "pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  width: "100%",
  height: 430,
  toolbar: true,
  report: {
    dataSource: {
      filename: "data/data.csv"
    }
  }
});

function runQuery() {
  var slice = 
  {
   rows:
   [
    {uniqueName: "Size"}
   ],
   columns:
   [
    {uniqueName: "Color"}
   ],
   measures:
   [
    {uniqueName: "Price"}
   ],
   reportFilters:
   [
     {
       uniqueName: "Country",
       filter:
       {
         members: [
           "Country.[France]",
           "Country.[Germany]",
           "Country.[United Kingdom]",
         ]
       }
     }
   ]
  };
  flexmonster.runQuery(slice);
}