Creating a custom table visualization

Elastic Stack Kibana
1

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.

2

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.

3

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

4

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