Dashboards & Visualizations

How to show total count of stacked chart on the top of column?

prafulljha
New Member

Hi,
I have total four fields lets say a,b,c and d. i want to show 'a' as a separate column and 'b','c' and 'd' as stacked and beside 'a' along with the sum of fields ('b'+'c'+'d') so that the count of these fields would come on the top of their column so that we can easily compare field 'a' with the count of rest.
Note:- I don't want separate column which would give sum of these three field. You can refer the screenshot.

In case you want further details feel free to ask.
Any help would be appreciated.

Thanks.

Tags (1)
0 Karma

niyaz006
Path Finder

Were you able to achieve this? Two bars with just one stacked as shown in your image.

0 Karma

davesplunk01
Path Finder

Alternative approach ,

search ... | addtotals 

Add totals gives you the row total with the field name Total

  1. Click visualization select column chart
  2. Click format and enable the stack mode.
  3. select show data values as on
  4. Click chart overlay and Click the text box and select Total field.
  5. makeView as Axis as off
  6. Click Apply.

you will get the stacked chart with numbers. overlay will be an line chart shows number.

smanojkumar
Communicator

Hi @davesplunk01 ,

   I'm having the same senario like this, after the above steps that you had mentioned, I can see the total on the top along with the line, 

 

smanojkumar_0-1696423927952.png

 I don't need line, Can you please help me in this.

Thanks in Advance!

Manoj Kumar S

0 Karma

DalJeanis
SplunkTrust
SplunkTrust

Sounds like a very specialized visualization. Hmmm. Might be useful.

Basically, you want to be able to "group" the series and stack them. The fact that one of your groups has only one member (a) and the other has three (b,c,d) is irrelevant to the design of the viz.

Seems like you'd want to be able to choose the base color of each group, and have the individual series be variants of that color (up to N different blues for group 1, up to N different reds for group 2, up to N different greens for group 3, etc.)

Don't know of anything like that, but it does seem quite useful. For instance, if you wanted to compare causes of death for men and women, in number of deaths per 100 K, that would be a good viz.

Hmmm. Could also be same colors in each stack in that usage, with maybe a single skinny bar up the side of the stack for group total...

0 Karma
Get Updates on the Splunk Community!

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...

Let’s Get You Certified – Vegas-Style at .conf24

Are you ready to level up your Splunk game? Then, let’s get you certified live at .conf24 – our annual user ...