header
Solved

Restrict no value or '0' value in Graph

  • 14 February 2019
  • 3 replies
  • 103 views

Userlevel 6
Badge
Hi All,



When we create a graph/chart report on Date field, system automatically decides the date range based on filter critera but there is no option to restrict the data for no data for particular period-

Like here- Is there a way to set up a report to use a filter on a date, but not have it show zeroes all the way through the future . You can do it using custom date filter but not with > < , last 90 days etc.

icon

Best answer by rakesh 16 June 2020, 10:51

Hi @hardik_mota 

Currently apart from filtering out the data, there is no other way to handle this.

View original

3 replies

Userlevel 5
Badge
The solution is to remove the problem at the source - that is ensure no zero data is part of what is to be plotted. That's when I started to use Query builder / rules.

Userlevel 5
Badge

Hi Team,

 

Do we have any other solution instead of changing the source or applying a custom filter? 

 

Best,

Hardik

Userlevel 6

Hi @hardik_mota 

Currently apart from filtering out the data, there is no other way to handle this.

Reply