Dashboard for 3 level of aggregation in kibana

Elastic Stack Kibana
1

I have a document type
doc1
{
event_timestamp:
event_type:
store_id:
}

    GET /internship40/_search
    {
  "query": 
  {
   "bool":
    {
      "must":
      [
        {
          "match" :
          {
            "attributes.store_id" : "41b15888-0c2f-48f9-89d0-dc7aad19f52b"
          }
        },
        {
          "match":
          {
            "event_type":"app_sent_heartbeat"
          }
        }
      ]
    }
  },

     "aggs":
  
  {
    "my_date_histo":{
      "date_histogram":{
        "field":"arrival_timestamp",
        "interval":"day"
      },
      "aggs":
      {
        "distinct_hours": {      
       "cardinality": {
        "script": {
          "lang": "painless",
          "source": "doc[params.date_field].value.hourOfDay;",
          "params": {
            "date_field": "arrival_timestamp"
          }
        }
      }
      
    },
    "distinct_hours2":
    {
      "bucket_script":
      {
        "buckets_path":
        {
        "temp2":"distinct_hours"
      },
        "script":"params.temp2/24"
        
          
        
      }
    },
    "cumulative_hours": {
                    "cumulative_sum": {
                        "buckets_path": "distinct_hours2"
                    }
    
    
      }
      
      
    },
    "avg_daily_sales": {
      "avg_bucket": {
        "buckets_path": "distinct_hours2" 
      }
    }
    
}
}
}

I want to run this query in dev tool (console) and show the output in dashboard. Is it possible?

2

Hello,
You cannot integrate dev console results in the dashboard. You could maybe translate that query in a saved search, not sure exactly what you want to display/achieve.

3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.