I have fields like txn_id and txn_chain_id where txn_chain_id can have more than 1 txn_id like:
Log 1: .....txn_id=100 txn_chain_id=1000 Log 2: .....txn_id=101 txn_chain_id=1000 Log 3: .....txn_id=102 txn_chain_id=1000 Log 4: .....txn_id=201 txn_chain_id=2000 Log 5: .....txn_id=202 txn_chain_id=2000
And so on.
I wish to write a search which gives me output as below, dynamically pulling all the txn_chain_ids having txn_ids > 1.
txn_chain_id count(txn_id) 1000 3 2000 2
Can someone help me getting the search?
Please do the needful.