# Canvas Issue - math

**URL:** <https://discuss.elastic.co/t/canvas-issue-math/261086>\
**Category:** Kibana\
**Tags:** canvas\
**Created:** [January 14, 2021, 7:14am UTC](https://discuss.elastic.co/t/canvas-issue-math/261086 "2021-01-14T07:14:30Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![florian.wallner](https://avatars.discourse-cdn.com/v4/letter/f/ce73a5/32.png) [@florian.wallner](https://discuss.elastic.co/u/florian.wallner)\
**Post date:** [January 14, 2021, 7:14am UTC](https://discuss.elastic.co/t/canvas-issue-math/261086/1 "2021-01-14T07:14:30Z")

</div>

Hey Maybe someone got that issue already -

I am doing a SQL query which is working fine - but as soon as I change the value from AVG to PERCENTILE I am getting following error message:

```
Whoops! Expression failed
Expression failed with the message:

[math] > Failed to parse expression. Expected "*", "+", "-", "/", or end of input but "t" found.

```

I checked it with the debugger and the data looks 1:1 identical:

 ![canvas issue](https://us1.discourse-cdn.com/elastic/original/3X/8/9/89f0a8ad133b9e0a2077a7bb35a9b1da33003fb8.png)

Maybe someone got a hint .. I am pretty lost right now 🙂

---

<div class="post-metadata">

**Author:** ![Marta\_Bondyra](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marta_bondyra/32/102122_2.png) [@Marta\_Bondyra](https://discuss.elastic.co/u/Marta_Bondyra)\
**Post date:** [January 14, 2021, 7:52am UTC](https://discuss.elastic.co/t/canvas-issue-math/261086/2 "2021-01-14T07:52:20Z")

</div>

Hi @florian.wallner,

do you mind sharing your expression? I tried a simple example from sample data, and it worked fine, so I wonder what could go wrong in your case.

```auto
SELECT "order_date", PERCENTILE("day_of_week_i", 95) AS "95th" FROM "kibana_sample_data_ecommerce" GROUP BY "order_date"

```

---

<div class="post-metadata">

**Author:** ![florian.wallner](https://avatars.discourse-cdn.com/v4/letter/f/ce73a5/32.png) [@florian.wallner](https://discuss.elastic.co/u/florian.wallner)\
**Post date:** [January 14, 2021, 8:03am UTC](https://discuss.elastic.co/t/canvas-issue-math/261086/3 "2021-01-14T08:03:08Z")

</div>

```auto
filters
| essql 
  query="SELECT ROUND(PERCENTILE(inPercentCanvas, 95),2) AS \"95th\" FROM \"*:mon-utilization*\" WHERE hostname LIKE 'pe-001%' AND interface = 'GigabitEthernet0/0/0' AND inPercent < 101 AND inPercent > 0"
| math "95th"
| metric "Countries" 
  metricFont={font size=48 family="'Open Sans', Helvetica, Arial, sans-serif" color="#000000" align="center" lHeight=48} 
  labelFont={font size=14 family="'Open Sans', Helvetica, Arial, sans-serif" color="#000000" align="center"}
| render

```

---

<div class="post-metadata">

**Author:** ![Marta\_Bondyra](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marta_bondyra/32/102122_2.png) [@Marta\_Bondyra](https://discuss.elastic.co/u/Marta_Bondyra)\
**Post date:** [January 14, 2021, 10:13am UTC](https://discuss.elastic.co/t/canvas-issue-math/261086/4 "2021-01-14T10:13:22Z")

</div>

I did a little investigation and it turns out you cannot start your variable if it's used for math with a number. Change the name ''95th' to something like 'percentile95th' and it should work. I'll consult with the proper team if it's a bug or a correct behavior.

---

<div class="post-metadata">

**Author:** ![florian.wallner](https://avatars.discourse-cdn.com/v4/letter/f/ce73a5/32.png) [@florian.wallner](https://discuss.elastic.co/u/florian.wallner)\
**Post date:** [January 14, 2021, 10:31am UTC](https://discuss.elastic.co/t/canvas-issue-math/261086/5 "2021-01-14T10:31:36Z")

</div>

it´s working 🙂 thank you so much for your fast help

---

<div class="post-metadata">

**Author:** ![Marta\_Bondyra](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marta_bondyra/32/102122_2.png) [@Marta\_Bondyra](https://discuss.elastic.co/u/Marta_Bondyra)\
**Post date:** [January 14, 2021, 10:34am UTC](https://discuss.elastic.co/t/canvas-issue-math/261086/6 "2021-01-14T10:34:18Z")

</div>

You're welcome! Glad to hear it worked!

---

<div class="post-metadata">

**Author:** ![matriv](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/matriv/32/43656_2.png) [@matriv](https://discuss.elastic.co/u/matriv)\
**Post date:** [January 14, 2021, 4:13pm UTC](https://discuss.elastic.co/t/canvas-issue-math/261086/7 "2021-01-14T16:13:34Z")

</div>

It's generally not allowed to have column aliases that start with digits:

```auto
postgres=# select first_name AS 56 from test_emp;
ERROR: syntax error at or near "56"
LINE 1: select first_name AS 56 from test_emp;
                             ^
postgres=# select first_name AS asdf56 from test_emp;
postgres=# select first_name AS asdf56 from test_emp limit 5;
  asdf56
-----------
 Georgi
 Bezalel
 Parto
 Chirstian
 Kyoichi
(5 rows)

```

---

<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:** [February 11, 2021, 4:13pm UTC](https://discuss.elastic.co/t/canvas-issue-math/261086/8 "2021-02-11T16:13:35Z")

</div>

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