Add const cell values to Table Visualisation


Is it possible to make a Table visualization where one column have constant values in it, declared at lens-setup time ? It doesn't seem so but I'd like to be sure.


Hi @cgame

it would be technically possible, although it depends a bit on the actual table setup.

If you have a 8.14 ELK stack version on newer, you can use ES|QL for this.

Otherwise Lens formula it's your route.
If it's a column amongst other metric columns, just create a formula with the constant value in it.
If there's only the constant column, you need to simulate a metric in order to retrieve some bucketing from ES. So a formula like count() - count() + CONSTANT should work.