# Data View, Canvas, and ESQL
**URL:** https://discuss.elastic.co/t/data-view-canvas-and-esql/336474
**Category:** Kibana
**Created:** [June 20, 2023, 11:52am UTC](https://discuss.elastic.co/t/data-view-canvas-and-esql/336474 "2023-06-20T11:52:48Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@witwit](https://discuss.elastic.co/u/witwit)
#### Post date: [June 20, 2023, 11:52am UTC](https://discuss.elastic.co/t/data-view-canvas-and-esql/336474/1 "2023-06-20T11:52:48Z")
Hi,
So i have an index which is created from a transform with group by on a field and aggregation using terms.
This means that my resulting field is a flattened field of terms.
Through this I can create Data View terms to display on discovery and finally on canvas as a table to view this index.
However, can I do more than that?
Example
I would like to display the sum of rows that have started = 1 and finished = 0.
Currently, i'm trying to make this work using ESQL count feature but it cant see nor access the flattened term in the index or the data view fields that I've created.
A solution would be greatly appreciated because otherwise i'll be displaying kind of an inaccurate metric if I use the original index instead of the transformed index.
---
### Author:  [@lukas](https://discuss.elastic.co/u/lukas)
#### Post date: [June 20, 2023, 5:35pm UTC](https://discuss.elastic.co/t/data-view-canvas-and-esql/336474/2 "2023-06-20T17:35:48Z")
Could you provide an example of what your documents look like?
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 18, 2023, 5:35pm UTC](https://discuss.elastic.co/t/data-view-canvas-and-esql/336474/3 "2023-07-18T17:35:53Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.