I have a Dashboard row as follows
where search is as follows :-
My search
|stats avg(e) as a_e avg(l) as a_l values(eval(if(days=1, e, null()))) as y_e values(eval(if(days=1, l, null()))) as y_l by user days
How can I display the dashboard in such a way that I give the input of a user and then the result dashboard should be only for that user?
Add a dropdown for user and populate with distinct user list from your data. Like this
<input type="dropdown" token="user">
<search><query>index=foo sourcetype=bar | stats count by user | fields user</query></search>
<fieldForLabel>user</fieldForLabel>
<fieldForValue>user</fieldForValue>
</input>
Then, user the user selection values, that is populated in token user in your second query as a filter criteria, like so
<table>
<search>index=foo user=$user$ | rest of your query here</query></search>
</table>
Add a dropdown for user and populate with distinct user list from your data. Like this
<input type="dropdown" token="user">
<search><query>index=foo sourcetype=bar | stats count by user | fields user</query></search>
<fieldForLabel>user</fieldForLabel>
<fieldForValue>user</fieldForValue>
</input>
Then, user the user selection values, that is populated in token user in your second query as a filter criteria, like so
<table>
<search>index=foo user=$user$ | rest of your query here</query></search>
</table>
Where exactly the following values need to be inserted in the html? @sundareshr
table
index=foo user=$user$ | rest of your query here
/table
This is the search query for showing data in your table, filtered by user value selected. So use this in your table panel.