Computed Rows not possible?

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

Computed Rows not possible? #130

Closed krasnars closed 4 years ago

krasnars commented 4 years ago

Hi,

I'd like to use the Computed Columns functionality, but on Row level. Is that possible somehow?

Thanks, Arsim

fbaligand commented 4 years ago

Not sure to understand your question. Computed columns are computed per row. So basically, answer is yes. Maybe you could explain more your need?

krasnars commented 4 years ago

In the picter below you can see taht I have one row calculating the sum for every day of the week. It would be very nice if I could do some aggregations over the column "Sum of day_of_week_i" e.g. sum over all the fields. Maybe this is already possible, but I was not able to figure how it works yet and I've spent quite some hours.

Snap

fbaligand commented 4 years ago

Could you explain what you mean by “sum over all the fields”? I guess you mean “sum over all the rows”, right? If so, you can do it like this:

activate “show total” option
in your computed column, use total1 variable. It contains the sum of column no 1 (0-based index).

krasnars commented 4 years ago

yes, that does the job as well. thanks a lot :)

fbaligand commented 4 years ago

Great! So I close the issue as question is answered.