# Difficulty Creating a time series line chart **URL:** https://discuss.elastic.co/t/difficulty-creating-a-time-series-line-chart/40402 **Category:** Kibana **Created:** [January 28, 2016, 6:12pm UTC](https://discuss.elastic.co/t/difficulty-creating-a-time-series-line-chart/40402 "2016-01-28T18:12:12Z") **Posts on this page:** 10 **Page:** 1
### Author: ![mc1392](https://avatars.discourse-cdn.com/v4/letter/m/57b2e6/32.png) [@mc1392](https://discuss.elastic.co/u/mc1392) #### Post date: [January 28, 2016, 6:12pm UTC](https://discuss.elastic.co/t/difficulty-creating-a-time-series-line-chart/40402/1 "2016-01-28T18:12:12Z")
In Kibana 4.2.1, I have data loaded like so: \*\* Member Type |Count |@timestamp\*\* - Member Type A | 234 | 2016-01-28 - Member Type B | 345 | 2016-01-28 - Member Type C | 187 | 2016-01-28 I don't understand how to get a line graph showing the 'Member Type' count changes over time. How can I get a chart showing the change in membership categories over time? ---
### Author: ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas) #### Post date: [January 28, 2016, 8:35pm UTC](https://discuss.elastic.co/t/difficulty-creating-a-time-series-line-chart/40402/2 "2016-01-28T20:35:36Z")
Does the data itself contain a `count` field that you are trying to visualize, or are you trying to perform a count aggregation over your data? ---
### Author: ![mc1392](https://avatars.discourse-cdn.com/v4/letter/m/57b2e6/32.png) [@mc1392](https://discuss.elastic.co/u/mc1392) #### Post date: [January 28, 2016, 9:35pm UTC](https://discuss.elastic.co/t/difficulty-creating-a-time-series-line-chart/40402/3 "2016-01-28T21:35:10Z")
I was able to solve this problem. The data itself does contain a count field called 'Count', instead of loading all the data for Kibana to perform the count. Here is a screen shot of my settings. I have 16 categories of 'Member Type'. ![](https://us1.discourse-cdn.com/elastic/original/2X/4/44c626fcc15323e98d872e36194e1f8515924b81.png) ---
### Author: ![mc1392](https://avatars.discourse-cdn.com/v4/letter/m/57b2e6/32.png) [@mc1392](https://discuss.elastic.co/u/mc1392) #### Post date: [February 2, 2016, 2:48pm UTC](https://discuss.elastic.co/t/difficulty-creating-a-time-series-line-chart/40402/4 "2016-02-02T14:48:22Z")
I just realized I may still be wrong. Because today my numbers look inflated. So, to answer you question, yes I have a Count field I would like to visualize myself. ---
### Author: ![anhlqn](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/anhlqn/32/5454_2.png) [@anhlqn](https://discuss.elastic.co/u/anhlqn) #### Post date: [February 5, 2016, 8:28am UTC](https://discuss.elastic.co/t/difficulty-creating-a-time-series-line-chart/40402/5 "2016-02-05T08:28:52Z")
Under Bucket, can you try Date Histogram first and add a Split with Terms Aggregation and then chose Field as Member Type? Something like this: ![](https://us1.discourse-cdn.com/elastic/original/2X/7/7e37f67a35376a9b35d3acf72c503f583bcb3c66.png) ---
### Author: ![mc1392](https://avatars.discourse-cdn.com/v4/letter/m/57b2e6/32.png) [@mc1392](https://discuss.elastic.co/u/mc1392) #### Post date: [February 5, 2016, 3:03pm UTC](https://discuss.elastic.co/t/difficulty-creating-a-time-series-line-chart/40402/6 "2016-02-05T15:03:26Z")
I tried moving away from using the count field and just loaded all of the records. see attached. I still get inflated numbers. In fact, I can run successfully the 1st time. If I run the 2nd time, that is when my numbers are getting inflated. ![](https://us1.discourse-cdn.com/elastic/original/2X/0/0ad3b42896d7738b9900e1ba9a4f9d8732e0de30.gif) ---
### Author: ![Croos](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/croos/32/29489_2.png) [@Croos](https://discuss.elastic.co/u/Croos) #### Post date: [February 6, 2016, 10:26am UTC](https://discuss.elastic.co/t/difficulty-creating-a-time-series-line-chart/40402/7 "2016-02-06T10:26:20Z")
I thing that, Your whole collections of timestamps are in same date.. I mean same day. So you have to set the Interval to 'auto' or some other value like 'hour'. Try this. If it is work, let me know. regds, Croos. ---
### Author: ![mc1392](https://avatars.discourse-cdn.com/v4/letter/m/57b2e6/32.png) [@mc1392](https://discuss.elastic.co/u/mc1392) #### Post date: [February 8, 2016, 5:46pm UTC](https://discuss.elastic.co/t/difficulty-creating-a-time-series-line-chart/40402/8 "2016-02-08T17:46:23Z")
That doesnt work. But the weird thing is my numbers from friday are inflated, but my numbers from this weekend, saturday and sunday, look normal. ---
### Author: ![anhlqn](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/anhlqn/32/5454_2.png) [@anhlqn](https://discuss.elastic.co/u/anhlqn) #### Post date: [February 18, 2016, 8:07am UTC](https://discuss.elastic.co/t/difficulty-creating-a-time-series-line-chart/40402/9 "2016-02-18T08:07:54Z")
Keep settings like this, but on the metrics part, change it to Aggregation: Sum Field: Count The Count you currently have on Y-Axis only counts the number of documents in ES, which is not what you are looking for. Also, please check the data type of your Count field in ES to make sure it is integer. ---
### 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, 2:01pm UTC](https://discuss.elastic.co/t/difficulty-creating-a-time-series-line-chart/40402/10 "2017-07-06T14:01:57Z")