How to plot a bar chart for each customer's status for timeframe?

[venky1544]

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 

[somesoni2]

Try something like this (Replace everything before "| chart" command with your current search which extracts fields "Cust", "txn_num", and "txn_status")

|makeresults | eval temp="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" | table temp | makemv temp delim="#" | mvexpand temp | rename temp as _raw | extract 
| chart values(txn_num) by Cust txn_status

[venky1544]

somesoni2 Thank you for the revert 

what i need is a timestamp in the x-axis if you check my screenshot in the query for each client showing the status with count of txn_num for each status in a span of 5 min