# Can Kibana create a pie chart and table where one of the variables is from the past
**URL:** https://discuss.elastic.co/t/can-kibana-create-a-pie-chart-and-table-where-one-of-the-variables-is-from-the-past/275209
**Category:** Kibana
**Created:** [June 7, 2021, 9:30pm UTC](https://discuss.elastic.co/t/can-kibana-create-a-pie-chart-and-table-where-one-of-the-variables-is-from-the-past/275209 "2021-06-07T21:30:38Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@kelvins](https://discuss.elastic.co/u/kelvins)
#### Post date: [June 7, 2021, 9:30pm UTC](https://discuss.elastic.co/t/can-kibana-create-a-pie-chart-and-table-where-one-of-the-variables-is-from-the-past/275209/1 "2021-06-07T21:30:38Z")
Hello.
Not sure how to best describe it in the title. Basically, I will be reading a log file. That log file contains log entries when people uplift a file from the server. I am needing to produce both a gauge, and a table show those that have not received the file for that day.
To try and explain, here is some API calls to show a mock up
Create an index
```auto
PUT test
{
"settings" : {
"number_of_shards" : 1
},
"mappings" : {
"properties" : {
"name": { "type": "keyword"},
"status": { "type": "keyword"}
}
}
}
```
And some data
```auto
POST test/_bulk
{ "create": {} }
{"@timestamp": "2021-06-05T16:21:15.000Z","name" : "harold","status" : "RECEIVED"}
{ "create": {} }
{"@timestamp": "2021-06-05T16:21:15.000Z","name" : "patty","status" : "RECEIVED"}
{ "create": { } }
{ "@timestamp": "2021-06-03T16:21:15.000Z","name" : "harold","status" : "RECEIVED"}
{ "create": { } }
{"@timestamp": "2021-06-03T16:21:15.000Z","name" : "patty","status" : "RECEIVED"}
{ "create": { } }
{"@timestamp": "2021-06-03T16:21:15.000Z","name" : "bob","status" : "RECEIVED"}
```
Now, what I am wanting is a chart to show, that on the 5/6, we received two out of three documents (assume total quantity is count of unique people over the last 7 days), and the missing person is bob (so teams can understand why bob did not receive the file)
Also, after a table that shows the same information in tabular form. Days as the columns, people as the rows.
I did see this post from 2017: [I want to create a gauge that displays number of documents in a certain timeslice vs total documents - Elastic Stack / Kibana - Discuss the Elastic Stack](https://discuss.elastic.co/t/i-want-to-create-a-gauge-that-displays-number-of-documents-in-a-certain-timeslice-vs-total-documents/113601), but wondering if anything has changed since then or not?
Is this even possible?
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [June 8, 2021, 6:03am UTC](https://discuss.elastic.co/t/can-kibana-create-a-pie-chart-and-table-where-one-of-the-variables-is-from-the-past/275209/2 "2021-06-08T06:03:02Z")
Welcome to our community! 😃
And thanks heaps for making the effort to explain what you want, AND provide a replication of it!
What about a heatmap, like;
---
### Author:  [@kelvins](https://discuss.elastic.co/u/kelvins)
#### Post date: [June 8, 2021, 7:26pm UTC](https://discuss.elastic.co/t/can-kibana-create-a-pie-chart-and-table-where-one-of-the-variables-is-from-the-past/275209/3 "2021-06-08T19:26:04Z")
Thanks Mark.
I have played around with this, and it might just work. Next question around the heat map. However, I now want/need to expand this. Looking at the log lines in more detail, the Status field has other values, or COMPLETE, ERROR, RECEIVED and PROCESSED. Can I make the heat map reflect these values. I can see the colour is based on the count of entries, but is it possible to use another field?
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2021, 7:26pm UTC](https://discuss.elastic.co/t/can-kibana-create-a-pie-chart-and-table-where-one-of-the-variables-is-from-the-past/275209/4 "2021-07-06T19:26:18Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.