Set conditions to display only certain fields on a chart

  • 1
  • Question
  • Updated 4 months ago
  • Answered
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)
Photo of Natalee

Natalee

  • 70 Points
  • unsure

Posted 4 months ago

  • 1
Photo of Mark DeSimone

Mark DeSimone, Official Rep

  • 11,050 Points 10k badge 2x thumb
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/skuid/topics/is-it-possible-to-remove-the-0-values-from-charts