Creating a custom table visualization

[kb_z]

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.

[lukas (Lukas Olson)]

I can't think of a way to accomplish this in Kibana. There might be a way after bucket script aggregations are supported, but I'm still not even sure how you would accomplish it there.

[kb_z]

Thanks for your reply.

Would it be possible to implement the table without the math* bits?

As in... create an aggregation using the output of another aggregation. Or is this something that's not supported by ES/Kibana?

Thanks in advance,
kb_z