I have a table with Leads. One of the columns has the Lead Status. I have a slice that shows only the rows that have certain Lead Statuses. Basically, I am filtering out various statuses such as Closed - Lost. When I View Data in the Slice, it is just as expected. I am using that slice to summarize the number of Leads with the remaining statuses. However, when I use that slice in a form (chart), it shows the statuses that I filtered out. It is not counting the data in those statuses, but it is showing the statuses none the less.
So, the form (chart) is showing a line for Closed - Lost even though there are no records in the slice with that status. It does show it blank as in zero, but I do not want the category to show at all. It is odd because in other forms, there is no category if there is no data in the slice.
User | Count |
---|---|
24 | |
14 | |
4 | |
3 | |
3 |