Hi Team,
How do we do "OR" in pivot command?
I wanted to have a result with either product ="IOS" OR product ="WLC"
Current search: Take note of FILTER product is "IOS"
| pivot Cisco_IOS_Event Cisco_IOS_Event count(Cisco_IOS_Event) AS "Count of Event" SPLITROW _time AS "_time" PERIOD auto SPLITCOL mnemonic FILTER product is "IOS" SORT 0 _time NUMCOLS 10
I tried FILTER product is "IOS" OR product is "WLC" but did not work.
What should I done differently? Thanks in advance.
