Navigate the drop downs - choose Hour (see screenshot).
So click on the little calendar icon next to the UTC_time (Date).
Screen will refresh, but still uses the date.
On the right of the screen - under the heading Dimension click on My Date.
Automatically a chart is added - but it used your ‘My Date’ custom field.
Time is tracked as UTC - this is basically fine for me as I live in the UK - you can do your own work to change this.
Under the Data settings on the right of the screen, scroll down to Default Date Range.
Make sure you have clicked to select the Top Artists chart (blue line around the chart).
What just happened … To get you started, it automatically created a table of Top Artists by scrobbles (aka record count). If prompted, click on My Data Sources and choose Last.fm / CSV that you uploadedĬlick OK to Add to Report Top Artists (All Time) Now for the fun part - create your report - by default, it starts with all your listening data - but don’t worry….
In the Formula type EXTRACT(date from utc_time) - it should even auto select the data field for you.
Now on the next screen you want to add a field - this is because the Last.fm date field includes the UTC time.
When its done uploading, the Connect button will change and you can click it.
CSV file to your computer Prepare your data - with Google Data Studios Last.fm used to allow you to download all your data - don’t worry you can do this via their API. Last.fm using Google Data Studio Download your data Here’s a short guide to make your own report of listening trends and habits for So I made my own visualisation of my listening trends for this year. Last.fm - I’ve loved you for so many years. It’s that time of the year and every major music listening service is sending out emails summarising listening habits … except one.
0 kommentar(er)
