Charts are not filtered for null values

  • 1
  • Problem
  • Updated 7 months ago
  • In Progress
I have chart which uses an aggregate model and displays values for different Regions. When I click on any region on the chart, it filters model to show data for the selected region only. There are some records where Region is blank so chart group them under "null" category. The problem is that when I click on null category on the chart, it does not filter model where Region is null. Is that the standard behavior? Can this be fixed?
Photo of Shalabh Sharma

Shalabh Sharma

  • 294 Points 250 badge 2x thumb

Posted 7 months ago

  • 1
Photo of Luzie Baumgart

Luzie Baumgart, Official Rep

  • 1,310 Points 1k badge 2x thumb
Hi Shalabh Sharma, can you reproduce this issue on a new page that only contains the chart and standard salesforce objects and fields? If yes, could you please share the XML? I would like to test it.
Thanks, Luzie
Photo of Shalabh Sharma

Shalabh Sharma

  • 294 Points 250 badge 2x thumb
Sorry but what we have is a complete custom implementation and we dont use standard objects so replicating it would be difficult. But what I notice is that when I try to click on the null category the generated query on the model, does not have that null check.
Photo of Mike Dwyer

Mike Dwyer

  • 3,390 Points 3k badge 2x thumb
We had a similar issue with charts listing clients and a small number of responses at regular meetings. Frequently the Response value was "None" (i.e. null) and there was no information generated for that slice of the "pie." We restructured the object and interface so that a "Not Answered" value could be defaulted into the field and clean up the chart. (This was in Brooklyn, by the way.)
One suspects a test case might be built using the User object, Luzie, as we also would need to do in our fully custom environment.
Photo of Shalabh Sharma

Shalabh Sharma

  • 294 Points 250 badge 2x thumb
So, you are suggesting to replace all "null" values with an actual "Null" picklist value?