Hi,
You can include you input query in the chart search:
<query> index="effort_tracker"
( ( [| inputlookup hierarchy_lookup.csv | where Level > [| inputlookup hierarchy_lookup.csv
| where [| rest /services/authentication/current-context | eval accountname=mvindex(split(username,"@"),0)
| table accountname | rename accountname as Name] | table Level | rename Level as search]
| fields Name | rename Name as Username]) AND Username=$NAME_ID$) $MODULE_ID$
| stats count by Username </query>
... View more