I have an index which keeps track of user transactions:
From this, I extract the following data:
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)
|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.