This tutorial explains how to define a mapping object for an Elasticsearch index in a report and what settings this mapping object supports.

A mapping object can have the following properties:

• caption (optional) – String. Overrides the default name of the field.
• visible (optional) – Boolean. When set to false, hides the field from the Field List.
• interval (optional) – String. Used for the date histogram. Check out the supported time units.
• time_zone (optional) – String. Used for the date histogram. You can specify timezones as either an ISO 8601 UTC offset (e.g. +01:00 or -08:00) or as a timezone ID as specified in the IANA timezone database, such as `America/Los_Angeles`. Check out this example.
• format (optional) – String. Used for the date histogram. Check out the date format/pattern.
• min_doc_count (optional) – Number. Used for the date histogram. Can be used to show intervals with empty values (min_doc_count: 0). Default value: 1 (empty intervals are hidden).

How to hide unnecessary fields in Elasticsearch

All unnecessary fields can be hidden by setting "visible": false:

var pivot = new Flexmonster({
  container: "pivotContainer",
  toolbar: true,
  report: {
    "dataSource": {
      "type": "elasticsearch",
      /* the host for the connection */
      "node": "https://olap.flexmonster.com:9200",
      /* the name of Elasticsearch index to connect */
      "index": "fm-product-sales", 
      /* additional setting to configure index mapping */
      "mapping": {
        "@timestamp": {
          "visible": false
        },
        "@version": {
          "visible": false
        },
        "host": {
          "visible": false
        },
        "message": {
          "visible": false
        },
        "path": {
          "visible": false
        }
      }
    }
  },
  licenseKey: "XXXX-XXXX-XXXX-XXXX-XXXX"
}); 

Check out the example on JSFiddle.

How to format dates in Elasticsearch

The following example demonstrates how to format dates:

new Flexmonster({
  container: "#pivot-container",
  toolbar: true,
  report: {
    dataSource: {
      type: "elasticsearch",
      node: "https://olap.flexmonster.com:9200",
      index: "fm-product-sales",
      mapping: {
        "@timestamp": {
          "format": "dd/MM/yyyy"
        }
      }
    },
    slice: {
      rows: [{
        "uniqueName": "@timestamp"
      }],
      columns: [{
        "uniqueName": "[Measures]"
      }],
      measures: [{
        "uniqueName": "Price",
        "aggregation": "sum"
      }]
    }
  }
});

Check out the example on JSFiddle.