Is there a way to see the total dayly/weekly/monthly number of fivestar votes on my site?

Thanx..

Comments

quicksketch’s picture

Title: Fivestar statistics » Day, month, year total statistics
Project: Fivestar » Voting API
Version: 5.x-1.7 » master
Component: Documentation » Code
Category: support » feature

Neither Fivestar nor VotingAPI (which handles recording votes) supports this capability. Since VotingAPI is actually responsible for storing and retrieving data, I'll move this request to that queue as a new feature.

The trouble with daily/weekly/monthly totals is the amount of information that either needs to be queried or somehow cached. Figuring out total number of votes for a week (by timestamp) then sorting requires a temporary table if we don't have caching (read: horribly slow). The other approach is to build cache tables specifically to store totals in day, week, and month long intervals. Which will be much more efficient on retrieval but a slight increase in resources for inserts.

In the mean time, it's best to know that this currently is not possible without significant enhancements to VotingAPI.

eaton’s picture

Status: Active » Closed (won't fix)

There's nothing to prevent a module from using its own SQL to pull that information out of the VotingAPI tables, but at present there are no plans to include the functionality in VotingAPI directly.