Hello all,

i would like to know if this kind of tables can be done with kibana and add it to a dasboard. What is the best approach to achieve this?

**Index structure**

```
{
"gain_loss" => " 1,011.53",
"@timestamp" => 2020-01-06T23:00:00.000Z
}
```

**Goal**: make calculations over gain_loss field and create a view in table/s format like this:

```
Daily basis
Sum positives: 1000
Sum negatives: -3000
Sum positives / Sum negatives ratio: 0,33
Max positive: 1300
Max negative: -2000
Avg: 200
Monthly basis
Sum positives: 3000
Sum negatives: -6000
Sum positives / Sum negatives ratio: 0,5
Max positive: 2000
Max negative: -3000
Avg: 700
```

Best regards