Hi, I have to create a Stacked bar graph with total count and missing count.
A.csv - 3000
B.csv - 2900
C.csv-3100
I have to compare B.csv and C.csv with A.csv to get the list, which are present in A, but missing in B and C? Now I'm using them seperately Total count and missing count. suggest me a best way to show them in single panel as stacked bar graph with total and missing count?
searches I'm using:
For total list:
| inputlookup A.csv | eval file="A" | inputlookup append=t B.csv | fillnull file value="B" | inputlookup append=t C.csv| fillnull file value="C"| stats count by file
For missing list:
|inputlookup A.csv |lookup B.csv Name0 OUTPUTNEW Name0 AS status|search NOT status=* | eval file="B" |append[|inputlookup A.csv |rename "Device Name" as Name |lookup C.csv Name OUTPUTNEW Name AS status|search NOT status=*|eval file="C"] |stats count by file
Try this
| inputlookup A.csv | eval file="A" | inputlookup append=t B.csv | fillnull file value="B" | inputlookup append=t C.csv| fillnull file value="C"| eval status=coalesce(name0, "Device Name") | eventstats dc(file) as files by status | eval "missing.in.a"=if(mvcount(files)=3, "no", "Yes")