I need to create a heatmap that will show the success rate for the two Types of Partners. Now let me brief you about my requirement.
We have transaction-level data for two types of partners, ex: Type A, Type B, now each Type has a number of partners and we need to show the success rate in the heatmap where, in the x-axis, we have Type A Partner's names and in the y-axis, we have Type B Partner's names and color will be indicating the rate. Sample heatmap Visual is attached to visualize the requirement only.
Transactions can be successful or failed, and there is a field named "status" which has two values, i.e, "success", "fail".
I'm unable to create the heatmap using the default heatmap visual provided by kibana because we cannot use custom calculation in the default visuals. That is the reason I'm exploring vega and vega-lite to find out the solution.
My success calculation would be (Count of transactions where status=success)/(count of all transactions) * 100
I'm unable to create it using vega/vega-lite transform.
Hope I'm able to brief you properly. If you need any further information regarding the requirement, please let me know.
Please help me to build the visual.
Thanks in advance!