# Add const cell values to Table Visualisation

**URL:** <https://discuss.elastic.co/t/add-const-cell-values-to-table-visualisation/362453>\
**Category:** Kibana\
**Tags:** visualisation\
**Created:** [July 3, 2024, 11:12am UTC](https://discuss.elastic.co/t/add-const-cell-values-to-table-visualisation/362453 "2024-07-03T11:12:48Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![cgame](https://avatars.discourse-cdn.com/v4/letter/c/82dd89/32.png) [@cgame](https://discuss.elastic.co/u/cgame)\
**Post date:** [July 3, 2024, 11:12am UTC](https://discuss.elastic.co/t/add-const-cell-values-to-table-visualisation/362453/1 "2024-07-03T11:12:48Z")

</div>

Hi,

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.

Best,

---

<div class="post-metadata">

**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\
**Post date:** [July 3, 2024, 12:17pm UTC](https://discuss.elastic.co/t/add-const-cell-values-to-table-visualisation/362453/2 "2024-07-03T12:17:59Z")

</div>

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.