Hi,

I have a file_saved event for the application I am working on, and the event has a unique_ID property and a file_size property. Unfortunately, I’m running into the issue where users like to save the same file over and over again, so any calculation of average file_size gets skewed by users who save the most.

The overall property average in Amplitude is something like 2.1MB, but when I calculated the average size for each individual file, then took an average of that, I got closer to 5.5MB. To me, this seems like a large disparity.

Is there some formula equivalent to Average file_size (Average file_size for each unique_ID, Event A) or something similar?

Is there any other way to prevent users spamming events from skewing the data, or is there a different approach to this problem entirely?

Any help would be much appreciated!

Thanks,

Greg