Dashboards & Visualizations

how to make a chart of one field according to another one sort by a third one ?

arbelron3
New Member

I know I can do |chart list(field1) by field2,field 3
but than I dont get what I want because some of the values are getting erased.... I want to get a graph for field 1 by field 2 for every index of field 3.. so if for example I have 8 things in field 3 I want to get 8 graphs of field 1 by field 2... I know it is possible but I dont manage to make it... does anyone know how can I do it ?
thank you all very much !

Tags (1)
0 Karma

arbelron3
New Member

it worked ! thank you very much

0 Karma

ppablo
Retired

Hi @arbelron3

Which answer worked? Click Accept below the answer that solved your question please so we know and to resolve the post!

0 Karma

woodcock
Esteemed Legend

The problem is that your Y-Axis value must be a single-valued number or it cannot be charted. This means that you should not be using list, which creates multi-valued fields. Try using avg, sum, count, or one of the other number-based functions instead, like this:

... | chart avg(field1) BY field2 field3

Obviously, if field1 is not a single-valued number, you must convert it to be one first.

0 Karma

diogofgm
SplunkTrust
SplunkTrust

Have you tried to use something like

| chart field1 over field2 by field3
------------
Hope I was able to help you. If so, some karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

Discover Powerful New Features in Splunk Cloud Platform: Enhanced Analytics, ...

Hey Splunky people! We are excited to share the latest updates in Splunk Cloud Platform 9.3.2408. In this ...

Splunk Classroom Chronicles: Training Tales and Testimonials

Welcome to the "Splunk Classroom Chronicles" series, created to help curious, career-minded learners get ...

Access Tokens Page - New & Improved

Splunk Observability Cloud recently launched an improved design for the access tokens page for better ...