Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Anchor
top27
top27


Panel
borderColor#ffeaae
bgColorfffdf6

(warning) This panel only supports Neo4j Datasource.


Info

Configurations are made in Grafana.

In this section, learn how to configure an InSights Chart

The steps are given below -

Panel

Table of Contents

Click the “General” tab.

  • Enter the Title of the panel.
  • Select span.
  • Select Min Span (optional).
  • Enter the Height.
  • Select Transparent (optional).

General Tab

Click the “Metrics” tab.

  • Delete the fake data source.
  • Select an appropriate value in Panel data source.
  • Click “Add Query”.

Metrics tab

Click the “Options” tab.

    • Enter the appropriate options.
    • Enter Data Transformation Instructions(Used when time series is also required, and specified in the Neo4j query).
    • Enter Data Join Instructions(Used when time series is also required, and specified in the Neo4j query).
    • Click “Load Chart(In case to load an existing chart)different types of charts available.
    • Click “Save Chart” to save the chart.

Options tab

  • Use the below instructions if you need to plot graph with respect to time.
Panel

Data Transformation Instructions


var formatter3 = new google.visualization.DateFormat({ pattern: "dd-MMM-yy" });

var testFunction = function (val) {

        return new Date(formatter3.formatValue(val));

};

var result = google.visualization.data.group(data,

        [{ column: 0, modifier: testFunction, type: 'date' }],

        [{ 'column': 1, 'aggregation': google.visualization.data.sum, 'type': 'number' },

        { 'column': 2, 'aggregation': google.visualization.data.sum, 'type': 'number' }]);

return result;

Data Join Instructions


return google.visualization.data.join(dataTables[0], dataTables[1], 'full', [[0, 0]], [1], [1]);


Click “Time range”.

    • Enter Override relative time.
    • Add Shift time.
    • Select/ Deselect “Hide time override info”.

Time range tab

Top Section