# Array : sum of to request in one line

**URL:** <https://discuss.elastic.co/t/array-sum-of-to-request-in-one-line/219809>\
**Category:** Kibana\
**Created:** [February 18, 2020, 2:48pm UTC](https://discuss.elastic.co/t/array-sum-of-to-request-in-one-line/219809 "2020-02-18T14:48:44Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bruno1](https://avatars.discourse-cdn.com/v4/letter/b/b2d939/32.png) [@Bruno1](https://discuss.elastic.co/u/Bruno1)\
**Post date:** [February 18, 2020, 2:48pm UTC](https://discuss.elastic.co/t/array-sum-of-to-request-in-one-line/219809/1 "2020-02-18T14:48:44Z")

</div>

Hello,

I want add a variable on timelion request like

$myvar=1,.es(index="filebeat-\*",q='netflow.egress\_interface:'+$myvar ,metric="[...]

What is the correct syntax please ?

---

<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:** [February 18, 2020, 5:24pm UTC](https://discuss.elastic.co/t/array-sum-of-to-request-in-one-line/219809/2 "2020-02-18T17:24:52Z")

</div>

Hi @Bruno1,

Timelion variables are described here:

> <https://github.com/elastic/timelion/issues/87>
>
> Hi guys,
> I just started using Timelion yesterday, and I have to admit that is looks and behaves awesome.
> What I am missing...

Just to reiterate the issue, variables are not formally supported but simple, string variables should work.

---

<div class="post-metadata">

**Author:** ![Bruno1](https://avatars.discourse-cdn.com/v4/letter/b/b2d939/32.png) [@Bruno1](https://discuss.elastic.co/u/Bruno1)\
**Post date:** [February 19, 2020, 10:30am UTC](https://discuss.elastic.co/t/array-sum-of-to-request-in-one-line/219809/3 "2020-02-19T10:30:23Z")

</div>

Hello

NOK

> $interface=1,.es(index="filebeat-\*",q=netflow.egress\_interface:$interface,metric="sum:network.bytes",

OK

> .es(index="filebeat-\*",q=netflow.egress\_interface:1,metric="sum:network.bytes",

Why this don't works ?

Edit :

> I want to stress that variables are not formally implemented.
> 
> They're in the grammar and the runner, but they're intentionally omitted from the tutorial as the implementation is minimal and incomplete. There's no string concatenation, no arrays, they can't be used across charts, and lots of other lacking functionality. I don't recommend using them as I may decide to drop them.

---

<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:** [February 19, 2020, 1:46pm UTC](https://discuss.elastic.co/t/array-sum-of-to-request-in-one-line/219809/4 "2020-02-19T13:46:04Z")

</div>

Timelion variables have to be strings, if the value for egress\_interface has to be numeric that could be why it isn't working.

---

<div class="post-metadata">

**Author:** ![Bruno1](https://avatars.discourse-cdn.com/v4/letter/b/b2d939/32.png) [@Bruno1](https://discuss.elastic.co/u/Bruno1)\
**Post date:** [February 19, 2020, 3:37pm UTC](https://discuss.elastic.co/t/array-sum-of-to-request-in-one-line/219809/5 "2020-02-19T15:37:18Z")

</div>

Thanks for your reply 🙂

---

<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 18, 2020, 3:37pm UTC](https://discuss.elastic.co/t/array-sum-of-to-request-in-one-line/219809/6 "2020-03-18T15:37:22Z")

</div>

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