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
Get Updates on the Splunk Community!

Routing logs with Splunk OTel Collector for Kubernetes

The Splunk Distribution of the OpenTelemetry (OTel) Collector is a product that provides a way to ingest ...

New This Month - Observability Updates Give Extended Visibility and Improve User ...

This month is a collection of special news! From Magic Quadrant updates to AppDynamics integrations to ...

Intro to Splunk Synthetic Monitoring

In our last post, we mentioned that the 3 key pieces of observability – metrics, logs, and traces – provide ...