I have a raw where each event looks like this (simplified for this exampel): {"time": "2022-01-20 16:40:02.325216", "name": "name1", "deployment": "found", "secret": "correct"} If "deployment": "not_found", I would like to have a table like: time name deployment 2022-01-20 16:40:02.325216 name1 not_found If "secret": "incorrect", I would like to have a table like: time name secret 2022-01-20 16:40:02.325216 name1 incorrect   Currently, my search looks like this:   index=index host=host source=source ("not_found" OR "incorrect") | table time name deployment secret   But this means that both fields (deployment and secret) will be shown no matter what their value is. @Ayn Is there a way to have a table which varies its fields depending on a certain condition? Thanks in advance!  ... View more

Hi, My search returns a pie chart that is a sum of a variable (memory_usage_GB) and ploted by another variable (user). .... | stats sum(memory_usage_GB) by user .... On the other side, I have an input in the same dashboard where you can select a specific user. The input is referenced with the token $userfilter$. I want the pie chart to color the result corresponding to the selected user in the input with one color, and all the other results with another color. So in the XML of the pie chart, I have tried the following: <option name="charting.fieldColors">{"$userfilter$": 0x39ff14,"all":0xa9a9a9}</option> It colors the desired user. However,  I don't know how can I refer to the rest of the results. Maybe there is another way to do the coloring in the search string? Thank you! ... View more