Canvas average values getting error

[fay]

Hi , I'm using canvas and I have a field sensordata.value.numeric which is a field with many numbers I want to take the average in this field and show it as a % in Gauge visualization but I got an error while doing that cause the number is bigger than 100 , this is the error I got "invalid value '2.542.025' value must be between 0-100

any help?

[jsanz (Jorge Sanz)]

You need to convert that absolute average into a percentage. Check for the eCommerce Canvas example in the "Sample Dataset" available from the Home page to "Try sample data" and then "Other sample datasets"

Then on the eCommerce canvas check how any of the percentage examples work

[fay]

Hi jsanz
Thank you for your reply
I have another issue if you can help with it please

Can't show distinct value in canvas

Hi, I want to write a sql query to show distinct value in Markdown I got the value as a table but its duplicate so I want to show the distinct value only! I try to write SELECT DISTINCT "Field_name" from "index_name" but I got an error that elastic doesn't support SELECT DISTINCT yet! also tried SELECT last_value (DISTINCT "Field_name" ) from "index_name" I got an error ( cannot use distinct on non sql function last_value any help please ?