How to display Column Data as headers (Transpose Data Table)

Elastic Stack Kibana
1

Hi Team,

I'm working on Kibana 6.0. I'm feeding data via logstash and my data is in csv format.

My Data:
Time,Status,ServiceName
2018-03-15 15:30,Up,FETCH
2018-03-15 15:30,Up,UPDATE
2018-03-15 15:30,Up,DELETE
2018-03-15 15:31,Up,FETCH
2018-03-15 15:31,Up,UPDATE
2018-03-15 15:31,Up,DELETE
2018-03-15 15:35,Up,FETCH
2018-03-15 15:35,Up,UPDATE
2018-03-15 15:35,Down,DELETE

with the above data, i have my data table as the same with Time,Status,ServiceName as column names and values as the respective column data.

My requirement here to have below:

Untitled

I would be having time as column names (dynamically) and rest of the data as shown.

Please let me know if this is possible and how can we achieve this type of visualization in Kibana.

Thanks.

2

Hey,

this is unfortunately currently not possible. Please follow ticket #3620 for updates about transposing tables.

Cheers,
Tim

3

Hi,

thanks for your response.

I'll follow the thread for more updates.

Thanks,
Sahadev

4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.