Skip to main content
Solved

Restrict no value or '0' value in Graph

  • February 14, 2019
  • 3 replies
  • 108 views

shiv_kumar_katiyar
Forum|alt.badge.img+2
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.

Best answer by rakesh

Hi @hardik_mota 

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

3 replies

diane_morneau
Forum|alt.badge.img
  • Helper ⭐️⭐️⭐️
  • February 14, 2019
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.


hardik_mota
Forum|alt.badge.img+4
  • Helper ⭐️
  • May 21, 2020

Hi Team,

 

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

 

Best,

Hardik


rakesh
Forum|alt.badge.img+2
  • Lets put your data to work!
  • Answer
  • June 16, 2020

Hi @hardik_mota 

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