Skip to main content
shiv_kumar_katiyar
Gainsight Employee ⭐️⭐️
Feb 14, 2019 11:43 AM UTC
Solved

Restrict no value or '0' value in Graph

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.

rakesh
rakeshAnswer
Lets put your data to work!
Jun 16, 2020 8:51 AM UTC

Hi @hardik_mota 

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

3 replies

diane_morneau
Helper ⭐️⭐️⭐️
Feb 14, 2019 1:18 PM UTC
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.

Translate
hardik_mota
Helper ⭐️
May 21, 2020 10:35 PM UTC

Hi Team,

 

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

 

Best,

Hardik

Translate
Hardik
rakesh
Gainsight Employee ⭐️
rakeshAnswer
Lets put your data to work!
Jun 16, 2020 8:51 AM UTC

Hi @hardik_mota 

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

Translate