Skip to main content

I have a column Chart displaying average satisfaction scores month over month. There are three fields that I am looking at. However, if the customer does not fill one of the fields, it displays as 0 (even though it is null). These are messing up the averages. Is there a way to prevent certain values from being a part of the calculation without removing the entire record from being added to the average? (i.e. One survey has 10 pt for product and 0 pts for the Support agent, how do I get the 10pt for product to be included in the average, but I do not want the 0pts to be added to the support agent average)

Hi Natalee, 

Elsewhere on the community, this related topic has gotten some attention. Does it apply to what you’re trying to do? https://community.skuid.com/t/is-it-possible-to-remove-the-0-values-from-charts