# Dashboard for 3 level of aggregation in kibana

**URL:** <https://discuss.elastic.co/t/dashboard-for-3-level-of-aggregation-in-kibana/191186>\
**Category:** Kibana\
**Created:** [July 18, 2019, 11:32am UTC](https://discuss.elastic.co/t/dashboard-for-3-level-of-aggregation-in-kibana/191186 "2019-07-18T11:32:11Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![A\_google\_user](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/a_google_user/32/46709_2.png) [@A\_google\_user](https://discuss.elastic.co/u/A_google_user)\
**Post date:** [July 18, 2019, 11:32am UTC](https://discuss.elastic.co/t/dashboard-for-3-level-of-aggregation-in-kibana/191186/1 "2019-07-18T11:32:11Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\
**Post date:** [July 18, 2019, 5:32pm UTC](https://discuss.elastic.co/t/dashboard-for-3-level-of-aggregation-in-kibana/191186/2 "2019-07-18T17:32:27Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [August 15, 2019, 5:32pm UTC](https://discuss.elastic.co/t/dashboard-for-3-level-of-aggregation-in-kibana/191186/3 "2019-08-15T17:32:28Z")

</div>

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