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 at Cisco Live 2025: Learning, Innovation, and a Little Bit of Mr. Brightside

Pack your bags (and maybe your dancing shoes)—Cisco Live is heading to San Diego, June 8–12, 2025, and Splunk ...

Splunk App Dev Community Updates – What’s New and What’s Next

Welcome to your go-to roundup of everything happening in the Splunk App Dev Community! Whether you're building ...

The Latest Cisco Integrations With Splunk Platform!

Join us for an exciting tech talk where we’ll explore the latest integrations in Cisco + Splunk! We’ve ...