Visualize data using JSON input in Metrics/Advanced

OpenDistro
1

Hi,
i want to convert octets to megabytes, why when using JSON input on rollup index it is not working. (Right side in attached picture)
When, using the same for the raw index (not rollup index), it is working: (Left side in attached picture)

image
image3286×443 80.5 KB

Is there a way how to convert values in index which is rollup index?
Thanks

2

Well, i found a solution. It is enough if you just changed in Index Patterns the format of needed field from Number to Bytes.

image
image422×547 13.4 KB

3

Is it possible to perform some math as well using the JSON input? like divide or multiply 2 fields?

4

Yes. you can use painless scripting on the advanced section. for example to multiply the resulting value from your visualization you can do,

{
    "script": { 
        "source": "return _value / 1000"
    }
}