# Canvas: Extending Element to continue on Next Page

**URL:** https://discuss.elastic.co/t/canvas-extending-element-to-continue-on-next-page/351584
**Category:** Kibana
**Tags:** canvas
**Created:** [January 22, 2024, 11:13pm UTC](https://discuss.elastic.co/t/canvas-extending-element-to-continue-on-next-page/351584 "2024-01-22T23:13:42Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![erikg](https://avatars.discourse-cdn.com/v4/letter/e/91b2a8/32.png) [@erikg](https://discuss.elastic.co/u/erikg)
#### Post date: [January 22, 2024, 11:13pm UTC](https://discuss.elastic.co/t/canvas-extending-element-to-continue-on-next-page/351584/1 "2024-01-22T23:13:42Z")

</div>

Hello,

I am pretty new to Canvas,  
I am able to create a markdown table using Elastic SQL.  
The query retrieves a limit of 50 results. The report looks great as expected but It can only fit 17 on one page. I was wondering if there's a way to display the remainder of the table result on the next page. How would I go about doing that?  
This is my table for reference:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/3/a/3a59f6f66a673fdbbbca9082f10e6ad51d37a5bb.png)

---

<div class="post-metadata">

### Author: ![erikg](https://avatars.discourse-cdn.com/v4/letter/e/91b2a8/32.png) [@erikg](https://discuss.elastic.co/u/erikg)
#### Post date: [January 29, 2024, 9:46pm UTC](https://discuss.elastic.co/t/canvas-extending-element-to-continue-on-next-page/351584/2 "2024-01-29T21:46:42Z")

</div>

Hello,  
Any suggestions? I tried to do a data table with pagination but the pdf doesn't allow to view through the pagination. I feel like the markdown table should extend/continue the results onto the next page?

---

<div class="post-metadata">

### Author: ![yago82](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yago82/32/97755_2.png) [@yago82](https://discuss.elastic.co/u/yago82)
#### Post date: [January 30, 2024, 9:56am UTC](https://discuss.elastic.co/t/canvas-extending-element-to-continue-on-next-page/351584/3 "2024-01-30T09:56:11Z")

</div>

Hi,

As a workaround, you could consider creating multiple tables, each displaying a subset of the data. For example, the first table could display the first 17 results, the second table could display the next 17 results, and so on.

Regards

---

<div class="post-metadata">

### Author: ![erikg](https://avatars.discourse-cdn.com/v4/letter/e/91b2a8/32.png) [@erikg](https://discuss.elastic.co/u/erikg)
#### Post date: [January 30, 2024, 2:47pm UTC](https://discuss.elastic.co/t/canvas-extending-element-to-continue-on-next-page/351584/4 "2024-01-30T14:47:35Z")

</div>

Hey @yago82 ,

Thanks for confirming this is still possible, how would be able to do this? I am not too familiar with canvas and markdown.

Here's my current set up:

```auto
filters
| essql
query="SELECT \"winlog.event_data.TargetUserName\", COUNT(*) AS \"count\" FROM \"winlogbeat-*, logs-*\" WHERE \"winlog.event_data.TargetUserName\" IS NOT NULL and \"event.code\" = '4740' and \"@timestamp\" >= NOW() - INTERVAL 1 DAY GROUP BY \"winlog.event_data.TargetUserName\" ORDER BY COUNT(*) DESC"
| markdown
"| User | Count |
| - | - |
{{#each rows}}
| {{\"winlog.event_data.TargetUserName\"}} | {{count}} |
{{/each}}
"
| render css=".canvasMarkdown table {
display: table;
width: 100%;
}"

```

---

<div class="post-metadata">

### Author: ![erikg](https://avatars.discourse-cdn.com/v4/letter/e/91b2a8/32.png) [@erikg](https://discuss.elastic.co/u/erikg)
#### Post date: [February 5, 2024, 7:37pm UTC](https://discuss.elastic.co/t/canvas-extending-element-to-continue-on-next-page/351584/5 "2024-02-05T19:37:58Z")

</div>

Hey @yago82 , do you have an idea how I can go about this?

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [March 4, 2024, 7:38pm UTC](https://discuss.elastic.co/t/canvas-extending-element-to-continue-on-next-page/351584/6 "2024-03-04T19:38:01Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
