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!

Stay Connected: Your Guide to July and August Tech Talks, Office Hours, and Webinars!

Dive into our sizzling summer lineup for July and August Community Office Hours and Tech Talks. Scroll down to ...

Edge Processor Scaling, Energy & Manufacturing Use Cases, and More New Articles on ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Get More Out of Your Security Practice With a SIEM

Get More Out of Your Security Practice With a SIEMWednesday, July 31, 2024  |  11AM PT / 2PM ETREGISTER ...