Splunk Search

timechart OTHER column

abhayneilam
Contributor

Hi,

When I am running my query with timechart command , OTHER column is being made, I want to expand this column as it contains the information of some useful column.

Please help me to get rid of OTHER column and also help me to expand OTHER column so that I can see all the columns.

Many thanks 🙂

Cheers

Tags (2)
0 Karma

ryhluc01
Communicator

Hi, Please select @linu1988 answer. It was the correct fix to the TC other problem.

0 Karma

DavidHourani
Super Champion

Hello,

Its quite simple, you only have to add the userother=0 to get rid of that column completely and then you can either set a limit for your timechart display (limit=5 for a limit of 5 values) or display everything (limit=0):

..|timechart count by X limit=5 useother=0

Let me know if it works out for u 🙂

Regards,
David

linu1988
Champion
...|timechart avg(Value) by column limit=0
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!

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...

Splunk Community Badges!

  Hey everyone! Ready to earn some serious bragging rights in the community? Along with our existing badges ...

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

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