How to get an accurate aggregate average of a percentage on a line chart?
I have a line chart that shows a percentage across categories (opens/delivered graphed by email campaign). I would like to show which campaigns are above or below average with a line on the graph. Because of the different sizes of the email campaigns I cannot just average the ratios - instead I need to divide all the opens by all the deliveries for filtered data. It seems that the default average in Domo won't do this, but I was able to get the overall average to show as the summary number with this beast mode:
sum(`UniqueOpens`) / sum(`NumberDelivered`)
However I can't seem to get this to show as line on the graph. The blue line is what I want to show while the black line is the average of the ratios.
I want the graphed average to change as the dataset is filtered by end users, so if they want to compare a subset of the campaigns they could see which ones are above/below average of the subset.