# Make one visualization per day automaticly

**URL:** <https://discuss.elastic.co/t/make-one-visualization-per-day-automaticly/53759>\
**Category:** Kibana\
**Created:** [June 23, 2016, 9:23am UTC](https://discuss.elastic.co/t/make-one-visualization-per-day-automaticly/53759 "2016-06-23T09:23:12Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kevin\_Csuka](https://avatars.discourse-cdn.com/v4/letter/k/7feea3/32.png) [@Kevin\_Csuka](https://discuss.elastic.co/u/Kevin_Csuka)\
**Post date:** [June 23, 2016, 9:23am UTC](https://discuss.elastic.co/t/make-one-visualization-per-day-automaticly/53759/1 "2016-06-23T09:23:12Z")

</div>

Hi,

Is it possible to make Kibana add one visualization per day automatically.

Use case:  
I've got a test running 24/7, which inputs data into Kibana.  
It would be handy to have a dashboard which shows data from every day, and the days to come. Reason I would this is to compare those visualizations quickly.

Right now I have to create a visualization myself, choose the time, then add it to the dashboard. This is a lot of manual work.

---

<div class="post-metadata">

**Author:** ![BigFunger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bigfunger/32/7323_2.png) [@BigFunger](https://discuss.elastic.co/u/BigFunger)\
**Post date:** [June 23, 2016, 3:15pm UTC](https://discuss.elastic.co/t/make-one-visualization-per-day-automaticly/53759/2 "2016-06-23T15:15:59Z")

</div>

All of the dashboards and visualizations are in the .kibana (by default) index. You could use the existing data as a guide and write something that generated a new document in that index each day.

Questions:

1. How many days worth of these visualizations do you want/need to show at a time?
2. How are you accomplishing the single visualization per day?
3. Why are you structuring this with a separate visualization per day? Is this something that could be accomplished with a Split Chart X-axis Sub Aggregation to split a single visualization into something like 'the last 5 days'?

Can you provide a screen shot/ json documents of your current layout?

---

<div class="post-metadata">

**Author:** ![Kevin\_Csuka](https://avatars.discourse-cdn.com/v4/letter/k/7feea3/32.png) [@Kevin\_Csuka](https://discuss.elastic.co/u/Kevin_Csuka)\
**Post date:** [June 23, 2016, 3:53pm UTC](https://discuss.elastic.co/t/make-one-visualization-per-day-automaticly/53759/3 "2016-06-23T15:53:24Z")

</div>

> [@BigFunger](#):
>
> 1. How many days worth of these visualizations do you want/need to show at a time?

1 visualization per day. And in one dashboard 14 days / visualizations.

> [@BigFunger](#):
>
> .2 How are you accomplishing the single visualization per day?

I don't know. That is what I am asking here. There is data being put in Elasticsearch each day.

> [@BigFunger](#):
>
> 3 Why are you structuring this with a separate visualization per day? Is this something that could be accomplished with a Split Chart X-axis Sub Aggregation to split a single visualization into something like 'the last 5 days'?

Don't know, will test on Monday!

My current tempalte ` {
    "template": "ac-*",
    "settings": {
        "number_of_shards": 1,
        "number_of_replicas": 0,
        "index.refresh_interval": "10s"
    },
    "mappings": {
        "logs": {
            "properties": {
                "@timestamp": {
                    "type": "date",
					"format" : "strict_date_optional_time||epoch_millis"
                },
                "elapsed": {
                    "type": "integer"
                },
                "url": {
                    "type": "string",
					"index": "not_analyzed"
                },
                "responseCode": {
                    "type": "string",
					"index": "not_analyzed"
                },
				"responseMessage": {
                    "type": "string",
					"index": "not_analyzed"
                },
                "threadName": {
                    "type": "string",
					"index": "not_analyzed"
                },
                "success": {
                    "type": "string",
					"index": "not_analyzed"
                },
                "Users": {
                    "type": "integer"
                },
                "allThreads": {
                    "type": "long"
                },
                "Latency": {
                    "type": "long"
                },
                "Hostname": {
                    "type": "string",
					"index": "not_analyzed"
                },
				"path": {
                    "type": "string",
					"index": "not_analyzed"
                },
				"Connect": {
                    "type": "integer"
                }
            }
		}
	}
} `

---

<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:** [July 6, 2017, 1:49pm UTC](https://discuss.elastic.co/t/make-one-visualization-per-day-automaticly/53759/4 "2017-07-06T13:49:28Z")

</div>