Spotify specifies 4 values (quartiles). The last one in complete and not the avg of the 4th quartile. Currently we compare this value with apples avg as we calc the 4th quartile on apple values by ourselves Dor spotify we take tha value from Spotify. We should align that to be compare the right values.
Possible solutions:
rename the field in the db to complete
calc quartile values by ourselves
verify how quartiles are calculated by Spotify and change or own computation accordingly.
Remark: "Complete" doesn't make sense as the number drops in last seconds and usually this value is super low, even though most listeners might have listened to 99% and then dropped out.
Spotify specifies 4 values (quartiles). The last one in complete and not the avg of the 4th quartile. Currently we compare this value with apples avg as we calc the 4th quartile on apple values by ourselves Dor spotify we take tha value from Spotify. We should align that to be compare the right values.
Possible solutions:
Remark: "Complete" doesn't make sense as the number drops in last seconds and usually this value is super low, even though most listeners might have listened to 99% and then dropped out.