# Help with Table plugin

**URL:** <https://community.grafana.com/t/help-with-table-plugin/22258>\
**Category:** Elasticsearch\
**Created:** [October 25, 2019, 11:25am UTC](https://community.grafana.com/t/help-with-table-plugin/22258 "2019-10-25T11:25:12Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![ellismendez](https://avatars.discourse-cdn.com/v4/letter/e/e36b37/32.png) [@ellismendez](https://community.grafana.com/u/ellismendez)\
**Post date:** [October 25, 2019, 11:25am UTC](https://community.grafana.com/t/help-with-table-plugin/22258/1 "2019-10-25T11:25:12Z")

</div>

Hi all,  
I am (somewhat) new with Grafana. I have done simple dashboards for a while, but I am starting to build more complex things, and trying to understand better how to use it.  
FYI, my data source is elasticsearch.

I need some help with the table plugin. I am not sure if what I want to achieve is possible.

I receive a log like this every minute:  
`<date>,<device.name>,<temperature>,....`

In a table, I would like to do a monthly document aggregation as follows

`Device | Total Count of Documents | Count of Documents with Temp > 8 | Ratio (Count of Documents with Temp > 8 *100 / Total Count of Documents)`

So it would look something like this:

`device1 | 43200 | 1000 | 2.31%`

I could also use a constant instead of total count of document if there is a way to use constants (one doc per min \* 30 days = 43,200)

Is this possible to do in the Table plugin?

Thanks!
