Spotify Music Challenge

Siddharth Warrier Avatar

Siddharth Warrier

Additional project images

Siddharth Warrier Avatar

Siddharth Warrier

More projects by Siddharth

LEGO Dashboard

0 Likes

0 Comments

Maven NorthWind Challenge Dashboard

1 Likes

0 Comments

Discussion and feedback(2 comments)

comment-2453-avatar

Abhisekh Nayak

21 days ago

Interesting & detailed work, Siddharth. Can you describe how did you calculate time frame?

comment-2458-avatar

Siddharth Warrier

Project owner

20 days ago

Project owner

Thank you Abhisekh. When you say time frame, did you mean to ask how I arrived at the track hours measure? If that is your query, I calculated a new measure called Total track hours played by using a combination of Divide and sum function and converting denominator as 3600000 . The formula used was DIVIDE(SUM(spotify_history[ms played]),1000*60*60). This gave me the total duration of all tracks played put together in hours.