Can I omit certain values on line graph from being calculated in avg line?


I have an interesting case here, I have a cost per lead value being graphed by week for the past 9 weeks. Only problem is that when there are no leads the value is blank and the line breaks. I can fix the problem by using a beast mode to say when there are no leads to just zero out the Cost per Lead value. When I do that, obviously it brings the avg Cost per Lead down by including a zero into that calculation, and I'd like to omit that value from the calculation.

Maybe there is a better solution to this that I am not thinking of? My superior wants there to be no breaks, but when I thought I found the solution it messes up the calculated avg line. Maybe I can create another beast mode to act as an avg line and turn off the Domo implementation of that in Analyzer?

Best Answer

  • ColemenWilson
    Answer ✓

    Chart Properties > General > Hide Empty Values:

    If I solved your problem, please select "yes" above