Getting Data In

OR in Pivot command

jaracan
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 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.

0 Karma

FrankVl
Ultra Champion

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

0 Karma
Take the 2021 Splunk Career Survey

Help us learn about how Splunk has
impacted your career by taking the 2021 Splunk Career Survey.

Earn $50 in Amazon cash!