Area chart

Integration with Highcharts

by Flexmonster Pivot Table

HTML

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

<script src="https://code.highcharts.com/12.5.0/highcharts.js"></script>
<script src="https://code.highcharts.com/12.5.0/highcharts-more.js"></script>
<script src="https://code.highcharts.com/12.5.0/modules/accessibility.js"></script>

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

CSS

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

#highcharts-container {
  margin: 20px;
  height: 450px;
}

JavaScript

const pivot = new Flexmonster({
  container: "#pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  licenseFilePath: "https://cdn.flexmonster.com/jsfiddle.charts.key",
  toolbar: true,
  height: 400,
  report: {
    dataSource: {
      filename: "data/data.csv",
    },
    slice: {
      rows: [{ uniqueName: "Country" }, { uniqueName: "[Measures]" }],
      columns: [
        {
          uniqueName: "Business Type",
          filter: {
            exclude: ["business type.[specialty bike shop]"],
          },
        },
      ],
      measures: [{ uniqueName: "Price" }],
    },
  },
  reportcomplete: function () {
    pivot.off("reportcomplete");
    areaChart();
  },
});

function areaChart() {
  pivot.highcharts.getData(
    {
      type: "area",
    },
    function (chartConfig) {
      applyFontSize(chartConfig);
      Highcharts.chart("highcharts-container", chartConfig);
    },
    function (chartConfig) {
      applyFontSize(chartConfig);
      Highcharts.chart("highcharts-container", chartConfig);
    }
  );
}

function applyFontSize(config) {
  config.chart.style = {
    fontSize: "18px",
    fontFamily: "Arial, sans-serif"
  };
}


function areaChart() {
  pivot.highcharts.getData(
    {
      type: "area",
    },
    function (chartConfig) {
      applyFontSize(chartConfig);
      Highcharts.chart("highcharts-container", chartConfig);
    },
    function (chartConfig) {
      applyFontSize(chartConfig);
      Highcharts.chart("highcharts-container", chartConfig);
    },
  );
}