# Canvas count the numbers from a table

**URL:** <https://discuss.elastic.co/t/canvas-count-the-numbers-from-a-table/199815>\
**Category:** Kibana\
**Tags:** canvas\
**Created:** [September 17, 2019, 11:50am UTC](https://discuss.elastic.co/t/canvas-count-the-numbers-from-a-table/199815 "2019-09-17T11:50:04Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vladpov](https://avatars.discourse-cdn.com/v4/letter/v/8c91f0/32.png) [@Vladpov](https://discuss.elastic.co/u/Vladpov)\
**Post date:** [September 17, 2019, 11:50am UTC](https://discuss.elastic.co/t/canvas-count-the-numbers-from-a-table/199815/1 "2019-09-17T11:50:04Z")

</div>

Hi I'm new with canvas and so far I created two tables where I have id numbers in separate rows.

 ![Sn%C3%ADmek%20obrazovky%20(73)](https://us1.discourse-cdn.com/elastic/original/3X/9/e/9e40962bd6dc36caf58e99563199093af8f8a647.png)

I try to make a count of num1 occurrence so instead of 7 ones there would be one row with number 7 or number 4 if we'd speak about another table.

Any help is appreciated!!

---

<div class="post-metadata">

**Author:** ![tims](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tims/32/46750_2.png) [@tims](https://discuss.elastic.co/u/tims)\
**Post date:** [September 17, 2019, 7:01pm UTC](https://discuss.elastic.co/t/canvas-count-the-numbers-from-a-table/199815/2 "2019-09-17T19:01:45Z")

</div>

Hey @Vladpov, normally you could accomplish something like this with a subquery in regular SQL, unfortunately subquery support in essql is limited. Is this perhaps a value that you could calculate and store during ingest or using a scripted field?

---

<div class="post-metadata">

**Author:** ![Vladpov](https://avatars.discourse-cdn.com/v4/letter/v/8c91f0/32.png) [@Vladpov](https://discuss.elastic.co/u/Vladpov)\
**Post date:** [September 18, 2019, 8:04am UTC](https://discuss.elastic.co/t/canvas-count-the-numbers-from-a-table/199815/3 "2019-09-18T08:04:35Z")

</div>

Hey @tims, thank you for you reply! After a few attempts to achieve it we decided to try manage it as you say.

Can you please give me any hints about options that exist and are able to filter the messages during ingest?

The thing is that we have logs coming constantly with id number and suffix (dn and mt) and we need to get somewhere either during ingest or after some script that could calculate number of successfully delivered messages.

If message was delivered successfully depends on the time id number recieved second suffix 'dn' so message has both suffixes 'mt' and 'dn' that should be within one hour.

Thank you very much for any help!

---

<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:** [October 16, 2019, 8:04am UTC](https://discuss.elastic.co/t/canvas-count-the-numbers-from-a-table/199815/4 "2019-10-16T08:04:38Z")

</div>

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