# Dynamically created charts (unknown data) **URL:** \ **Category:** Kibana\ **Created:** [July 12, 2018, 12:44pm UTC](https://discuss.elastic.co/t/dynamically-created-charts-unknown-data/139754 "2018-07-12T12:44:15Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![ArthurName](https://avatars.discourse-cdn.com/v4/letter/a/8e8cbc/32.png) [@ArthurName](https://discuss.elastic.co/u/ArthurName)\ **Post date:** [July 12, 2018, 12:44pm UTC](https://discuss.elastic.co/t/dynamically-created-charts-unknown-data/139754/1 "2018-07-12T12:44:15Z")
Can Kibana operate on unknown data? A simple example: Logstash imports from an SQL database. The database contains a table with, let's say, names of fruits, how many there are of each at a given date: apple 2018-07-01 0 apple 2018-07-02 1 apple 2018-07-03 0 apple 2018-07-04 3 pear 2018-07-03 0 pear 2018-07-04 1 Now I want a visualization of the amount of apples over time. And the same goes for the pear, and so on. The key point being that the fruits are unknown. I just want charts for whatever is there, and that they are created automatically somehow (every morning would be sufficient). Given the facts that you're advised _not_ to use the .kibana ES index [1], and that the Kibana Saved Objects API is experimental [2], is poorly documented and has known issues [3]: How do I get Kibana to dynamically generate visualizations like this? Is it even possible? Or do I need a plugin? [1] [https://www.elastic.co/guide/en/kibana/current/saved-objects-api.html](https://www.elastic.co/guide/en/kibana/current/saved-objects-api.html) [2] [https://www.elastic.co/guide/en/kibana/current/saved-objects-api-get.html](https://www.elastic.co/guide/en/kibana/current/saved-objects-api-get.html) [3] [https://www.elastic.co/guide/en/kibana/current/saved-objects-api-create.html](https://www.elastic.co/guide/en/kibana/current/saved-objects-api-create.html) ---
**Author:** ![Nathan\_Reese](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nathan_reese/32/84829_2.png) [@Nathan\_Reese](https://discuss.elastic.co/u/Nathan_Reese)\ **Post date:** [July 12, 2018, 3:25pm UTC](https://discuss.elastic.co/t/dynamically-created-charts-unknown-data/139754/2 "2018-07-12T15:25:06Z")
Have you tried making a `split` chart. A `split` chart will create a new chart per bucket returned by an aggregation. In your case, you could `split` with a terms chart on the fruit field. That way you would have a chart per `fruit` term. Below is an example of a `split` chart where the splitting is done one the machine os field. ![33%20AM](https://us1.discourse-cdn.com/elastic/original/3X/1/2/12a92d11a741f93b57d14763c9572ede0c9a7bdf.png) ---
**Author:** ![ArthurName](https://avatars.discourse-cdn.com/v4/letter/a/8e8cbc/32.png) [@ArthurName](https://discuss.elastic.co/u/ArthurName)\ **Post date:** [July 13, 2018, 9:18am UTC](https://discuss.elastic.co/t/dynamically-created-charts-unknown-data/139754/3 "2018-07-13T09:18:01Z")
Thanks for you response, Nathan. Your suggestion results in one visualization for all fruits though. What I need is one visualization for each fruit. The fruit example is an analogy for something that there's hundreds of; all of them in on one page is neither useful, nor efficient. Furthermore, they will be multiplied by other factors (also of unknown values). The instruction will be something like "for all X, on Y, with Z, create a chart". Is this just not a thing that Kibana is capable of? ---
**Author:** ![Nathan\_Reese](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nathan_reese/32/84829_2.png) [@Nathan\_Reese](https://discuss.elastic.co/u/Nathan_Reese)\ **Post date:** [July 13, 2018, 11:57am UTC](https://discuss.elastic.co/t/dynamically-created-charts-unknown-data/139754/4 "2018-07-13T11:57:05Z")
You can open an [feature request](https://github.com/elastic/kibana/issues/new?template=Feature_request.md). ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [August 10, 2018, 11:57am UTC](https://discuss.elastic.co/t/dynamically-created-charts-unknown-data/139754/5 "2018-08-10T11:57:07Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.