How can I show lookups in the Stacked bar graph ?

[kiran331]

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

[sundareshr · Accepted solution]

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

[kiran331]

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

[sundareshr]

Try the updated query