Getting Data In

OR in Pivot command

Communicator

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 CiscoIOSEvent CiscoIOSEvent count(CiscoIOSEvent) 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.

0 Karma

Ultra Champion

Have you tried FILTER product in ("IOS","WLC")?

0 Karma