Kibana: using the histogram panel without timestamps


(LEVAI Daniel) #1

Hi!

I'm new to the list, so, hey to everyone :slight_smile:

What I would like to do, is {mis,ab}use Kibana's histogram panel in a
way, that it wouldn't display timestamps on the X axis.
I have measurements of stuff, let's say algorithm runtimes. I have four
types under an index:

_index : "sort_timings"
_type : "n^2"
_type : "quicksort"
_type : "mergesort"
_type : "fillings"

This is basically it. I do fifty measurements of each type, and fed
it to Elasticsearch, so that I got 50 x 4 docs.
The mappings became this:

{ "sort_timings" : {
"n^2" : {
"properties" : {
"items" : { "type" : "long" },
"test" : { "type" : "long" },
"took" : { "type" : "double" },
"type" : { "type" : "string" } }
},
"quicksort" : { [...] /the same/ },
"filling" : { [...] /the same },
"mergesort" : { [...] /the same } } }

Sample input for bulk index:

{ "index" : { "_index" : "sort_timings", "_type" : "filling", "_id" : 1 } }
{"test":1,"took":0.0948905944824219,"type":"char","items":100}
{ "index" : { "_index" : "sort_timings", "_type" : "n^2", "_id" : 1 } }
{"items":100,"took":7.83896446228027,"test":1,"type":"char"}
{ "index" : { "_index" : "sort_timings", "_type" : "mergesort", "_id" : 1 } }
{"type":"char","test":1,"took":0.0770092010498047,"items":100}
{ "index" : { "_index" : "sort_timings", "_type" : "quicksort", "_id" : 1 } }
{"items":100,"type":"char","took":0.0829696655273438,"test":1}
{ "index" : { "_index" : "sort_timings", "_type" : "quicksort", "_id" : 2 } }
{"items":100,"type":"char","test":2,"took":0.0720024108886719}
{ "index" : { "_index" : "sort_timings", "_type" : "mergesort", "_id" : 2 } }
{"items":100,"type":"char","took":0.0770092010498047,"test":2}
{ "index" : { "_index" : "sort_timings", "_type" : "n^2", "_id" : 2 } }
{"items":100,"test":2,"took":7.31897354125977,"type":"char"}
{ "index" : { "_index" : "sort_timings", "_type" : "filling", "_id" : 2 } }
{"type":"char","took":0.0760555267333984,"test":2,"items":100}

I setup the histogram panel in "total" mode, in a way that I put the
"test" field in place of the Time Field, and the "took" field in place
of the Value Field (as in, it "took" that much of milliseconds to
complete that particular "test"). But the histogram panel won't play
ball with me; it just places what looks like to me month/year (03/70,
05/70 etc...) numbers on the X axis (derived from the "test" field's
values, being treated as Unix timestamps, I presume), and only one value
gets displayed in the histogram, and its color spans across its whole
length.

OTOH, on the (auto-generated) pie chart I can nicely see the four equal
slices of pies, corresponding to the four separate types, each
distinguished with a separate color. Something that I would like to
achieve in the histogram panel also: to represent each type of
measurement with a different color, placing the milliseconds on the Y
axis linked with the test number on the X axis.

(warning, awesome ascii art follows)

   ^

2000|
| o o
T ...|o o o o o ... ... ... o: merge
i ...|
m | x x x: quick
e 200|x x x x ... ... ... x
(ms) | q q: n^2
100|q q ... ... ...
| q q q q
-+----------------------------------->
Test: 1 2 3 4 5 6 ... ... ... 50

Is this kind of a shenanigan possible?

Thanks in advance for any pointers and clue bats,
Daniel

--
LÉVAI Dániel
PGP key ID = 0x83B63A8F
Key fingerprint = DBEC C66B A47A DFA2 792D 650C C69B BE4C 83B6 3A8F

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


(LEVAI Daniel) #2

On cs, okt 31, 2013 at 22:59:21 +0100, LEVAI Daniel wrote:

Hi!

I'm new to the list, so, hey to everyone :slight_smile:

What I would like to do, is {mis,ab}use Kibana's histogram panel in a
way, that it wouldn't display timestamps on the X axis.
I have measurements of stuff, let's say algorithm runtimes. I have four
types under an index:
[...]
^
2000|
| o o
T ...|o o o o o ... ... ... o: merge
i ...|
m | x x x: quick
e 200|x x x x ... ... ... x
(ms) | q q: n^2
100|q q ... ... ...
| q q q q
-+----------------------------------->
Test: 1 2 3 4 5 6 ... ... ... 50
[...]

Hey guys, anyone? Is something so fishy with this that no one could
grasp it? :wink: or is this too complicated, and I should break it down to
smaller problems?

If someone could elaborate on how to display multiple fields (=values)
in a selected _type on a histogram, that would be very helpful for
starters. I'm stumbling through the panel's settings, but it won't give
me any slack.

Thanks,
Daniel

--
LÉVAI Dániel
PGP key ID = 0x83B63A8F
Key fingerprint = DBEC C66B A47A DFA2 792D 650C C69B BE4C 83B6 3A8F

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


(system) #3