hello everyone
I a new kibana, please help me
{
"_index": "pos_user",
"_type": "_doc",
"_id": "19cca049-b5c0-4dde-8387-edeafdf9303b",
"_version": 1,
"_score": null,
"_source": {
"id": "19cca049-b5c0-4dde-8387-edeafdf9303b",
"username": "vuimobi",
"sponsername": "victor2233",
"email": "vuimobi@yopmail.com",
"first_name": "",
"last_name": "",
"country": "VN",
"available_balances_internal": 0,
"available_balances_external": 0.6289,
"gross_sales": 0,
"total_members": 0,
"total_invested": 0,
"created_at": "2019-11-03T14:15:20.368Z",
"transactions": [
{
"id": "361febd0-0afa-4a3d-b9c9-dfa1615b5800",
"tx_id": "",
"address": "0x6BeD2Ff860f5159911d44b082A0B80A3D46eb265",
"coin": "ETH",
"t_type": "withdrawal",
"t_status": "completed",
"amount": 0.00666178,
"estimated_usd": 1,
"wallet_type": "",
"created_at": "2019-11-24T05:22:16.087Z"
},
{
"id": "311e1332-e799-4857-92ce-cc1a00e21bc9",
"tx_id": "",
"address": "0xa9B830EFadF0095E47FD1Ce49f7E5857BAE59C3A",
"coin": "ETH",
"t_type": "withdrawal",
"t_status": "completed",
"amount": 0.0054038,
"estimated_usd": 1,
"wallet_type": "",
"created_at": "2019-11-04T13:40:28.467Z"
},
{
"id": "bd532d68-832d-44af-a715-eabc928e7ed9",
"tx_id": "",
"address": "0x61cb0DDE7936697c5E98EC360d72dAF409c75a04",
"coin": "ETH",
"t_type": "withdrawal",
"t_status": "completed",
"amount": 0.00552105,
"estimated_usd": 1,
"wallet_type": "",
"created_at": "2019-11-03T14:28:05.643Z"
},
{
"id": "2c3b087b-2a7d-4907-858c-340d375e90a9",
"tx_id": "c43b2e40561efc49e0c547a99f5c7c704b71f99d8e43fc12840ac2431fa2af60",
"address": "0xaf4D50Cd3E308C6519E577A075Fc00AdCfcA2a5C",
"coin": "ETH",
"t_type": "deposit",
"t_status": "completed",
"amount": 0.02,
"estimated_usd": 3.6289,
"wallet_type": "",
"created_at": "2019-11-03T14:17:31.594Z"
}
],
"commission_histories": ,
"profit_histories": ,
"outside_transfers": ,
"inside_transfers": ,
"user_packages":
},
"fields": {
"created_at": [
"2019-11-03T14:15:20.368Z"
],
"transactions.created_at": [
"2019-11-03T14:17:31.594Z",
"2019-11-03T14:28:05.643Z",
"2019-11-04T13:40:28.467Z",
"2019-11-24T05:22:16.087Z"
]
},
"highlight": {
"email": [
"@kibana-highlighted-field@vuimobi@/kibana-highlighted-field@@@kibana-highlighted-field@yopmail.com@/kibana-highlighted-field@"
]
},
"sort": [
1572790520368
]
}
I would like filter field "transactions" and type is "t_type": "withdrawal",
and sum all "estimated_usd": 1,
Thank very much!