DataTable Visualization Error in Kibana

[Shalvin_Kumar]

Hi Community,

I am working on generating a report through visualization in Kibana.

Here is how my visualization looks like :

Let's see the buckets I have:

1. Based on TradeDate - Working as expected.
2. Based on Underlying - Let's focus on ADS highlighted in the red box.
3. Based on Price Move

I expected the data to be in this way :

Underlying | Price Move | Txn | Cont P&L

ADS | 0.01 | 1 | 20
ADS | 0 | 71 | 0
ADS | -0.01 | 1 | -20
ADS | -0.02 | 0 | -10

However it comes like this (you can also see that in the attached picture) :

Underlying | Price Move | Txn | Cont P&L

ADS | 0.01 | 1 | 20
ADS | 0 | 44 | 0
ADS | 0 | 27 | 0
ADS | -0.01 | 1 | -20
ADS | -0.02 | 0 | -10

What I don't understand is why aren't
ADS | 0 | 44 | 0
ADS | 0 | 27 | 0

Combined into one?

Please write back if you didn't understand my issue. Thanks

[Shalvin_Kumar]

Another sample: