I am trying to get a stacked column chart with items sold by agent at each location.
I have the below search:
stats count by "Locations","Emp_Name" |chart sum(count) over "Locations" by Emp_Name where top20.
In this case, the chart is showing with the stack values, but also shows 0 in between the stacks.
Maybe you need to manually remove/add the columns you desire fields - colnames
?
Try this
stats count by "Locations","Emp_Name" | where count>0 |chart sum(count) over "Locations" by Emp_Name