topic How to display the rows which has one single value more than 2 in Dashboards & Visualizations

How to display the rows which has one single value more than 2

sangs8788 — Sun, 07 Jun 2020 23:54:41 GMT

Hi,

I have a query which displays the resultset as below,

I would like to get the Module which has gone more than 2s in any of the month. In the above screenshot, I need DocumentExchange to be resulted since it exceeded one of the month more than 2 s.

How do I achieve this? I tried to do | foreach *2020 [convert num(<<FIELD>>) as <<FIELD>> | search <<FIELD>>>2] But this results Module which were more than 2s in all the three months. How do i rewrite the query so that it lists Module which exceeds 2s even in any one of the month?

Please advise.
Thanks

using Max brings the max of fieldname and not the value

Re: How to display the rows which has one single value more than 2

493669 — Tue, 19 May 2020 11:54:18 GMT

@sangs8788, Try below for each command to get maximum value then compare it with 2.

...|  foreach *2020
   [ eval max = max('<<FIELD>>') ]|where max>2

Re: How to display the rows which has one single value more than 2

sangs8788 — Tue, 19 May 2020 12:06:12 GMT

That works. Thanks

Re: How to display the rows which has one single value more than 2

sangs8788 — Tue, 26 May 2020 07:02:21 GMT

@493669

It is not providing the max value instead for all the rows it takes max of fields name and not field value.

Re: How to display the rows which has one single value more than 2

493669 — Tue, 26 May 2020 07:05:17 GMT

provide your sample data ,what is expected result and what it is returning using above query.

Re: How to display the rows which has one single value more than 2

sangs8788 — Tue, 26 May 2020 07:39:38 GMT

I have updated my query with the screenshot. As you can see, Mar-2020 is taken as the max field

Re: How to display the rows which has one single value more than 2

493669 — Tue, 26 May 2020 08:26:01 GMT

Try this-

...| foreach *2020 
    [ eval Max=case(Max>='<<FIELD>>',Max,true(),'<<FIELD>>') ]

Re: How to display the rows which has one single value more than 2

sangs8788 — Tue, 26 May 2020 08:45:17 GMT

ok you are doing a compare of the max with each and every field. Got it. This should ideally work.

Re: How to display the rows which has one single value more than 2

sangs8788 — Tue, 26 May 2020 08:53:49 GMT

This Works. Thanks a lot