Installation issue

I have tried to install this plugin in kibana version 6.2.1 but i've got the error "Plugin installation was unsuccessful due to error "No valid url specified."". Can you please help me !!

Kibana [6.7.2]

Dear,

Are there any predictions for version support Kibana 6.7.2.

Datasweet formula plugin is breaking SearchGuard configuration tabs

Hi, the datasweet plugin is not working properly when installed on Kibana with SearchGuard.

Steps to reproduce:

Install Kibana with SearchGuard plugin. Tested on below versions:

Kibana 6.4.0 https://artifacts.elastic.co/downloads/kibana/kibana-6.4.0-linux-x86_64.tar.gz
SearchGuard 15 for 6.4.0 http://central.maven.org/maven2/com/floragunn/search-guard-kibana-plugin/6.4.0-15/search-guard-kibana-plugin-6.4.0-15.zip
DataSweet Formula 2.0.0 for 6.4.0 https://github.com/datasweet/kibana-datasweet-formula/releases/download/v2.0.0/datasweet_formula-2.0.0_kibana-6.4.0.zip

Once you have SearchGuard running install datasweet formula plugin

Attempting to transfer from file:///tmp/kibana/datasweet_formula-2.0.0_kibana-6.4.0.zip
Transferring 407760 bytes....................
Transfer complete
Retrieving metadata from plugin archive
Extracting plugin archive
Extraction complete
Optimizing and caching browser bundles...
Plugin installation complete

Open SearchGuard configuration or tenancy selection pages, which will not be rendered. /app/searchguard-configuration and /app/searchguard-multitenancy

I have tried installing other plugins instead of datasweet and SearchGuard pages don't break due to them. Hence, opening issue in this project. Please let me know if I should share some more information.

Kibana version 7.5

Area you considering a port for version 7.5?
Saw that you are working on #52 but that's still ongoing.

API Changes list: https://www.elastic.co/blog/kibana-plugin-api-changes-in-7.5

Release for 6.2.3 and 6.2.4

Could you please make a release for these versions?

I got an error when i try to install on 6.2.3

Plugin installation was unsuccessful due to error "Incorrect Kibana version in plugin [datasweet_formula]. Expected [6.2.3]; found [6.2.2]"

Kibana 7.2.0

To use the plugin in Kibana 7.2.0 i modify the package.json and it was possible to use the plugin.
But now i have a problem with Metric visualization, when i "Hide Aggregation" Kibana produces a error.
The Datasweet formula is simples: agg1/agg2
The Kibana error:
"Version: 7.2.0
Build: 24337
Error: Uncaught TypeError: Cannot read property 'name' of undefined (http://kibana.unimedva.com.br/built_assets/dlls/vendors.bundle.dll.js:98)
at window.onerror (http://kibana.unimedva.com.br/bundles/commons.bundle.js:3:1643907)"

Home "sweet" Home - no Issue - its a Thank you

I should make some noise!
YOU MADE MY DAY
Thanks for this swissknife-keep that very good work going on.

Hidden aggregation are visible. How solve problem?

Install plugin for Kibana 6.1.2.
Under the superuser, widget with metrics hides some metrics(aggregation) that are needed to calculate the metrics.

And if you go to the kibana under the user with role "kibana_dashboard_only_user", then all the hidden aggregation are visible.

I need help. I will be very grateful!!

Aggregate metrics don't respect split series

I'm trying to normalize the plots of several different streams of data, and plot them together. Datasweet Formula lets me get really, really close, but I need to aggregate the individual series, not all of the data.

My formula is agg1 / sum(agg1), and my agg1 is just a count. With five different series, the top one maxes out at a little over 14%:

When I filter down to just that value, it becomes 50%:

I want it to be 50% in both cases, but sum(agg1) gives me the sum of all of the data, not just the data for the one series.

I would expect that my use case here is the more common one. Not sure, though.

Filter ratio?

I'd like to do formulas based on filtered counts, is there a way to do this?

I have some logs, and I want to get:

( count of log.status_code > 500 ) / (count)

It doesn't appear there is a way to make an aggregation with a filter without filtering the whole series, is there any way to do this with the plugin?

Datasweet Formula doesn't work with percentiles aggregation

Hello,

Kibana version: 6.2.0
Problem: Datasweet Formula calculation doesn't work with percentiles aggregation (even when only one percentile selected)

It may be hard to implement or require a lot of changes in case of multiple percentiles selected for same field/metric (like: 25,50,75) but it should be possible to fix when single percentile selected.

Thanks for such a great plugin.

Enhancement Request: Add datasweet formula to region maps in kibana

Hello datasweet team,

I wanted to ask if you plan to add the amazing datasweet formula feature for regionmaps as well in kibana. What about other types of visualizations like coordinate maps or pie charts?

Thank you again,
George

Kibana 6.5.1 Support

HI any idea when we will get the release for 6.5.1 or is there any workaround to get it work

Problem with decimal

Hello!

Using datasweet plugin Kibana 7.1.1 how to set the number of decimals?

agg1 = 16.459
agg2 = 7.469
datasweet = agg1 / agg2 = 2.2036417191056366

How to make it be 2.20 ?

kibana can't authenticate after installing "datasweet formula" plugin

Hi, after installing kibana-datasweet-formula kibana can't authenticate
the error bellow is displayed when clicking on logout or timelion OR logging in

Search Guard and Elasticsearch version
search guard search-guard-6:6.1.0-20.1
search-guard-kibana-plugin-6.1.0-8
elastic stack 6.1.0 (docker containers)
Search Guard configuration files
copy of https://github.com/deviantony/docker-elk/tree/searchguard
Other installed Elasticsearch or Kibana plugins, if any
kibana-datasweet-formula
Error
Error: Uncaught Error: [$injector:modulerr] Failed to instantiate module kibana due to: Error: [$injector:modulerr] Failed to instantiate module app/visualize due to: Error: [$injector:unpr] Unknown provider: visEditorAggDirectiveProvider http://errors.angularjs.org/1.6.5/$injector/unpr?p0=visEditorAggDirectiveProvider at http://localhost:5696/bundles/commons.bundle.js?v=16337:48:996 at http://localhost:5696/bundles/commons.bundle.js?v=16337:48:34101 at Object.getService [as get] (http://localhost:5696/bundles/commons.bundle.js?v=16337:48:32180) at Object.decorator (http://localhost:5696/bundles/commons.bundle.js?v=16337:48:30436) at http://localhost:5696/bundles/commons.bundle.js?v=16337:7:74957 at Object.invoke (http://localhost:5696/bundles/commons.bundle.js?v=16337:48:33212) at runInvokeQueue (http://localhost:5696/bundles/commons.bundle.js?v=16337:48:31027) at http://localhost:5696/bundles/commons.bundle.js?v=16337:48:31338 at forEach (http://localhost:5696/bundles/commons.bundle.js?v=16337:48:1681) at loadModules (http://localhost:5696/bundles/commons.bundle.js?v=16337:48:30821) http://errors.angularjs.org/1.6.5/$injector/modulerr?p0=app%2Fvisualize&p1=Error%3A%20%5B%24injector%3Aunpr%5D%20Unknown%20provider%3A%20visEditorAggDirectiveProvider%0Ahttp%3A%2F%2Ferrors.angularjs.org%2F1.6.5%2F%24injector%2Funpr%3Fp0%3DvisEditorAggDirectiveProvider%0A%20%20%20%20at%20http%3A%2F%2Flocalhost%3A5696%2Fbundles%2Fcommons.bundle.js%3Fv%3D16337%3A48%3A996%0A%20%20%20%20at%20http%3A%2F%2Flocalhost%3A5696%2Fbundles%2Fcommons.bundle.js%3Fv%3D16337%3A48%3A34101%0A%20%20%20%20at%20Object.getService%20%5Bas%20get%5D%20(http%3A%2F%2Flocalhost%3A5696%2Fbundles%2Fcommons.bundle.js%3Fv%3D16337%3A48%3A32180)%0A%20%20%20%20at%20Object.decorator%20(http%3A%2F%2Flocalhost%3A5696%2Fbundles%2Fcommons.bundle.js%3Fv%3D16337%3A48%3A30436)%0A%20%20%20%20at%20http%3A%2F%2Flocalhost%3A5696%2Fbundles%2Fcommons.bundle.js%3Fv%3D16337%3A7%3A74957%0A%20%20%20%20at%20Object.invoke%20(http%3A%2F%2Flocalhost%3A5696%2Fbundles%2Fcommons.bundle.js%3Fv%3D16337%3A48%3A33212)%0A%20%20%20%20at%20runInvokeQueue%20(http%3A%2F%2Flocalhost%3A5696%2Fbundles%2Fcommons.bundle.js%3Fv%3D16337%3A48%3A31027)%0A%20%20%20%20at%20http%3A%2F%2Flocalhost%3A5696%2Fbundles%2Fcommons.bundle.js%3Fv%3D16337%3A48%3A31338%0A%20%20%20%20at%20forEach%20(http%3A%2F%2Flocalhost%3A5696%2Fbundles%2Fcommons.bundle.js%3Fv%3D16337%3A48%3A1681)%0A%20%20%20%20at%20loadModules%20(http%3A%2F%2Flocalhost%3A5696%2Fbundles%2Fcommons.bundle.js%3Fv%3D16337%3A48%3A30821) at http://localhost:5696/bundles/commons.bundle.js?v=16337:48:996 at http://localhost:5696/bundles/commons.bundle.js?v=16337:48:31683 at forEach (http://localhost:5696/bundles/commons.bundle.js?v=16337:48:1681) at loadModules (http://localhost:5696/bundles/commons.bundle.js?v=16337:48:30821) at http://localhost:5696/bundles/commons.bundle.js?v=16337:48:31240 at forEach (http://localhost:5696/bundles/commons.bundle.js?v=16337:48:1681) at loadModules (http://localhost:5696/bundles/commons.bundle.js?v=16337:48:30821) at createInjector (http://localhost:5696/bundles/commons.bundle.js?v=16337:48:34614) at doBootstrap (http://localhost:5696/bundles/commons.bundle.js?v=16337:48:13733) at Object.bootstrap (http://localhost:5696/bundles/commons.bundle.js?v=16337:48:14265) http://errors.angularjs.org/1.6.5/$injector/modulerr?p0=kibana&p1=Error%3A%20%5B%24injector%3Amodulerr%5D%20Failed%20to%20instantiate%20module%20app%2Fvisualize%20due%20to%3A%0AError%3A%20%5B%24injector%3Aunpr%5D%20Unknown%20provider%3A%20visEditorAggDirectiveProvider%0Ahttp%3A%2F%2Ferrors.angularjs.org%2F1.6.5%2F%24injector%2Funpr%3Fp0%3DvisEditorAggDirectiveProvider%0A%20%20%20%20at%20http%3A%2F%2Flocalhost%3A5696%2Fbundles%2Fcommons.bundle.js%3Fv%3D16337%3A48%3A996%0A%20%20%20%20at%20http%3A%2F%2Flocalhost%3A5696%2Fbundles%2Fcommons.bundle.js%3Fv%3D16337%3A48%3A34101%0A%20%20%20%20at%20Object.getService%20%5Bas%20get%5D%20(http%3A%2F%2Flocalhost%3A5696%2Fbundles%2Fcommons.bundle.js%3Fv%3D16337%3A48%3A32180)%0A%20%20%20%20at%20Object.decorator%20(http%3A%2F%2Flocalhost%3A5696%2Fbundles%2Fcommons.bundle.js%3Fv%3D16337%3A48%3A30436)%0A%20%20%20%20at%20http%3A%2F%2Flocalhost%3A5696%2Fbundles%2Fcommons.bundle.js%3Fv%3D16337%3A7%3A74957%0A%20%20%20%20at%20Object.invoke%20(http%3A%2F%2Flocalhost%3A5696%2Fbundles%2Fcommons.bundle.js%3Fv%3D16337%3A48%3A33212)%0A%20%20%20%20at%20runInvokeQueue%20(http%3A%2F%2Flocalhost%3A5696%2Fbundles%2Fcommons.bundle.js%3Fv%3D16337%3A48%3A31027)%0A%20%20%20%20at%20http%3A%2F%2Flocalhost%3A5696%2Fbundles%2Fcommons.bundle.js%3Fv%3D16337%3A48%3A31338%0A%20%20%20%20at%20forEach%20(http%3A%2F%2Flocalhost%3A5696%2Fbundles%2Fcommons.bundle.js%3Fv%3D16337%3A48%3A1681)%0A%20%20%20%20at%20loadModules%20(http%3A%2F%2Flocalhost%3A5696%2Fbundles%2Fcommons.bundle.js%3Fv%3D16337%3A48%3A30821)%0Ahttp%3A%2F%2Ferrors.angularjs.org%2F1.6.5%2F%24injector%2Fmodulerr%3Fp0%3Dapp%252Fvisualize%26p1%3DError%253A%2520%255B%2524injector%253Aunpr%255D%2520Unknown%2520provider%253A%2520visEditorAggDirectiveProvider%250Ahttp%253A%252F%252Ferrors.angularjs.org%252F1.6.5%252F%2524injector%252Funpr%253Fp0%253DvisEditorAggDirectiveProvider%250A%2520%2520%2520%2520at%2520http%253A%252F%252Flocalhost%253A5696%252Fbundles%252Fcommons.bundle.js%253Fv%253D16337%253A48%253A996%250A%2520%2520%2520%2520at%2520http%253A%252F%252Flocalhost%253A5696%252Fbundles%252Fcommons.bundle.js%253Fv%253D16337%253A48%253A34101%250A%2520%2520%2520%2520at%2520Object.getService%2520%255Bas%2520get%255D%2520(http%253A%252F%252Flocalhost%253A5696%252Fbundles%252Fcommons.bundle.js%253Fv%253D16337%253A48%253A32180)%250A%2520%2520%2520%2520at%2520Object.decorator%2520(http%253A%252F%252Flocalhost%253A5696%252Fbundles%252Fcommons.bundle.js%253Fv%253D16337%253A48%253A30436)%250A%2520%2520%2520%2520at%2520http%253A%252F%252Flocalhost%253A5696%252Fbundles%252Fcommons.bundle.js%253Fv%253D16337%253A7%253A74957%250A%2520%2520%2520%2520at%2520Object.invoke%2520(http%253A%252F%252Flocalhost%253A5696%252Fbundles%252Fcommons.bundle.js%253Fv%253D16337%253A48%253A33212)%250A%2520%2520%2520%2520at%2520runInvokeQueue%2520(http%253A%252F%252Flocalhost%253A5696%252Fbundles%252Fcommons.bundle.js%253Fv%253D16337%253A48%253A31027)%250A%2520%2520%2520%2520at%2520http%253A%252F%252Flocalhost%253A5696%252Fbundles%252Fcommons.bundle.js%253Fv%253D16337%253A48%253A31338%250A%2520%2520%2520%2520at%2520forEach%2520(http%253A%252F%252Flocalhost%253A5696%252Fbundles%252Fcommons.bundle.js%253Fv%253D16337%253A48%253A1681)%250A%2520%2520%2520%2520at%2520loadModules%2520(http%253A%252F%252Flocalhost%253A5696%252Fbundles%252Fcommons.bundle.js%253Fv%253D16337%253A48%253A30821)%0A%20%20%20%20at%20http%3A%2F%2Flocalhost%3A5696%2Fbundles%2Fcommons.bundle.js%3Fv%3D16337%3A48%3A996%0A%20%20%20%20at%20http%3A%2F%2Flocalhost%3A5696%2Fbundles%2Fcommons.bundle.js%3Fv%3D16337%3A48%3A31683%0A%20%20%20%20at%20forEach%20(http%3A%2F%2Flocalhost%3A5696%2Fbundles%2Fcommons.bundle.js%3Fv%3D16337%3A48%3A1681)%0A%20%20%20%20at%20loadModules%20(http%3A%2F%2Flocalhost%3A5696%2Fbundles%2Fcommons.bundle.js%3Fv%3D16337%3A48%3A30821)%0A%20%20%20%20at%20http%3A%2F%2Flocalhost%3A5696%2Fbundles%2Fcommons.bundle.js%3Fv%3D16337%3A48%3A31240%0A%20%20%20%20at%20forEach%20(http%3A%2F%2Flocalhost%3A5696%2Fbundles%2Fcommons.bundle.js%3Fv%3D16337%3A48%3A1681)%0A%20%20%20%20at%20loadModules%20(http%3A%2F%2Flocalhost%3A5696%2Fbundles%2Fcommons.bundle.js%3Fv%3D16337%3A48%3A30821)%0A%20%20%20%20at%20createInjector%20(http%3A%2F%2Flocalhost%3A5696%2Fbundles%2Fcommons.bundle.js%3Fv%3D16337%3A48%3A34614)%0A%20%20%20%20at%20doBootstrap%20(http%3A%2F%2Flocalhost%3A5696%2Fbundles%2Fcommons.bundle.js%3Fv%3D16337%3A48%3A13733)%0A%20%20%20%20at%20Object.bootstrap%20(http%3A%2F%2Flocalhost%3A5696%2Fbundles%2Fcommons.bundle.js%3Fv%3D16337%3A48%3A14265) (http://localhost:5696/bundles/commons.bundle.js?v=16337:48) at window.onerror (http://localhost:5696/bundles/commons.bundle.js?v=16337:64:8723)

make plugin not dependent on version,

With every new minor version of kibana and dedicated version number of the datasweet plug-in is needed. There are no available version for the latest version of Kibana. Would it be possible to remove the version checking mechanisms?

Divide by 0 warning.

Javascript have some weird behaviour concerning division.

0/0 => NaN
x/0 | x <> 0 => -/+Infinity

We want NaN for both.

Our organizationalso wanted to display a Kibana warning when a Divide by 0 occured, just to warn the user. Let them know that something unexpected might be hapenning. Something like the following:

'Divide by 0 occured. If this is unexpected, please ensure the denominator is non-zero.'

Let me know what you think.

Kibana-datasweet-formula support for kibana 7.0.1

Thank you so much for this plugin. The plugin is not compatible with the latest version of Kibana 7.0.1. Please support.

"Incorrect Kibana version in plugin [datasweet_formula]. Expected [6.4.0]; found [6.3.2]"

When did you release the version of datasweet_formula for Kibana 6.4

actually we have:

./bin/kibana-plugin install https://github.com/datasweet/kibana-datasweet-formula/releases/download/1.1.0/datasweet_formula-1.1.0_kibana-6.3.2.zip
Attempting to transfer from https://github.com/datasweet/kibana-datasweet-formula/releases/download/1.1.0/datasweet_formula-1.1.0_kibana-6.3.2.zip
Transferring 402149 bytes....................
Transfer complete
Retrieving metadata from plugin archive
Extracting plugin archive
Extraction complete
Plugin installation was unsuccessful due to error "Incorrect Kibana version in plugin [datasweet_formula]. Expected [6.4.0]; found [6.3.2]"

Using Standard Deviation Aggregation

Hello.

I am trying to create a Datasweet formula that uses a Standard Deviation aggregation as input. However it seems that Datasweet Formula is not capable of using that value.

Is there support for Standard Deviation in Datasweet Formula?.

I am using Kibana and Elasticsearch version 6.2.1 and installed Datasweet Formula datasweet_formula-1.0.1_kibana-6.2.1.zip

Datasweet does not count sum aggregation in Kibana

Hi team,
i calculated some fields and then tried to display the sum of total for my fields, but it didnt work. Sum aggregation displays nothing, however f.e max aggregation works and shows the results
any help or it`s a bug? My Kibana is 6.7.0

with v1.1.1, simple metric visualization is not working.

Hi,

I'm using kibana 6.3.2 and i downloaded and installed the datasweet-formula v1.1.1.
When i tried to create a simple metric visualization it didn't work.
Only when i reverted to v1.1.0 the visualization worked as expected.
Any idea?

Regards

kibana-datasweet-formula for kibana-6.2.3

./bin/kibana-plugin install https://github.com/datasweet-fr/kibana-datasweet-formula/releases/download/version_name/datasweet_formula-1.1.3_kibana-major.minor.patch.zip

Plugin installation was unsuccessful due to error "No valid url specified."

what's wrong?

Plugin installation was unsuccessful due to error "Client request error: connect ETIMEDOUT 107.21.237.188:443"

hi, I download ur zip and using kibana-plugin install ur package
But I found this error each time which confused me very much cause I search this the prefix "107.21" in ur package after unzip. return nothing!
Can U give me some advices!?

Value 0 is show as 'null'

the value 0 is show as 'null' in the latest release.

Elasticsearch request body

{
  "size": 0,
  "aggs": {
    "2": {
      "terms": {
        "field": "x_coord",
        "size": 10,
        "order": {
          "_term": "desc"
        }
      },
      "aggs": {
        "5": {
          "terms": {
            "field": "y_coord",
            "size": 1,
            "order": {
              "_term": "desc"
            }
          },
          "aggs": {
            "1": {
              "sum": {
                "field": "PCnt"
              }
            }
          }
        }
      }
    }
  },
  "stored_fields": [
    "*"
  ],
  "script_fields": {},
  "docvalue_fields": [
    "@timestamp",
    "end_test_time",
    "start_test_time"
  ],
  "query": {
    "bool": {
      "must": [
        {
          "match_all": {}
        },
        {
          "range": {
            "start_test_time": {
              "gte": 1501998362599,
              "lte": 1533534362599,
              "format": "epoch_millis"
            }
          }
        },
        {
          "match_phrase": {
            "mother_lot_key": {
              "query": "2/U71Z0.00/WS1"
            }
          }
        }
      ],
      "filter": [],
      "should": [],
      "must_not": []
    }
  }
}

Elasticsearch response body

{
  "took": 4,
  "timed_out": false,
  "_shards": {
    "total": 30,
    "successful": 30,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 22791,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "2": {
      "doc_count_error_upper_bound": 0,
      "sum_other_doc_count": 17022,
      "buckets": [
        {
          "5": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 260,
            "buckets": [
              {
                "1": {
                  "value": 14
                },
                "key": 20,
                "doc_count": 27
              }
            ]
          },
          "key": 34,
          "doc_count": 287
        },
        {
          "5": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 399,
            "buckets": [
              {
                "1": {
                  "value": 5
                },
                "key": 23,
                "doc_count": 35
              }
            ]
          },
          "key": 33,
          "doc_count": 434
        },
        {
          "5": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 404,
            "buckets": [
              {
                "1": {
                  "value": 16
                },
                "key": 24,
                "doc_count": 29
              }
            ]
          },
          "key": 32,
          "doc_count": 433
        },
        {
          "5": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 512,
            "buckets": [
              {
                "1": {
                  "value": 10
                },
                "key": 26,
                "doc_count": 35
              }
            ]
          },
          "key": 31,
          "doc_count": 547
        },
        {
          "5": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 560,
            "buckets": [
              {
                "1": {
                  "value": 16
                },
                "key": 27,
                "doc_count": 27
              }
            ]
          },
          "key": 30,
          "doc_count": 587
        },
        {
          "5": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 611,
            "buckets": [
              {
                "1": {
                  "value": 12
                },
                "key": 28,
                "doc_count": 26
              }
            ]
          },
          "key": 29,
          "doc_count": 637
        },
        {
          "5": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 644,
            "buckets": [
              {
                "1": {
                  "value": 0
                },
                "key": 29,
                "doc_count": 47
              }
            ]
          },
          "key": 28,
          "doc_count": 691
        },
        {
          "5": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 649,
            "buckets": [
              {
                "1": {
                  "value": 18
                },
                "key": 29,
                "doc_count": 34
              }
            ]
          },
          "key": 27,
          "doc_count": 683
        },
        {
          "5": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 718,
            "buckets": [
              {
                "1": {
                  "value": 15
                },
                "key": 30,
                "doc_count": 29
              }
            ]
          },
          "key": 26,
          "doc_count": 747
        },
        {
          "5": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 695,
            "buckets": [
              {
                "1": {
                  "value": 16
                },
                "key": 30,
                "doc_count": 28
              }
            ]
          },
          "key": 25,
          "doc_count": 723
        }
      ]
    }
  },
  "status": 200
}

Formula Input:
agg1

x_coord: Descending	y_coord: Descending	Sum of PCnt	Formula 4
28	29	0	-
33	23	5	5
31	26	10	10
29	28	12	12
34	20	14	14
26	30	15	15
32	24	16	16
30	27	16	16
25	30	16	16
27	29	18	18

x_coord: Descending	y_coord: Descending	Sum of PCnt	Formula 4
28	29	0	-
33	23	5	5
31	26	10	10
29	28	12	12
34	20	14	14
26	30	15	15
32	24	16	16
30	27	16	16
25	30	16	16
27	29	18	18

add more examples?

Can you guys add more examples? How can I do something like a "Metric" visualization for count(success) where success = true / count(success)

kibana_dashboard_only_user error for visualizations created in kibana-datasweet

Hello datasweet team,

I was super excited when I came across your plugin yesterday. I created a simple ratio of two aggregations and added them to a dashboard 📈.

However, when viewing this dashboard in dashboard_only_mode, all my regular visualizations were displayed properly except for the one I created with datasweet 📉 .

Below is my role configuration for the user with kibana_dashboard_only_user role. I tried elevating him and granted him access to .kibana index and all privileges but I still get the same error:
Visualize: undefined is not an object (evaluating 'agg.type.postFlightRequest')

Note that I do not see this error with the superuser. I tried giving my dashboard only user privileges similar to a superuser but I still get the same error with no visualization (the data is there though available for export)

Below are some screenshots for this issue.
Please help us out as this is breaking our dashboard.

Happy to assist in any way I can,
George

Problem whit % format

Greetings I am trying to calculate a progress or a ratio.
I don't know why, but as much as I've tried I can't make a field formatted to % it only shows it from 1 to 0 but it doesn't make the change to % I tried to put the field as a percentage but this damages the metric that becomes 1 and multiplying by 100 does not adjust it either. Here is an example using the example index delivered by kibana kibana_sample_data_ecommerce
Kibana 7.1.1

export (12).zip

kibana-datasweet-formula for kibana 6.7.1

We use Kibana 6.2 and we want to upgrade to 6.7
I'd install Kibana 6.7.1 on my computer to try it, but I can't install the datasweet-formula.

this is the error i get:
FATAL Error: Optimizations failure.
5656 modules

ERROR in ./plugins/datasweet_formula/public/decorators/lib/formula_parser.js
Module not found: Error: Can't resolve 'expr-eval' in 'C:\Users\gilm\Desktop\elk 6.7.1\kibana-6.7.1-windows-x86_64\plugins\datasweet_formula\public\decorators\lib'

ERROR in ./plugins/datasweet_formula/public/formulas/percentile.js
Module not found: Error: Can't resolve 'percentile' in 'C:\Users\gilm\Desktop\elk 6.7.1\kibana-6.7.1-windows-x86_64\plugins\datasweet_formula\public\formulas'

Maybe you have a solution?

Disable Filter/Filter out value

Please allow the option to toggle kibana dashboard filter.

Kibana 7.2.0 Plugin

64/5000
Hello! How to use the plugin for Kibana 7.2.0? Thank you very much!

Result Decimals Places Formatter

The formatter in percentage, has how to format the number of decimal places?

Problems after install

Hi,
I have kibana version 6.2.0
After installing your plugin, I have got problems with another plugin... Example I can't work with default plugin "timelion". Your plugin work, but another have a problem. If I run timelione after install datasweet-formula I get error:

Version: 6.2.0
Build: 16562

Support numeral.js patterns for Number formats

When you use a Number format in Kibana, you have the option to specify the numeral.js pattern:

It'd be great to have that option right here when using Datasweet formulas

That way I can have the calculated value use the same format as the source data, e.g. $0,0.[00] to display USD

Problem to install in Elastic 5.6.8 and Centos 6

Good afternoon

I'm trying to install this plugin in a Kibana 5.6.8 that's is part of an ElasticSearch 5.6.8 Cluster. The operational sysmtem is Centos 6.

v1.1.3

Attempting to transfer from https://codeload.github.com/datasweet/kibana-datasweet-formula/tar.gz/v1.1.3
Transferring unknown number of bytes
Transfer complete
Retrieving metadata from plugin archive
Error: end of central directory record signature not found
at /usr/share/kibana/node_modules/yauzl/index.js:179:14
at /usr/share/kibana/node_modules/yauzl/index.js:539:5
at /usr/share/kibana/node_modules/fd-slicer/index.js:32:7
at FSReqWrap.wrapper [as oncomplete] (fs.js:683:17)
Plugin installation was unsuccessful due to error "Error retrieving metadata from plugin archive"

Do you have any idea?

Thanks

Regards

Alexandre Bunn

Datasweet formula not show values when aggregation is 0

Hello!

Thanks for the excelent plugin!

Just one question, i've noticed that when the aggregation that we are using in the formula is zero, the metric of Datasweet does not shows the value zero.

Is there any way to accomplish this?

Thanks in advance!

Example:

order by in bucket by formular not working

Hi,
I really like your plugin. The only issue I have is when I try to use the new calculated metric to order my buckets, I am getting:

Kind regards,

Wolfgang

Using javascript function on aggregation date

Hi,

I'm trying to get the working days between 2 dates.

I managed to get the number of days between 2 dates thank to datasweet with "(agg2 - agg1) / (86400*1000)"

but we lose the data of which day it is. Since we can't declare variables. The best thing to have would be something like this :
msPerDay = 86400 * 1000; days = agg2 - agg1 / msPerDay; first_day = agg1.getDay(); second_day = agg2.getDay(); if(first_day - end_day > 1, days = days - 2, days = days -1); etc.. return days;

Error Kibana After Instalation

Good mornig i just Install the plug in and kibana stop working, the I uninstall the plugin an kibana start working fine, i am using version 6.2.1, I dont Know if i am installing the plugin with the wron parameters.

I'm using -d , but it seems is deprecated.

Atte.
Oscar Lozada

Datasweet Formula invisible in metric visualization

Hello,

Kibana version: 6.2.0
Problem: Datasweet Formula result value invisible in metric visualization, but correctly calculated and can be seen in a result table:

Error in visualization

I get a popup when I run a vizualisation that has a datasweet formula.
The message is:

Error in visualisation
Cannot read property '0' or undefined.

The vizualization is a horizontal barchart with a datasweet formula: "100" (So just a number).
It happens with the following 2 circumstances (both must be true):

I select a time range that has 0 (zero) documents.
I have a terms-bucket

I do NOT get an error when (either of the 2)

I select a time range with more than 0 (zero) documents.
I do not have a terms-bucket (or if I change the terms-bucket into an range-bucket)

I'm using elasticsearch/ kibana 6.6.2

kibana-datasweet-formula for kibana 6.2.2

When I try to install the plugin for kibana 6.2.2, a message with incorrect plugin version appears. Is there a way to install it in 6.2.2? If not, when will we have a release for this version of kibana?

Error in visualization

In Kibana 6.6.2 I get a popup with the text:

Error in Visualisation
agg is undefined

How to Reproduce:

Create a visualization "Horizontal Bar"
Change the default metric into "Datasweet formula" and use the formula "1000"
Create bucket X-Axis with a 'terms' aggregation
Pick a field and Change the Order By into 'metric: Formula1' (That is the metric with the datasweet formula)
Run the vizualisation.

The popup with "agg is undefined" will show.

The undefined variable agg can be found in './ui/public/courier/search_source/search_source.js'

The data has not changed

I use the Metric Visualize. Calculate the difference between access and error in the log, filter out less than 0。 when i change timestamp, the data did not changed.

6.3.1

Fantastic plugin.

Can you please provide support for ver 6.3.1?

Thanks

Calculate Time Difference in Kibana with Datasweet

Hi
I need formula for this case using datasweet:

started_at: 2017-04-01 07:41:25
ended_at: 2017-05-01 10:14:34
output: 26:33:09

Migration elk 6.5

Hello

Have you planned to do the migration to Kibana 6.5 soon ?

Table Footer Formula

Hey,

I've noticed is that the formula doesn't work as expected for the "Total" table function. For example, I'm using sum function in the image below:

Shouldn't the last column (a derived metric as percentage) be calculated by the formula as well? I mean, first sum the column values and then apply the formula (sum(agg1)/sum(agg3))?

Thanks!

kibana cannot be ordered by metrics that are aggregated with Datasweet Formula

Hello,

Kibana version: 6.4.0
datasweet-formula: 2.0.0
Problem: kibana cannot be ordered by the metrics that are aggregated with Datasweet Formula。The metric that is aggregated with Datasweet Formula can be seen in “order by”, but it doesn't work。

Data-Sweet-formula is not throwing "this.viz is not defined" error with kibana 6.6.2

Hi,

I am working with kibana 6.6.1. I have to install data-sweet-formula plugin manually to work on this version of kibana. Unfortunately, after successful installation kibana is throwing "this.viz is not defined" error.

Can you please look into this issue.

Regards,
Sujata

x_coord: Descending	y_coord: Descending	Sum of PCnt	Formula 4
28	29	0	-
33	23	5	5
31	26	10	10
29	28	12	12
34	20	14	14
26	30	15	15
32	24	16	16
30	27	16	16
25	30	16	16
27	29	18	18

x_coord: Descending	y_coord: Descending	Sum of PCnt	Formula 4
28	29	0	-
33	23	5	5
31	26	10	10
29	28	12	12
34	20	14	14
26	30	15	15
32	24	16	16
30	27	16	16
25	30	16	16
27	29	18	18

x_coord: Descending	y_coord: Descending	Sum of PCnt	Formula 4
28	29	0	-
33	23	5	5
31	26	10	10
29	28	12	12
34	20	14	14
26	30	15	15
32	24	16	16
30	27	16	16
25	30	16	16
27	29	18	18

x_coord: Descending	y_coord: Descending	Sum of PCnt	Formula 4
28	29	0	-
33	23	5	5
31	26	10	10
29	28	12	12
34	20	14	14
26	30	15	15
32	24	16	16
30	27	16	16
25	30	16	16
27	29	18	18

datasweet / kibana-datasweet-formula Goto Github PK

kibana-datasweet-formula's People

Contributors

Stargazers

Watchers

Forkers

kibana-datasweet-formula's Issues

/usr/share/kibana/bin/kibana-plugin install https://codeload.github.com/datasweet/kibana-datasweet-formula/tar.gz/v1.1.3

Recommend Projects

Recommend Topics

Recommend Org

x_coord: Descending	y_coord: Descending	Sum of PCnt	Formula 4
28	29	0	-
33	23	5	5
31	26	10	10
29	28	12	12
34	20	14	14
26	30	15	15
32	24	16	16
30	27	16	16
25	30	16	16
27	29	18	18

x_coord: Descending	y_coord: Descending	Sum of PCnt	Formula 4
28	29	0	-
33	23	5	5
31	26	10	10
29	28	12	12
34	20	14	14
26	30	15	15
32	24	16	16
30	27	16	16
25	30	16	16
27	29	18	18