Hi @bowesmana, As you suggested We tried below query, but i am getting same values for each msgs strings. Can you please let me know is my query correct?? index=app-index source=application.logs
|rex field= _raw "RampData :\s(?<RampdataSet>\w+)"
| eval msgs=split("Initial message received with below details,Letter published correctley to ATM subject,Letter published correctley to DMM subject,Letter rejected due to: DOUBLE_KEY,Letter rejected due to: UNVALID_LOG,Letter rejected due to: UNVALID_DATA_APP",",")
| mvexpand msgs
| rex field=msgs "(Initial message |Letter published correctley to |Letter rejected due to: )(?<reason>.*)"
|chart count over RampdataSet by reason
|addtotals OUTPUT: Rails below details ATM subject DMM subject DOUBLE_KEY UNVALID_LOG UNVALID_DATA_APP Total WAC 0 0 0 0 0 0 0 WAX 15 15 15 15 15 15 90 WAM 20 20 20 20 20 20 120 STC 12 12 12 12 12 12 72 STX 30 30 30 30 30 30 180 OTP 10 10 10 10 10 10 60 TTC 5 5 5 5 5 5 30 TAN 7 7 7 7 7 7 42 TXN 10 10 10 10 10 10 60 WOU 12 12 12 12 12 12 72
... View more