I can experiment with the code and get results quickly
iliekcomputers
ooh nice
that notebook was pretty cool.
ishaanshah
So I continued working on daily activity graph
iliekcomputers
mhmm sounds good.
i was thinking
ishaanshah
I had some second doubts about how to present the data
iliekcomputers
the way you truncated the listened_at in the query
we could do it for listening_activity as well right?
could you put down a comment on the jira we have open for making the listening activity query more scalable
so that we don't forget
ishaanshah
Yep will do
iliekcomputers
awesome.
cool, so what doubts did you have?
ishaanshah
Yeah so, the notebook that I linked had graph for your data
iliekcomputers
ah, right :D
i saw that it didn't look very good :P
ishaanshah
I looked at some more user's data
It looks even worse for others
*users'
iliekcomputers
hmmm
i figure it'll improve for the larger time frames
but i think we might have to not display the weekly one eventually.
ishaanshah
The listens were from jan to july
i.e year
iliekcomputers
oh
i thought it was an incremental dump?
ishaanshah
Although its incremental dump
iliekcomputers
right. so for me it'd only have data for a week or so
ishaanshah
Hmm
iliekcomputers
here's what I think: let's calculate and build the API endpoint anyways. then when you're working on the frontend, we can look at how it actually looks and see where to go from there
ishaanshah
Yeah ig that works
If it doesn't look good, we can just sum all of them together and display the graph
or maybe average
But that can easily done on the frontend
iliekcomputers
mhmm.
ishaanshah
Cool, so I will complete the tests tomorrow and get the PR ready for review