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
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
Thanks! How can i show active and inactive count in a single bar stacked?
Try the updated query