# Canvas - Any way to consolidate 2 metric elements into one markdown element?

**URL:** <https://discuss.elastic.co/t/canvas-any-way-to-consolidate-2-metric-elements-into-one-markdown-element/245670>\
**Category:** Kibana\
**Tags:** canvas\
**Created:** [August 19, 2020, 8:05pm UTC](https://discuss.elastic.co/t/canvas-any-way-to-consolidate-2-metric-elements-into-one-markdown-element/245670 "2020-08-19T20:05:09Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![devbot](https://avatars.discourse-cdn.com/v4/letter/d/9de0a6/32.png) [@devbot](https://discuss.elastic.co/u/devbot)\
**Post date:** [August 19, 2020, 8:05pm UTC](https://discuss.elastic.co/t/canvas-any-way-to-consolidate-2-metric-elements-into-one-markdown-element/245670/1 "2020-08-19T20:05:10Z")

</div>

I have an elastic sql query that returns 2 calculated ("last") columns. I have use 2 ["metric"](https://www.elastic.co/blog/kibana-canvas-metric-and-markdown-elements) elements on a canvas dashboard to display the sum of each column, respectively (selecting "sum" of the column name in both elements under "Display -\> Measure -\> Number").

What I would really like to do is somehow incorporate both of these values in a "markdown" element that would contain both values, plus some text. After a lot of time spent playing in the expression editor and trying to understand the capability of this notation/syntax, I still can't figure out if this is possible.

All I have figured out so far is that with a markdown element, I can put the same query in under "Data" and put this under Display -\> Markdown -\> Markdown content

```auto
    {{#each rows}}
     **{{column1}}** and **{{column2}}** 
    {{/each}}

```

But in that scenario, only one row from the query result is used in reflecting the values of column1 and column2.

EDIT: I've also asked a much more specific question about this here: [Can a Kibana Canvas Markdown Element Display a Total of a Column?](https://discuss.elastic.co/t/can-a-kibana-canvas-markdown-element-display-a-total-of-a-column/245797)

---

<div class="post-metadata">

**Author:** ![corey.robertson](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/corey.robertson/32/54611_2.png) [@corey.robertson](https://discuss.elastic.co/u/corey.robertson)\
**Post date:** [August 20, 2020, 7:16pm UTC](https://discuss.elastic.co/t/canvas-any-way-to-consolidate-2-metric-elements-into-one-markdown-element/245670/2 "2020-08-20T19:16:43Z")

</div>

Hi @devbot

Can you share the expression as you've got it now and I would be glad to help you try to debug where the problem might be.

---

<div class="post-metadata">

**Author:** ![devbot](https://avatars.discourse-cdn.com/v4/letter/d/9de0a6/32.png) [@devbot](https://discuss.elastic.co/u/devbot)\
**Post date:** [August 20, 2020, 7:18pm UTC](https://discuss.elastic.co/t/canvas-any-way-to-consolidate-2-metric-elements-into-one-markdown-element/245670/3 "2020-08-20T19:18:17Z")

</div>

Yes. I put the entire expression syntax for the markdown element in this question, where I've basically asked the same thing but in a different way: [Can a Kibana Canvas Markdown Element Display a Total of a Column?](https://discuss.elastic.co/t/can-a-kibana-canvas-markdown-element-display-a-total-of-a-column/245797)

---

<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:** [September 17, 2020, 7:18pm UTC](https://discuss.elastic.co/t/canvas-any-way-to-consolidate-2-metric-elements-into-one-markdown-element/245670/4 "2020-09-17T19:18:31Z")

</div>

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