fbaligand / kibana-enhanced-table

Kibana visualization like a Data Table, but with enhanced features like computed columns, filter bar, and “Split Cols” bucket
Apache License 2.0
309 stars 64 forks source link

Grouping and renaming of column titles #48

Open ChrisGibb opened 5 years ago

ChrisGibb commented 5 years ago

Hi Thanks for this wonderful plugin.. I'm exploring it's functionality now and I think it's going to be great.

However, I have a question somewhat related to #45 + another one.

Rename Columns

I am using the "Split Columns" feature to break out totals based on a keyword (they're different vat rates)

Then, to rename my columns I'm doing a bit of hacky approach and creating a calculated column, for each VAT rate column, and simple directing them to copy the values from my source columns e.g.

Computed column 1 formula = col1, Computed column 2 formula = col2, etc

Then I'm setting custom labels, and hiding columns 1,2,3 ... etc.

This works, but seems a bit nasty. It would be wonderful to have some kind of label mapping over the columns generated from the "Split Cols" function.

Group Columns

I would like to be able to group columns with another label.

My original enhanced table looks something like this (the labels are from my generated columns):

image

And I'd like to add group titles like this:

Selection_069

I would add this request, that I'd be willing to sponsor this change if that will help.

fbaligand commented 5 years ago

Hi,

For your first feature request, I'm not sure to understand what kind of renaming you need. Can you give some concrete example? Concerning your "hack"', I understand you add computed column to have a "complementary" custom label. But I don't understand why you add several computed columns. Only one should be enough. Do you use "Computed/Hidden cols per split col" option? It allows to have your(s) computed column(s) per 'Split Cols' bucket. By the way, maybe another way to get what you need is to create a Kibana scripted field, which value is equals to your bucket field, but you define a custom formater.

For second feature request, if I understand well, it is also only when you use 'Split Cols' bucket and so, have a grouped column per 'Split Cols' bucket? IMHO it seems to complex/specific to implement. You can potentially get the same grouping using "Split Tables". I guess it is not exactly what you want :)