Splunk Search

Can you have 3 fields within a chart

zoebanning
Path Finder

Hi Splunk Community,

I was wondering if it was possible to have a chart that was made up from 3 fields.... 

I have already built a chart that has columns for each Account where each column is stacked with the Action -->  | chart count by Account, Action 


Can i break down into days using the _time field, so it counts by days?

 

Example of data:

_timeAccountAction
2021-10-20 10:04:03.778account1Delete
2021-10-21 11:04:03.778account2Write
2021-10-21 11:05:03.778account1Write

 

Thanks You,

Zoe 

Labels (2)
0 Karma
1 Solution

bhargavi
Path Finder

Hi @zoebanning ,

 

  • Chart command does not allow more than 2 fields  in by clause
  • Timechart command does not allow more than 1 field  in by clause

    So here I have tried to display the possible values of account and action and merged them into 1 column, then used timechart command . 

    bhargavi_0-1636983082422.png



    bhargavi_1-1636983101981.png



    If this helps, give a thumbs-up 🙂

    Happy Splunking!!

View solution in original post

bhargavi
Path Finder

Hi @zoebanning ,

 

  • Chart command does not allow more than 2 fields  in by clause
  • Timechart command does not allow more than 1 field  in by clause

    So here I have tried to display the possible values of account and action and merged them into 1 column, then used timechart command . 

    bhargavi_0-1636983082422.png



    bhargavi_1-1636983101981.png



    If this helps, give a thumbs-up 🙂

    Happy Splunking!!

NobliX
Loves-to-Learn Everything

Regarding the chart. Is there a possibility to hide or remove a column in the column chart based on nullvalue. (The space created visually) ? As of now it is created spaces to 3 bars, thus its only displaying the value of given instance. 

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Network to App: Observability Unlocked [May & June Series]

In today’s digital landscape, your environment is no longer confined to the data center. It spans complex ...

SPL2 Deep Dives, AppDynamics Integrations, SAML Made Simple and Much More on Splunk ...

Splunk Lantern is Splunk’s customer success center that provides practical guidance from Splunk experts on key ...

[Puzzles] Solve, Learn, Repeat: Matching cron expressions

This puzzle (first published here) is based on matching timestamps to cron expressions.All the timestamps ...