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!

Splunk Security Content for Threat Detection & Response, Q1 Roundup

Join Principal Threat Researcher, Michael Haag, as he walks through:An introduction to the Splunk Threat ...

Splunk Life | Happy Pride Month!

Happy Pride Month, Splunk Community! 🌈 In the United States, as well as many countries around the ...

SplunkTrust | Where Are They Now - Michael Uschmann

The Background Five years ago, Splunk published several videos showcasing members of the SplunkTrust to share ...