topic Contingency table using dictated column fields in Splunk Search

Contingency table using dictated column fields

totho — Fri, 15 Nov 2019 21:52:46 GMT

I am currently looking to make a table that shows how variables from 5 fields (the first five rows that splunk says have the biggest count) end up being spread into 5 new fields. As of now, I have maxcol and maxrow set to 5. I know the 5 new fields that I want to specifically look at. Is there any way to call these fields out when I am doing the search. My current search looks like this

index=name |'data' | contingency group newgroup maxcols=5 maxrows=5 usetotal=false

I was hoping there would be some way to replace the maxcols=5 with a variable like col1=fielda col2=fieldb etc....

Re: Contingency table using dictated column fields

to4kawa — Sat, 16 Nov 2019 06:47:25 GMT

Hello
Please provide a sample of the current results and the expected results.

Maybe you can do it with untable

Re: Contingency table using dictated column fields

woodcock — Sun, 17 Nov 2019 22:40:49 GMT

Like this:

index=name AND newgroup IN("value1", "value2", "value3", "value4", "value5")
| 'data'
| contingency group newgroup maxrows=5 usetotal=false
| table group value1 value2 value3 value4 value5

Here is a run-anywhere example:

index=_* AND sourcetype IN("splunkd", "splunk_resource_usage", "audittrail", "splunkd_access", "kvstore") AND date_minute IN("10", "20", "30", "40", "50")
| contingency sourcetype date_minute