Flexmonster - Connect to Elasticsearch

Demos

by Flexmonster Pivot Table

HTML

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

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

CSS

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

JavaScript

new Flexmonster({
  container: "#pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  height: 600,
  toolbar: true,
  report: {
    dataSource: {
      type: "elasticsearch",
      node: "https://olap.flexmonster.com:9200",
      index: "australian_weather",
      mapping: {
        "Date": {
          caption: "Date",
          format: "yyyy",
          interval: "1y",
        },
        "Location": {
          caption: "Location",
        },
        "Min Temperature": {
          caption: "Min Temp",
        },
        "Max Temperature": {
          caption: "Max Temp",
        },
        "Rainfall": {
          caption: "Rainfall",
        },
        "Evaporation": {
          caption: "Evaporation",
        },
        "Sunshine": {
          caption: "Sunshine",
        },
        "Wind Speed": {
          caption: "Wind Speed",
        },
        "Rain Today": {
          caption: "Rain Today",
        },
        "Rain Tomorrow": {
          caption: "Rain Tomorrow",
        },
        "State.keyword": {
          caption: "State",
        },
        "Location.keyword": {
          caption: "Location",
        },
      },
    },
    slice: {
      rows: [
        {
          uniqueName: "State.keyword",
        },
        {
          uniqueName: "Location.keyword",
        },
      ],
      columns: [
        {
          uniqueName: "Date",
          filter: {
            query: {
              after: "2008-12-31",
            },
          },
        },
        {
          uniqueName: "[Measures]",
        },
      ],
      measures: [
        {
          uniqueName: "Min Temperature",
          aggregation: "min",
          grandTotalCaption: "Min Temp",
          format: "-10ws2q1oviodoa",
        },
        {
          uniqueName: "Max Temperature",
          aggregation: "max",
          grandTotalCaption: "Max Temp",
          format:...