Column3d chart: with options.slice parameter

Integration with FusionCharts

by Flexmonster Pivot Table

HTML

<script src="https://cdn.flexmonster.com/flexmonster.js"></script>
<script src="https://cdn.flexmonster.com/lib/flexmonster.fusioncharts.js"></script>

<script src="https://cdn.fusioncharts.com/fusioncharts/3.19.0/fusioncharts.js"></script>
<script src="https://cdn.fusioncharts.com/fusioncharts/3.19.0/themes/fusioncharts.theme.fusion.js"></script>

<div>
  <p>
    By default,
    <a
      href="https://www.flexmonster.com/api/all-methods-fusioncharts/"
      target="_blank"
      >the Connector for FusionCharts</a
    > prepares the data based on the current slice in Flexmonster Pivot. In this
    example, the data for the slice is specified using the
    <a
      href="https://www.flexmonster.com/api/fusioncharts-getdata/#options-slice"
      target="_blank"
    >options.slice</a> parameter (lines 48-67 in the JavaScript box).
  </p>

  <p>
    If <code>options.slice</code> is defined, the chart will not respond to
    further slice changes on the grid, which means data shown on the chart will
    be static.
  </p>
</div>

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

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

CSS

@import url(https://cdn.flexmonster.com/assets/jsfiddle-styles.css);

JavaScript

let pivot = new Flexmonster({
  container: "#pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  licenseFilePath: "https://cdn.flexmonster.com/jsfiddle.charts.key",
  report: {
    dataSource: {
      filename: "data/data.csv",
    },
    slice: {
      rows: [
        {
          uniqueName: "Category",
        },
      ],
      columns: [
        {
          uniqueName: "Business Type",
        },
        {
          uniqueName: "[Measures]",
        },
      ],
      measures: [
        {
          uniqueName: "Price",
        },
      ],
    },
  },
  height: 400,
  toolbar: true,
  reportcomplete: function () {
    pivot.off("reportcomplete")
    createFusionChart()
  },
})

function createFusionChart() {
  let chart = new FusionCharts({
    type: "column3d",
    renderAt: "fusionchart-container",
    width: "100%",
    height: 400,
  })
  pivot.fusioncharts.getData(
    {
      type: chart.chartType(),
      slice: {
        rows: [
          {
            uniqueName: "Country",
          },
        ],
        columns: [
          {
            uniqueName: "Color",
          },
          {
            uniqueName: "[Measures]",
          },
        ],
        measures: [
          {
            uniqueName: "Price",
          },
        ],
      },
    },
    function (chartConfig) {
      chartConfig.chart.use3DLighting = false;
      chartConfig.chart.theme = "fusion";
      chart.setJSONData(chartConfig)
      chart.render()
    },
    function (chartConfig) {
      chart.setJSONData(chartConfig)
      chart.setChartAttribute("theme", "fusion");
      chart.setChartAttribute("use3DLighting", false);
    },
  )
}