I have a tabular report where a numeric field is being aggregated to show the average of values. If the average equals 0, the report displays a blank cell– in my case, the average of two values {0,0} = 0. The same happens if I choose any of the other aggregation methods if, in fact, all values in the set equal 0.
It'd be helpful if the report displayed a 0, instead of a blank. Blank looks like there isn't data when there really is data– the values just all happen to be zeros.
I did see a similar thread here, but I think this scenario is a bit different in that there are values populated on the records. i.e. I don't think this is a case where there's an absence of data, but I could just be being dense ̄_(ツ)_/ ̄
Question
Zero displaying as blank in report/ dashboard
+3
+1Hi Pele,
I understand we have issue displaying zero while "absence of data" (The linked post), but we didn't understand your issue. Could you please a video for better understanding.
I understand we have issue displaying zero while "absence of data" (The linked post), but we didn't understand your issue. Could you please a video for better understanding.
+3Hi Sai,
Thanks for the response. Below is a clip of what I'm running into. In this report, I have 3 numbers– all zeros. If I group by Survey Title and aggregate Sample Data by anything other than "Count" or "Count Distinct" the results will display as blank.
I think what I'm really trying to get at here is "0" isn't a null value, and the aggregation methods should display "0".
Cheers,
Pele
Thanks for the response. Below is a clip of what I'm running into. In this report, I have 3 numbers– all zeros. If I group by Survey Title and aggregate Sample Data by anything other than "Count" or "Count Distinct" the results will display as blank.
I think what I'm really trying to get at here is "0" isn't a null value, and the aggregation methods should display "0".
Cheers,
Pele
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.