Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Grouping and renaming of column titles #48

Open
ChrisGibb opened this issue Jul 2, 2019 · 1 comment
Open

Grouping and renaming of column titles #48

ChrisGibb opened this issue Jul 2, 2019 · 1 comment

Comments

@ChrisGibb
Copy link

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
Copy link
Owner

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 :)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants