Form shows rows not in slice

TDVol
New Member

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.

0 1 164
  • UX
1 REPLY 1
Top Labels in this Space