# Kibana Vega - How to display multiple results in a date histogram

**URL:** https://discuss.elastic.co/t/kibana-vega-how-to-display-multiple-results-in-a-date-histogram/208713
**Category:** Kibana
**Tags:** vega
**Created:** [November 20, 2019, 2:20pm UTC](https://discuss.elastic.co/t/kibana-vega-how-to-display-multiple-results-in-a-date-histogram/208713 "2019-11-20T14:20:06Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Amphagory](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/amphagory/32/46127_2.png) [@Amphagory](https://discuss.elastic.co/u/Amphagory)
#### Post date: [November 20, 2019, 2:20pm UTC](https://discuss.elastic.co/t/kibana-vega-how-to-display-multiple-results-in-a-date-histogram/208713/1 "2019-11-20T14:20:06Z")

</div>

I am wonder if it is possible to display more than one aggregated result in a date histogram?

My Vega query is

```auto
{
  $schema: https://vega.github.io/schema/vega-lite/v2.json
  title: Daily Count

  data: {
    url: {
      %context%: true
      %timefield%: @timestamp
      index: my_index
      body: {
        size: 0      
        aggs: {
          time_buckets: {
            date_histogram: {
              field: @timestamp
              calendar_interval: day
              min_doc_count: 0
            }
            aggs: {
              a_call_sum: {
                sum: {
                  field: a_call
                }
              }
              e_call_sum: {
                sum: {
                  field: e_call
                }
              }
            }
          }
        }
      }
    }
    format: {property: "aggregations.time_buckets.buckets"}
  }
  
  mark: bar
  
  encoding: {
    x: {
      field: key
      type: temporal
      axis: {title: false}
    }
    y: {
      field: a_call_sum.value
      type: quantitative
      axis: {title: "Call count"}
    }
  }
}

I was wondering if it is possible to display both a_call_sum and e_call_sum in the same visual side by side in their respective bin/interval or maybe I am using the wrong visual type?
```

---

<div class="post-metadata">

### Author: ![alisongoryachev](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alisongoryachev/32/111352_2.png) [@alisongoryachev](https://discuss.elastic.co/u/alisongoryachev)
#### Post date: [November 21, 2019, 4:43pm UTC](https://discuss.elastic.co/t/kibana-vega-how-to-display-multiple-results-in-a-date-histogram/208713/2 "2019-11-21T16:43:16Z")

</div>

Hi @Amphagory!

This [Discuss post](https://discuss.elastic.co/t/kibana-vega-viz-plug-in-multiple-aggregations-how-to/121893/2) looks similar to your request.

Have you looked into using [flatten transform](https://vega.github.io/vega/docs/transforms/flatten/)? Another option might be to use [composite aggregation](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-composite-aggregation.html).

---

<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: [December 19, 2019, 4:43pm UTC](https://discuss.elastic.co/t/kibana-vega-how-to-display-multiple-results-in-a-date-histogram/208713/3 "2019-12-19T16:43:19Z")

</div>

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