Start a new topic
Implemented

Extend statistics: When do I listen to music

At which hours do I listen to music:

SELECT HOUR(PlayedDate) AS playinghour, COUNT(History_ID) AS playcount FROM `tblhistory` WHERE 1 GROUP BY playinghour ORDER BY playinghour ASC

 

At which weekdays do I listen to music:

SELECT WEEKDAY(PlayedDate) AS playingday, COUNT(History_ID) AS playcount FROM `tblhistory` WHERE 1 GROUP BY playingday ORDER BY playingday ASC

 

Maybe even at which week in a year do I listen to music:

SELECT WEEKOFYEAR(PlayedDate) AS playingweek, COUNT(History_ID) AS playcount FROM `tblhistory` WHERE 1 GROUP BY playingweek ORDER BY playingweek ASC

 


Implemented in helium_12.0.14145.0.exe


Good idea, but I found it huge in a 1920x1080 screen. Huge and I have to roll to see all statistics. It would be better to show smaller statistics that are all shown, making rolling unecessary. looks more polished.

 

I think this should be a general change.
On 1920x1080 there should be three charts in height without scrolling on all tabs.

Please report this as a separate ticket since the original request is closed in this ticket.

Login or Signup to post a comment