[Koha] Help with report on percentage of Circ

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

Re: [Koha] Help with report on percentage of Circ

Hi Nicole, I think you just need to add AND s.type = 'issue' to the WHERE section of your query for x (e.g. right after ba.code = 'JUR'). That got the numbers looking right for my collection. --Katelyn. Katelyn Browne Middle/High School Librarian Capital City Public Charter School 100