# Graph without any aggregation in Kibana

**URL:** <https://discuss.elastic.co/t/graph-without-any-aggregation-in-kibana/241594>\
**Category:** Kibana\
**Created:** [July 17, 2020, 7:27am UTC](https://discuss.elastic.co/t/graph-without-any-aggregation-in-kibana/241594 "2020-07-17T07:27:22Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![liron\_gofberg](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/liron_gofberg/32/59823_2.png) [@liron\_gofberg](https://discuss.elastic.co/u/liron_gofberg)\
**Post date:** [July 17, 2020, 7:27am UTC](https://discuss.elastic.co/t/graph-without-any-aggregation-in-kibana/241594/1 "2020-07-17T07:27:22Z")

</div>

I have graph without any aggregation and I want to show it in Kibana  
How can I do that?

I’ve already tried to do that in Vega but it’s a static graph and it’s not advanced and I want the graph to show millions of points and not just 1000  
In excel there is a scatter graph

maximize window size is not the solution because the dashboard can’t handle with that

![image](https://us1.discourse-cdn.com/elastic/original/3X/5/c/5cd8488845e3376c711ab17e063a2ca4f46c75a8.jpeg)

How can I do that in Kibana ?

---

<div class="post-metadata">

**Author:** ![defalt](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/defalt/32/71379_2.png) [@defalt](https://discuss.elastic.co/u/defalt)\
**Post date:** [July 17, 2020, 7:42am UTC](https://discuss.elastic.co/t/graph-without-any-aggregation-in-kibana/241594/2 "2020-07-17T07:42:48Z")

</div>

Hi,  
unfortunately kibana doesn't like graphs without aggregation. Million of points are also too much for standard kibana. I am pretty sure you will need vega for this. I also had to plot raw data and vega was a lifesaver. Have a look into **vega scatter plots**. They should do the trick:

> **[Zoomable Scatter Plot Example](https://vega.github.io/vega/examples/zoomable-scatter-plot/)**
>
> Vega - A Visualization Grammar. Vega is a visualization grammar, a declarative format for creating, saving, and sharing interactive visualization designs. With Vega, you can describe the visual appearance and interactive behavior of a visualization...

  

> **[Scatterplot](https://vega.github.io/vega-lite/examples/point_2d.html)**
>
> A scatterplot showing horsepower and miles per gallons for various cars.

Also: Are those 1Mio points in 1Mio documents? If so you will have to change kibana settings because kibana fetches 10.000 Documents at max.  
Maybe my raw data vega script helps you. Have a [look.](https://discuss.elastic.co/t/how-to-plot-raw-data-using-vega/238259/24)

Good luck.

---

<div class="post-metadata">

**Author:** ![liron\_gofberg](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/liron_gofberg/32/59823_2.png) [@liron\_gofberg](https://discuss.elastic.co/u/liron_gofberg)\
**Post date:** [July 17, 2020, 8:24am UTC](https://discuss.elastic.co/t/graph-without-any-aggregation-in-kibana/241594/3 "2020-07-17T08:24:13Z")

</div>

Graph with 10000 have no meaning for my case  
I need to see minimum of 1 million results  
And yes, 1 million points in 1 million documents  
I used Vega but it was useless because of the limit (10000)  
So it’s not possible to show millions of points in one single raw data graph in Kibana?

As I said, the consequence of changing Kibana settings (Maximize max window size to 1000000 ) was horrible  
I needed to restart Kibana  
My Vega visualization was no available 😞  
In your example you handle with that amount of data?

---

<div class="post-metadata">

**Author:** ![defalt](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/defalt/32/71379_2.png) [@defalt](https://discuss.elastic.co/u/defalt)\
**Post date:** [July 17, 2020, 8:34am UTC](https://discuss.elastic.co/t/graph-without-any-aggregation-in-kibana/241594/4 "2020-07-17T08:34:37Z")

</div>

I set my limit to 100.000 and I have 4 fields so at max I have 400.000 results. I never tried more and one of the elastic member said that kibana gets instable if you change these settings. I think you reached the limit of kibana. I don't see any other options than:

1. Aggregation
2. Less documents
3. Use other software and not kibana.

---

<div class="post-metadata">

**Author:** ![liron\_gofberg](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/liron_gofberg/32/59823_2.png) [@liron\_gofberg](https://discuss.elastic.co/u/liron_gofberg)\
**Post date:** [July 17, 2020, 8:47am UTC](https://discuss.elastic.co/t/graph-without-any-aggregation-in-kibana/241594/5 "2020-07-17T08:47:08Z")

</div>

Thanks a lot🙃

---

<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 14, 2020, 8:47am UTC](https://discuss.elastic.co/t/graph-without-any-aggregation-in-kibana/241594/6 "2020-08-14T08:47:08Z")

</div>

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