Hi,
I recently submitted a data download request to Spotify - they sent me two json files. I extracted the data to Excel via Power Query (Excel file attached), but I’ve noticed that the json files seem to include data for partial streams, even if I accidentally click on a track and it plays for a couple of seconds. Is there any way I could filter the dataset to only include rows where tracks are streamed in full (the track is played from start to finish)?
Apologies if the solution is very simple and straightforward. Any help is much appreciated.
Many Thanks,
Jack
The file did not come through. Please try again and press 'Start upload' (and wait until it is complete) before submitting your reply.
Apologies, I don’t know why it didn’t upload last time.
Thanks for the file, but I can't really help without seeing all of the underlying data. I.e. the json file. I can double click on an item in the pivot table and then I see details for 1000 records and notice that there is a column for "tbl_Streaming_History[msPlayed]". I assume that this is for the duration of the stream, measured in milli-seconds (ms).
Taking that an average song last at least three minutes =180 seconds = 180000 ms you could start by filtering out anything less than that duration.
