Hi,

I have an index which keeps track of user transactions:

`Table 1`

user | paid_amount | date |
---|---|---|

a | 100 | 2019-10-09T10:00:00.00Z |

a | 100 | 2019-10-09T10:05:00.00Z |

a | 100 | 2019-10-09T10:10:00.00Z |

a | 200 | 2019-10-09T10:25:00.00Z |

b | 100 | 2019-10-09T10:00:00.00Z |

c | 200 | 2019-10-09T10:00:00.00Z |

From this, I extract the following data:

`Table 2`

user | avg_trans_amount |
---|---|

a | 125 |

b | 100 |

c | 200 |

So far so good.

Now, what I need to do is: from the extracted data, I need to create a new table creating tiers using the values from the avg_trans_amount, as well as add custom operations on the resulting values, as follows (values in parenthesis are just to visualize the math)

`Table 3`

min | max | count | math1 ('max'* 'count') | math2 (sum of 'math1' from current row) |
---|---|---|---|---|

1 | 100 | 1 (b) | 100 ( 100 * 1 ) | 500 (100 + 400 + 0) |

101 | 200 | 2 (a,c) | 400 (200 * 2 ) | 400 (400 + 0) |

201 | Infinity | 0 | 0 ( 0 * 0 ) | 0 ( 0 ) |

I was also asked to make a bar graph of the tiers (`Table 3`

) using max as the x axis and count as y

Is there any way of creating such a graph and table in Kibana using visualizations?

Any help is kindly appreciated.

Thanks in advance.