2022-02-23 11:02:55 Cust=A1,txn_num=12,txn_status=success 2022-02-23 11:02:55 Cust=A1,txn_num=7,txn_status=failed 2022-02-23 11:02:55 Cust=A1,txn_num=18,txn_status=awaiting 2022-02-23 11:04:55 Cust=A2,txn_num=13,txn_status=success 2022-02-23 11:04:55 Cust=A2,txn_num=18,txn_status=failed 2022-02-23 11:04:55 Cust=A2,txn_num=26,txn_status=awaiting 2022-02-23 11:06:55 Cust=A3,txn_num=12,txn_status=success 2022-02-23 11:06:55 Cust=A3,txn_num=7,txn_status=failed 2022-02-23 11:06:55 Cust=A3,txn_num=18,txn_status=awaiting 2022-02-23 11:15:55 Cust=A4,txn_num=13,txn_status=success 2022-02-23 11:15:55 Cust=A4,txn_num=18,txn_status=failed 2022-02-23 11:15:55 Cust=A4,txn_num=26,txn_status=awaiting 2022-02-23 11:25:55 Cust=A5,txn_num=12,txn_status=success 2022-02-23 11:25:55 Cust=A5,txn_num=7,txn_status=failed 2022-02-23 11:25:55 Cust=A5,txn_num=18,txn_status=awaiting 2022-02-23 11:30:55 Cust=A6,txn_num=13,txn_status=success 2022-02-23 11:30:55 Cust=A6,txn_num=18,txn_status=failed 2022-02-23 11:30:55 Cust=A6,txn_num=18,txn_status=awaiting
what im trying to achieve is to create a bar chart for each cust i need the status for the timeframe
i would the divide the cust by trellis but for each cust i can't get the bar height based on txn_num and split by status something like below
... View more