Forum Discussion

Sridhar Manickavel's avatar
Sridhar Manickavel
Copper Contributor
Oct 06, 2017

How to apply Filter on Filter in the dashboard.

I have created two filters like below.  Second filter is dependent on first Filter1.  

Filter1 : search * | distinct  Computer

Filter2: search * | where ${Filter1}| distinct UserName_s

 

I am not getting any error or there is no result.

 

If i change the Filter2 like below then I can see the the values.

search * | distinct UserName_s

 

Please any suggession.  

azure monitor
Query Language

6 Replies

  • Evan Hissey's avatar
    Evan Hissey
    Icon for Microsoft rankMicrosoft
    Jun 19, 2018

    View Filters do not support nested filters like in your example today. I'll note to update documentation to reflect this.

  • Prashant Sharma's avatar
    Prashant Sharma
    Brass Contributor
    Jun 03, 2018
    I think the second value move the first variable into the null position on runtime.
    Give me some time..
    • LarsVillaume_twoday's avatar
      LarsVillaume_twoday
      Copper Contributor
      Jun 01, 2018

      Hi,

      Did you get an answer for this?

      I have configured a filter in view designer and updated the query's to support the filter but it doesn't work. No errors, no changes in the data I see when i pick a value in the filter drop down list.

Resources