# Canvas: Cumulative sum of counts
**URL:** https://discuss.elastic.co/t/canvas-cumulative-sum-of-counts/175380
**Category:** Kibana
**Tags:** canvas
**Created:** [April 4, 2019, 10:14am UTC](https://discuss.elastic.co/t/canvas-cumulative-sum-of-counts/175380 "2019-04-04T10:14:25Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@superfly86](https://discuss.elastic.co/u/superfly86)
#### Post date: [April 4, 2019, 10:14am UTC](https://discuss.elastic.co/t/canvas-cumulative-sum-of-counts/175380/1 "2019-04-04T10:14:25Z")
Kibana novice here...
I'm using ElasticseachSQL queries to populate elements in Canvas.
I'd like to find a way of creating a Line chart to display a DAILY cumulative count of row entries for a given month.
To get the entries i do the following:
SELECT COUNT(\*) AS entries, DAY\_OF\_MONTH(entry\_date) AS day FROM data\_table WHERE MONTH\_OF\_YEAR(entry\_date) = MONTH\_OF\_YEAR(NOW()) AND YEAR(entry\_date) = YEAR(NOW()) GROUP BY day ORDER BY day
This gives me this lovely table:
day | entries
------+------------
1 |464
2 |180
3 |179
4 |378
Now i want another column where it keeps track of the cumulative count:
day | entries | **cumulative count**
------+-------------+--------------------------
1 |464 | **464**
2 |180 | **644**
3 |179 | **823**
4 |378 | **1,201**
how do i do this?
Most answers elsewhere mention windowing, but this doesn't seem supported in ESSQL.
Here's hoping...
---
### Author:  [@thomasneirynck](https://discuss.elastic.co/u/thomasneirynck)
#### Post date: [April 4, 2019, 5:54pm UTC](https://discuss.elastic.co/t/canvas-cumulative-sum-of-counts/175380/2 "2019-04-04T17:54:24Z")
@superfly86
not in Canvas, but in the regular Visualizations of Kibana you can do this with the cumulative sum pipeline aggregation
you could create a regular Dashboard iso a Canvas workpad with this table.
---
### Author:  [@superfly86](https://discuss.elastic.co/u/superfly86)
#### Post date: [April 4, 2019, 6:30pm UTC](https://discuss.elastic.co/t/canvas-cumulative-sum-of-counts/175380/3 "2019-04-04T18:30:02Z")
@thomasneirynck
> not in Canvas, but in the regular Visualizations of Kibana you can do this with the cumulative sum pipeline aggregation
Yes, exactly, i have been able to produce the exact chart i need in Visualisations, however i'd like it part of a Canvas alongside other metrics (for display purposes)
> you could create a regular Dashboard iso a Canvas workpad with this table.
Could you clarify - can i create a visualisation and copy it across to Canvas?
---
### Author:  [@thomasneirynck](https://discuss.elastic.co/u/thomasneirynck)
#### Post date: [April 4, 2019, 6:59pm UTC](https://discuss.elastic.co/t/canvas-cumulative-sum-of-counts/175380/4 "2019-04-04T18:59:48Z")
no, you cannot add visualizations from the Kibana Visualize app to a Canvas workpad now.
I meant that perhaps a dashboard with that visualization would work for your purposes as well. Although I do understand that Canvas has more styling options for look&feel.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [May 2, 2019, 6:59pm UTC](https://discuss.elastic.co/t/canvas-cumulative-sum-of-counts/175380/5 "2019-05-02T18:59:53Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.