Splunk Search

chart with where

Jasmine
Path Finder

Please help me on the below items:

#1)

| chart count(WriteType) over Collection by WriteType  | sort Collection

for above query  can we add conditon as below:  (i am facing issue here)

| chart count(WriteType) over Collection by WriteType |where c in("test","qa")  | sort Collection

 #2):

can we add one more field after WriteType as below:

| chart count(WriteType) over Collection by WriteType, c |where c in("test","qa")
Labels (1)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

1) c doesn't exist unless it is a value in WriteType and even then it will contain a count not "test" or "qa"

2) No, you can only have two fields with chart.

Perhaps it would be better if you explained what you are trying to do, and share some representative anonymised sample events? (I may have said that before a few times!)

0 Karma
Get Updates on the Splunk Community!

Optimize Cloud Monitoring

  TECH TALKS Optimize Cloud Monitoring Tuesday, August 13, 2024  |  11:00AM–12:00PM PST   Register to ...

What's New in Splunk Cloud Platform 9.2.2403?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.2.2403! Analysts can ...

Stay Connected: Your Guide to July and August Tech Talks, Office Hours, and Webinars!

Dive into our sizzling summer lineup for July and August Community Office Hours and Tech Talks. Scroll down to ...