Hi,
So I am having a really weird issue with domo. I have a data set with 2662 rows and am trying to average let's say a column called marks for these students.
I have created a column called percentile ranking which I created using ETL where I can see how high or low the mark is in that data set.
When I create a single value card to show the average of the whole data set the average is correct.
However when I filter out the highest 10% marks (so I filter to show percentile over and equal to 0.1) the average is incorrect. Bear in mind I have 0 values before the filtering and after so that should not be affecting the average.
Do you know why it is not showing me the right average? I have tried using beast mode for the average, as well as just column value average in single value card, same issue. Tried doing sum/count of column still same issue.
Thanks!