# Getting rid of the null value from Lens Table

**URL:** <https://discuss.elastic.co/t/getting-rid-of-the-null-value-from-lens-table/281854>\
**Category:** Elasticsearch\
**Tags:** docker\
**Created:** [August 18, 2021, 3:51pm UTC](https://discuss.elastic.co/t/getting-rid-of-the-null-value-from-lens-table/281854 "2021-08-18T15:51:50Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![bailarch](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bailarch/32/92546_2.png) [@bailarch](https://discuss.elastic.co/u/bailarch)\
**Post date:** [August 18, 2021, 3:51pm UTC](https://discuss.elastic.co/t/getting-rid-of-the-null-value-from-lens-table/281854/1 "2021-08-18T15:51:50Z")

</div>

Hello everyone,

I have a list of projects in the column and a list of users for the rows.  
I eventually want to make a table where it shows 'who are working on each project'

This is my starting point but not sure how to have a clean list of users for each project... I know I set up the table in a way where it WILL show everyone on the row thus null values will be shown.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/3/6/36bd884a1f81176846d28b46389a4940db1632d6.png)

Can I achieve that from Dashboard Lens? Is there another tool that I need to use? Thank you!

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [September 15, 2021, 3:52pm UTC](https://discuss.elastic.co/t/getting-rid-of-the-null-value-from-lens-table/281854/2 "2021-09-15T15:52:33Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.