Creating a custom table visualization


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.

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.

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,

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.