How do I put another related field below the columns?

Elastic Stack Kibana
1

I have an array of fields that I have already put in the form of columns, but my concern is that the count() appears as a metric at the bottom, but I need the date to appear, instead of count()

11
111771×329 33 KB

but what I need, to output the date related to that column, in this way,
Do I have to do it with some metric?

22
221771×329 64.5 KB

2

Could you provide some example documents?; so we could suggest to you what metric, transformation, or scripted field could help you get the desired results.

3

33

have two columns, and Within these columns I would like it to be horizontal, that is, the stop above and the time below so:

EL RECREO | MARIN .. paradas
06:05:00 | hora...

4

I don' think this is possible in Kibana (But I could be wrong), mainly because you are looking for a row to columns operation; that is something I haven't seen in Elastic DSL or any of the aggregations. However, it could be possible with some post-processing in your specific language or a SQL query (In Canvas, for example).

5

Look, with kibana lens I was able to remove the stop column horizontally, but now the problem is that the counter appears below and I want the time to appear

image
image1001×270 22 KB

6

Using your example data and a dynamic field in the data view; it's possible to get something like what you are expecting; however, given that I'm using a metric (last value), it seems to me that this is not really a solution, but a workaround with a lot of downsides:

image
image1353×655 45.1 KB

This visualization requires a dynamic field (timestamp_key) formatted from the original timestamp/date field that you are using:

image
image1010×534 57.5 KB

In my mind, at least, the transposition that you are trying to perform should be something more like this (Sorry if I'm breaking any rules for posting other tool screenshots):

image
image1213×535 44.9 KB

I hope it helps.

7

Thank you very much, you have been of great help and one last question: in which tool are you making the last graph?

8

Grafana, the query depicted in the screenshot and a "Rows to Fields" transformation, but you should try SQL in a Canvas; I'm sure that is an excellent option, and it's possible to get your visualization using SQL.