How to remove zeros from appearing on my stacked column chart?

[chintan_shah]

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.

[HattrickNZ]

Maybe you need to manually remove/add the columns you desire fields - colnames?

[sundareshr]

Try this

stats count by "Locations","Emp_Name" | where count>0 |chart sum(count) over "Locations"  by  Emp_Name