I think these may be named incorrectly in light of the change to multiple ISWCs
count.iswc.all (the 'all' stat) has:
SELECT COUNT(DISTINCT work) FROM iswc
and count.iswc (the 'unique' stat) has:
SELECT COUNT(DISTINCT iswc) FROM iswc
One option is to change these to be displayed as "number of works with an ISWC" and "number of unique ISWCs", and keep the data collection as it is.
Interestingly, the isrc equivalents seem to be calculated differently, which is why they don't have this problem. The other option for these is to move to that, where the .all stat has, instead:
Ian McEwen added a comment - 04/Aug/12 10:01 PM I think these may be named incorrectly in light of the change to multiple ISWCs
count.iswc.all (the 'all' stat) has:
SELECT COUNT(DISTINCT work) FROM iswc
and count.iswc (the 'unique' stat) has:
SELECT COUNT(DISTINCT iswc) FROM iswc
One option is to change these to be displayed as "number of works with an ISWC" and "number of unique ISWCs", and keep the data collection as it is.
Interestingly, the isrc equivalents seem to be calculated differently, which is why they don't have this problem. The other option for these is to move to that, where the .all stat has, instead:
Interestingly, the isrc equivalents seem to be calculated differently, which is why they don't have this problem. The other option for these is to move to that, where the .all stat has, instead:
Interestingly, the isrc equivalents seem to be calculated differently, which is why they don't have this problem. The other option for these is to move to that, where the .all stat has, instead:
SELECT COUNT from iswc
.
Thoughts?
Bug
Closed
Normal
Statistics: "unique" number of ISWCs is higher than "all" number of ISWCs
from iswc
I think these may be named incorrectly in light of the change to multiple ISWCs
count.iswc.all (the 'all' stat) has:
and count.iswc (the 'unique' stat) has:
One option is to change these to be displayed as "number of works with an ISWC" and "number of unique ISWCs", and keep the data collection as it is.
Interestingly, the isrc equivalents seem to be calculated differently, which is why they don't have this problem. The other option for these is to move to that, where the .all stat has, instead:
Thoughts?