topic Get multiple Fields in chart function in Splunk Search

Get multiple Fields in chart function

sumarri — Wed, 06 Mar 2024 12:54:38 GMT

So, I have a chart function that works perfectly!

| chart sum(transactionMade) over USERNUMBER by POSTDATE

But, I want my chart to have USERNUMBER and USERNAME. They are both correlated, so it should not be an issue. I also want to add Team Number, which there is no correlation to USERNUMBER and USERNAME.

Is it possible to have multiple fields after over?

I can concatenate all the fields into one string, but it would be easier if they were separate columns.

Thank you!

Re: Get multiple Fields in chart function

gcusello — Wed, 06 Mar 2024 13:00:40 GMT

Hi @sumarri,

for my knowledge, the only way is concatenating the fields in one field and use it for the chart command.

Ciao.

Giuseppe

Re: Get multiple Fields in chart function

sumarri — Wed, 06 Mar 2024 13:10:58 GMT

Okay, that is what I thought.

Thank you so much for conforming! 😊

Re: Get multiple Fields in chart function

ITWhisperer — Wed, 06 Mar 2024 13:22:25 GMT

Further to @gcusello 's response, the chart command has only three dimensions, the over field, the by field and the aggregation function. Although, strictly speaking, this can be extended by multiple aggregation functions, but you end up with composite column names.

As already suggested, concatenating fields is one way to get around this. Another way is perhaps more tricky and involves using the stats command instead and then messing around with the fields to get the by field values represented as field/column names.