# How to create table by month grouped by year

**URL:** <https://discuss.elastic.co/t/how-to-create-table-by-month-grouped-by-year/316044>\
**Category:** Kibana\
**Created:** [October 7, 2022, 8:19am UTC](https://discuss.elastic.co/t/how-to-create-table-by-month-grouped-by-year/316044 "2022-10-07T08:19:32Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![LucasTavernier](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lucastavernier/32/111786_2.png) [@LucasTavernier](https://discuss.elastic.co/u/LucasTavernier)\
**Post date:** [October 7, 2022, 8:19am UTC](https://discuss.elastic.co/t/how-to-create-table-by-month-grouped-by-year/316044/1 "2022-10-07T08:19:32Z")

</div>

Hello everyone, i'm new in the ELK stack.  
I have to to make a table but it's really hard can you please help me.

To help you understand what i have to do, i will explain my datas.  
I got bugs tickets with the id/name of the bug, of his project and of his user who make a change on it.  
I filter on "time change" on tickets, people have to add the time they worked on tickets.  
I also got the timestamp of the worktime change and the delta between the old value of time and new value (example on a ticket named "Shopcart doesn't work, i worked 1d already and today i will work 1d more on it so 1 -\> 2 = delta of 1d)

What i have to do is a table, each row is a month, each column a project, and i want the sum of time worked by project and by month.  
I need also :

- A total by month (row), so the sum of all project on month.
- A total by project by year
- A total of totals

Here an image of the excel table i received.

 ![table](https://us1.discourse-cdn.com/elastic/original/3X/d/0/d00cb4b7b0b74de98eb9b1f6e2a53c885884dd94.png)

Is it possible to make tables like that ?  
Thank you in advance and sorry for my english (🇫🇷)

---

<div class="post-metadata">

**Author:** ![bhavyarm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bhavyarm/32/22392_2.png) [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)\
**Post date:** [October 7, 2022, 7:39pm UTC](https://discuss.elastic.co/t/how-to-create-table-by-month-grouped-by-year/316044/2 "2022-10-07T19:39:44Z")

</div>

Hi,

No need to be sorry about your English at all.

This is possible. Can you please look at Kibana lens table? I am assuming your data is already in elasticsearch. What do you see in discover for these values?

> **[Kibana Lens](https://www.elastic.co/kibana/kibana-lens)**
>
> Bring instant clarity to your data with the Kibana Lens UI. Drag and drop Elasticsearch field types for easy data visualization — no prior Kibana experience required.

I also suggest going to through some Kibana webinars to familiarize yourself with them.[Welcome to Elastic Docs | Elastic](https://www.elastic.co/guide/index.html)

Thanks,  
Bhavya

---

<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 4, 2022, 7:39pm UTC](https://discuss.elastic.co/t/how-to-create-table-by-month-grouped-by-year/316044/3 "2022-11-04T19:39:50Z")

</div>

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