Advertisement
Guest User

Untitled

a guest
Mar 29th, 2017
50
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.30 KB | None | 0 0
  1. "aggregations" : {
  2. "level1" : {
  3. "terms" : {
  4. "field" : "country",
  5. "size" : 0,
  6. },
  7. "aggregations" : {
  8. "orderAggs" : {
  9. "terms" : {
  10. "field" : "orderId",
  11. "size" : 0,
  12. },
  13. "aggregations" : {
  14. "totalQty" : {
  15. "max" : {
  16. "field" : "targetQty"
  17. }
  18. },
  19. "timeFilterAggs" : {
  20. "filter" : {
  21. "range" : {
  22. "timeTaken" : {
  23. "from" : null,
  24. "to" : 5000,
  25. "include_lower" : true,
  26. "include_upper" : true
  27. }
  28. }
  29. },
  30. "aggregations" : {
  31. "processed" : {
  32. "max" : {
  33. "field" : "processedQty"
  34. }
  35. }
  36. }
  37. }
  38. }
  39. },
  40. "sumProcessed" : {
  41. "sum_bucket" : {
  42. "buckets_path" : [ "order>timeFilter>processed" ]
  43. }
  44. },
  45. "sumTargeted" : {
  46. "sum_bucket" : {
  47. "buckets_path" : [ "order>totalQty" ]
  48. }
  49. },
  50. "processedRatio" : {
  51. "bucket_script" : {
  52. "script" : {
  53. "inline" : "(target != 0 && target != null)? processed / target * 100:0"
  54. },
  55. "buckets_path" : {
  56. "processed" : "sumProcessed",
  57. "target" : "sumTargeted"
  58. }
  59. }
  60. }
  61. }
  62. }
  63. }
  64.  
  65. "aggregations": {
  66. "level1": {
  67. "doc_count_error_upper_bound": 0,
  68. "sum_other_doc_count": 0,
  69. "buckets": [
  70. {
  71. "key": "IN",
  72. "doc_count": 4,
  73. "orderAggs": {
  74. "doc_count_error_upper_bound": 0,
  75. "sum_other_doc_count": 0,
  76. "buckets": [
  77. {
  78. "key": "ID_1",
  79. "doc_count": 2,
  80. "totalQty": {
  81. "value": 2
  82. },
  83. "timeFilterAggs": {
  84. "doc_count": 2,
  85. "processed": {
  86. "value": 2
  87. }
  88. }
  89. },
  90. {
  91. "key": "ID_2",
  92. "doc_count": 2,
  93. "totalQty": {
  94. "value": 2
  95. },
  96. "timeFilterAggs": {
  97. "doc_count": 2,
  98. "processed": {
  99. "value": 2
  100. }
  101. }
  102. }
  103. ]
  104. },
  105. "sumProcessed": {
  106. "value": 4
  107. },
  108. "sumTargeted": {
  109. "value": 4
  110. },
  111. "processedRatio": {
  112. "value": 100.0
  113. }
  114. }]
  115. }
  116. }
  117.  
  118. "aggregations": {
  119. "level1": {
  120. "doc_count_error_upper_bound": 0,
  121. "sum_other_doc_count": 0,
  122. "buckets": [
  123. {
  124. "key": "IN",
  125. "doc_count": 77,
  126. "orderAggs": {
  127. //I don't need to include this as part of result, but I need this data for calculation
  128. },
  129. "sumProcessed": {
  130. "value": 4
  131. },
  132. "sumTargeted": {
  133. "value": 4
  134. },
  135. "processedRatio": {
  136. "value": 100.0
  137. }
  138. }]
  139. }
  140. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement