1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
|
// This file is autogenerated, DO NOT EDIT
// transform/examples.asciidoc:40
[source, python]
----
resp = client.transform.preview_transform(
source={
"index": "kibana_sample_data_ecommerce"
},
dest={
"index": "sample_ecommerce_orders_by_customer"
},
pivot={
"group_by": {
"user": {
"terms": {
"field": "user"
}
},
"customer_id": {
"terms": {
"field": "customer_id"
}
}
},
"aggregations": {
"order_count": {
"value_count": {
"field": "order_id"
}
},
"total_order_amt": {
"sum": {
"field": "taxful_total_price"
}
},
"avg_amt_per_order": {
"avg": {
"field": "taxful_total_price"
}
},
"avg_unique_products_per_order": {
"avg": {
"field": "total_unique_products"
}
},
"total_unique_products": {
"cardinality": {
"field": "products.product_id"
}
}
}
},
)
print(resp)
----
|
