# Lens - Pie Chart Summary
**URL:** https://discuss.elastic.co/t/lens-pie-chart-summary/353493
**Category:** Kibana
**Tags:** visualisation
**Created:** [February 16, 2024, 9:56pm UTC](https://discuss.elastic.co/t/lens-pie-chart-summary/353493 "2024-02-16T21:56:35Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@erikg](https://discuss.elastic.co/u/erikg)
#### Post date: [February 16, 2024, 9:56pm UTC](https://discuss.elastic.co/t/lens-pie-chart-summary/353493/1 "2024-02-16T21:56:35Z")
Hello,
I was wondering if there's a way to make a summary pie chart.
The problem is with pie charts, I can't seem to be able to "Last Value" of a keyword.
But in a data table, I can.
This is an example of the data table with a summary of health status but in the pie chart, I can't seem to do the same:
I basically want the pie chart to show 2 for up only since its considered the last value for the servers. The keyword doesn't seem to work with Last Value in pie chart but it does for data table.
Any help is appreciated!
---
### Author:  [@stephenb](https://discuss.elastic.co/u/stephenb)
#### Post date: [February 16, 2024, 10:09pm UTC](https://discuss.elastic.co/t/lens-pie-chart-summary/353493/2 "2024-02-16T22:09:37Z")
So you want a pie chart based on the latest value?
So if you have 10 devices that are measured every 10 secs but the time picker I is 2 hours ... You just want the pie chart to show that counts up / down the last reported value?
---
### Author:  [@erikg](https://discuss.elastic.co/u/erikg)
#### Post date: [February 16, 2024, 10:24pm UTC](https://discuss.elastic.co/t/lens-pie-chart-summary/353493/3 "2024-02-16T22:24:41Z")
@stephenb yes exactly!
---
### Author:  [@stephenb](https://discuss.elastic.co/u/stephenb)
#### Post date: [February 17, 2024, 1:57am UTC](https://discuss.elastic.co/t/lens-pie-chart-summary/353493/4 "2024-02-17T01:57:12Z")
Unfortunately, the Pie chart, as well as most other viz do not support the "Last Value" at this time (I think this has been asked before I dug around)
(Believe me, like you did, I tried, I even tried the new ESQL It is not there yet or I could not figure it out)
However, the [Latest Transform](https://www.elastic.co/guide/en/elasticsearch/reference/current/transforms.html) is super handy for these use cases...
Kibana - Stack Management - Transform -\> Data view -\> Latest Transform
Just name it
`lastest-heartbeat` and it should all work pretty good .. then it will just be a normal PIE chart
Take a look...
I have used Latest transform to get the latest state on 100K servers... super handy!
---
### Author:  [@erikg](https://discuss.elastic.co/u/erikg)
#### Post date: [February 17, 2024, 2:18am UTC](https://discuss.elastic.co/t/lens-pie-chart-summary/353493/5 "2024-02-17T02:18:39Z")
@stephenb
The Latest Transform might be exactly what I need!
Thanks for the help and information!!
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [March 16, 2024, 2:18am UTC](https://discuss.elastic.co/t/lens-pie-chart-summary/353493/6 "2024-03-16T02:18:42Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.