# Kibana: using the histogram panel without timestamps

**URL:** https://discuss.elastic.co/t/kibana-using-the-histogram-panel-without-timestamps/14205
**Category:** Elasticsearch
**Created:** [October 31, 2013, 9:59pm UTC](https://discuss.elastic.co/t/kibana-using-the-histogram-panel-without-timestamps/14205 "2013-10-31T21:59:21Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![LEVAI\_Daniel](https://avatars.discourse-cdn.com/v4/letter/l/2acd7d/32.png) [@LEVAI\_Daniel](https://discuss.elastic.co/u/LEVAI_Daniel)
#### Post date: [October 31, 2013, 9:59pm UTC](https://discuss.elastic.co/t/kibana-using-the-histogram-panel-without-timestamps/14205/1 "2013-10-31T21:59:21Z")

</div>

Hi!

I'm new to the list, so, hey to everyone 🙂

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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<div class="post-metadata">

### Author: ![LEVAI\_Daniel](https://avatars.discourse-cdn.com/v4/letter/l/2acd7d/32.png) [@LEVAI\_Daniel](https://discuss.elastic.co/u/LEVAI_Daniel)
#### Post date: [November 4, 2013, 1:21pm UTC](https://discuss.elastic.co/t/kibana-using-the-histogram-panel-without-timestamps/14205/2 "2013-11-04T13:21:42Z")

</div>

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

> Hi!
> 
> I'm new to the list, so, hey to everyone 🙂
> 
> 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? 😉 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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2017, 2:09am UTC](https://discuss.elastic.co/t/kibana-using-the-histogram-panel-without-timestamps/14205/3 "2017-07-06T02:09:02Z")

</div>


