# Visualization on the basis of months

**URL:** <https://discuss.elastic.co/t/visualization-on-the-basis-of-months/204997>\
**Category:** Kibana\
**Created:** [October 24, 2019, 4:43am UTC](https://discuss.elastic.co/t/visualization-on-the-basis-of-months/204997 "2019-10-24T04:43:45Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![suraj\_kumar3](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/suraj_kumar3/32/51976_2.png) [@suraj\_kumar3](https://discuss.elastic.co/u/suraj_kumar3)\
**Post date:** [October 24, 2019, 4:43am UTC](https://discuss.elastic.co/t/visualization-on-the-basis-of-months/204997/1 "2019-10-24T04:43:46Z")

</div>

I want to have a visualization where x axis will represent months and y axis represents cost in that month. but, the file having the data is having separate columns for every months.  
how to achieve this requirement of displaying more than one column along x-axis in vertical bar graph.

---

<div class="post-metadata">

**Author:** ![Brandon\_Kobel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_kobel/32/14829_2.png) [@Brandon\_Kobel](https://discuss.elastic.co/u/Brandon_Kobel)\
**Post date:** [October 24, 2019, 5:03pm UTC](https://discuss.elastic.co/t/visualization-on-the-basis-of-months/204997/2 "2019-10-24T17:03:35Z")

</div>

Hey @suraj_kumar3, have you already ingested your file into Elasticsearch? Would you mind providing a few sample documents of the current data?

Ideally, we'd be ingesting the data and have a [date](https://www.elastic.co/guide/en/elasticsearch/reference/current/date.html) field, and then we can create a Visualization with a date histogram on the x-axis, grouped by month:

 ![22%20AM](https://us1.discourse-cdn.com/elastic/original/3X/d/4/d422db9f74549d198f208743e65416af2b39632d.png)

---

<div class="post-metadata">

**Author:** ![suraj\_kumar3](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/suraj_kumar3/32/51976_2.png) [@suraj\_kumar3](https://discuss.elastic.co/u/suraj_kumar3)\
**Post date:** [October 25, 2019, 5:06am UTC](https://discuss.elastic.co/t/visualization-on-the-basis-of-months/204997/3 "2019-10-25T05:06:21Z")

</div>

![data](https://us1.discourse-cdn.com/elastic/original/3X/8/0/80084460c8a246cee624e949cafb48b9b1a198ec.jpeg)  
this kind of data i am injesting

---

<div class="post-metadata">

**Author:** ![Brandon\_Kobel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_kobel/32/14829_2.png) [@Brandon\_Kobel](https://discuss.elastic.co/u/Brandon_Kobel)\
**Post date:** [October 25, 2019, 2:39pm UTC](https://discuss.elastic.co/t/visualization-on-the-basis-of-months/204997/4 "2019-10-25T14:39:22Z")

</div>

Hey @suraj_kumar3 if you create an Elasticsearch document for each account and month of sales, it will allow you to create Visualizations in Kibana based on this information. The following is an example document:

```auto
{
  "account": 1234,
  "month": "January",
  "sales": 100
}

```

---

<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:** [November 22, 2019, 2:39pm UTC](https://discuss.elastic.co/t/visualization-on-the-basis-of-months/204997/5 "2019-11-22T14:39:24Z")

</div>

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