Solved

Restrict no value or '0' value in Graph

  • 14 February 2019
  • 3 replies
  • 101 views

Userlevel 4
Badge +1
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

View original

3 replies

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 4
Badge +4

Hi Team,

 

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

 

Best,

Hardik

Userlevel 6
Badge +1

Hi @hardik_mota 

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

Reply