[Koha] Help with report on percentage of Circ

[Nicole Engard]

I got this request today and I have to admit it's a bit over my head
in terms of the math involved. Can someone help me with this report?

-------------

May we have a report that will give us the total circulation for a
specific time frame and what percentage was attributed to a specific
JUR Code?

I ran this report and for example it gave me 128% as the percentage of
total circ for JUR Code M814.

SELECT
   x.attribute as 'Attribute',
   x.issues as 'Circ for this attribute',
   (x.issues * 100)/(
     SELECT COUNT(s.datetime) as 'total'
     FROM statistics s
     WHERE type = 'issue'
     AND s.datetime BETWEEN <<Date BETWEEN (yyyy-mm-dd)>> AND <<and
(yyyy-mm-dd)>>
   ) as 'Percentage of total circ'
FROM
   (SELECT
     ba.attribute as 'attribute',
     COUNT(s.datetime) as 'issues'
   FROM statistics s
   JOIN borrower_attributes ba
     ON s.borrowernumber = ba.borrowernumber
   WHERE ba.code = 'JUR'
     AND s.datetime BETWEEN <<Enter the same dates again BETWEEN
(yyyy-mm-dd)>> AND
     <<and (yyyy-mm-dd)>>
   GROUP BY attribute) x