# Kibana(Group By Date, Get column with not '-' values

**URL:** <https://discuss.elastic.co/t/kibana-group-by-date-get-column-with-not-values/363716>\
**Category:** Kibana\
**Tags:** elastic-stack-monitoring\
**Created:** [July 24, 2024, 2:24pm UTC](https://discuss.elastic.co/t/kibana-group-by-date-get-column-with-not-values/363716 "2024-07-24T14:24:59Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![apoorvleo](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/apoorvleo/32/136268_2.png) [@apoorvleo](https://discuss.elastic.co/u/apoorvleo)\
**Post date:** [July 24, 2024, 2:24pm UTC](https://discuss.elastic.co/t/kibana-group-by-date-get-column-with-not-values/363716/1 "2024-07-24T14:24:59Z")

</div>

Hi Team,  
I have a row let's say  
ProcessId, TimeStamp, isvcTransactionId, instanceId  
-\> a, b, c, null  
-\> a, b, null, d  
-\> a, b, null, -  
-\> a, b, null, e

I want to create a single row in visualization or aggregation like this(using Common Timestamp)  
-\> ProcessId, TimeStamp, isvcTransactionId, instanceId  
-\> a, b, c, d

I am using aggregation-based, but it concatenates the last 2 rows  
and the result I get

ProcessId, TimeStamp, isvcTransactionId, instanceId  
-\> a, b, c, [d,-,e]

As I want to filter c, and d,e in the future, How can I achieve this? I am okay with concatenation but I can't filter on individual values of a concatenated list

---

<div class="post-metadata">

**Author:** ![bhavyarm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bhavyarm/32/22392_2.png) [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)\
**Post date:** [July 29, 2024, 9:34pm UTC](https://discuss.elastic.co/t/kibana-group-by-date-get-column-with-not-values/363716/2 "2024-07-29T21:34:42Z")

</div>

Hello,

Which version of the stack are you using? and where and which kind of visualization you are trying to make? Which type in aggregation-based?

Thanks,  
Bhavya