Splunk Search

How can I show lookups in the Stacked bar graph ?

kiran331
Builder

Hello,

I have 6 lookups, I have to show the stacked bar graph of three types a,b,c with showing active and inactive count?Whats the best way to show this one?

a_active.csv
a_inactive.csv
b_active.csv
b_inactive.csv
c_active.csv
c_inactive.csv

Tags (2)
0 Karma
1 Solution

sundareshr
Legend

Try apppending them, like this
*UPDATED*

| inputlookup a_active.csv | eval File-"A" | eval status="Active" | append [| inputlookup a_inactive.csv | eval File-"A" | eval status="InActive"] | append [| inputlookup b_active.csv | eval File-"B" | eval status="Active" etc etc etc] | chart count over File by status

View solution in original post

0 Karma

sundareshr
Legend

Try apppending them, like this
*UPDATED*

| inputlookup a_active.csv | eval File-"A" | eval status="Active" | append [| inputlookup a_inactive.csv | eval File-"A" | eval status="InActive"] | append [| inputlookup b_active.csv | eval File-"B" | eval status="Active" etc etc etc] | chart count over File by status
0 Karma

kiran331
Builder

Thanks! How can i show active and inactive count in a single bar stacked?

0 Karma

sundareshr
Legend

Try the updated query

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...