Canvas when filter added the value turns to zero [6.8]

Hi I have tried to add a filter to one of my Canvas slides for the total dashboard but every value turns to zero as I select any of the values please provide me with a solution.
On of the queries is :
SELECT err from(select (a100/b) as err from(select count(app) as b, count(err) as a from "dum" where app is not null group by app)) where err > 60
The query for the filter was:
SELECT app from "dum*"
But as soon as filter applied the values turn to zero

@SheetalRIL sometimes this could happen if you have a mismatch in how the field is processed by Elasticsearch. Can you post the entire expression for the element that returns no results as well as the expression for the dropdown filter?

contains all the queries and json format used to create the queries in an apm

@SheetalRIL that looks like a private repo maybe, I don't have access to it. In any case, if you open the Expression editor in Canvas and just copy/paste the expression that may be enough to help.

Please try one more time I have made the repository public I have also uploaded the expression json.

@SheetalRIL the way you are doing the sub-selects in the query is not really supported. The dropdown filter needs access to the same "app" field on the index in order to filter correctly. Can you try and simplify the query to just select count(app) as b, count(err) as a from "dum" where app is not null group by app to see if the filter works?

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