Display values of all fields in a row if one field value is greater than 100

[karthikganduri]

Hi All,

I am displaying the names based on dates and used where condition to display only values that are greater than 100 (where runs  > 100 ).  Below is how the table shows , but I want to display the other values in the row with actual value instead of showing it as empty. 

| where runs > 100 | xyseries Name dayOfDate runs

Name	Date1	Date2	Date3	Date4	Date5
Sachi	101
Kohli			108
ABD		104		105

[richgalloway]

Once the where command discards results, there's no getting them back.  The query has to be written to exclude results where all runs values are <=100.  Please share the full query and we can help you do that.

[johnhuang · Accepted solution]

I think this is what you're asking for:

| eventstats MAX(runs) AS max_run BY Name
| where max_run > 100
| chart limit=20 MAX(runs) AS runs BY Name dayOfDate

[karthikganduri]

Thanks ..It worked 🙂