Mysql Percentages with multiple Group By -

-

i'm getting stuck on seems easy mysql task: counting data percentages of subtotals, given "with rollup" instruction.

i've searched internet lot, couldn't find works when have calculate partial percentages (that is, percentages when have grouped multiple columns)

here query:

select elements.*, plans.*, workers.*, count(action) counter elements join plans on elements.id_piano = plans.id_piano  join workers on plans.id_collaboratore = workers.id_collaboratore  group id_agency, category, action rollup

how can calculate each "counter" percentage of relative subtotal "with rollup" instruction gives??

really sorry trivial question, cannot done.

thanks in advance!

edit:

here now:

agency | category   | action      | counter  alfa   | skill      | e-learning  | 3  alfa   | skill      | coaching    | 2  alfa   | skill      | null        | 5  alfa   | attitude   | on-the-job  | 2   alfa   | attitude   | null        | 2  alfa   | null       | null        | 7

and on...

here have:

agency | category   | action      | percentage  alfa   | skill      | e-learning  | 60%  alfa   | skill      | coaching    | 40%  alfa   | skill      | null        | 5  alfa   | attitude   | on-the-job  | 100%  alfa   | attitude   | null        | 2  alfa   | null       | null        | 7

and on...

in other words, calculate in way percentage relative first group criteria.


Comments

Post a Comment

Popular posts from this blog

Capture and play voice with Asterisk ARI -

-
there channel ari demo in wich can control channel state: ring, answer, play silence, play tone or audio-file ( https://github.com/asterisk/ari-examples/tree/master/channel-state , https://wiki.asterisk.org/wiki/display/ast/ari+and+channels%3a+manipulating+channel+state ) possible receive chunks (parts, buffers, etc.) of call voice (which created remote subscriber) or write chunks of voice, example array of bytes (not file) in audio format (alaw, ulow etc). you can use asterisk eagi interface voice data. other option use record or mixmonitor app record channel(channel have put stasis allow dialplan control ari) "write chunks of voice" can done application playback also can create own application using c/c++, compile asterisk , result want. no, can't redirect voice directly using ari.
Read more

java - Why database contraints in HSQLDB are only checked during a commit when using transactions in Hibernate? -

-
i spotted odd behavior in hsql, seems when using database transactions database contraints not checked during sql inserts during sql commits , when transaction rollbacked not checked @ all. i have spring integration test: @runwith(springjunit4classrunner.class) @transactionconfiguration(defaultrollback=true, transactionmanager="transactionmanager") @transactional public class integrationtest { with test creates new entity instance , calls hibernate's persist on it. it works fine, when change defaultrollback false fails: caught exception while allowing testexecutionlistener [org.springframework.test.context.transaction.transactionaltestexecutionlistener@517a2b0] process 'after' execution test: method [public void myintegrationtest.test()], instance [myintegrationtest@546e61d5], exception [null] org.springframework.dao.dataintegrityviolationexception: not execute statement; sql [n/a]; constraint [null]; nested exception org.hibernate.exception.const...
Read more

visual studio - Installing Packages through Nuget - "Central Directory corrupt" -

-
i'm trying add package project using nuget (in vs2015). when click "install" button see downloading missing packages... at top of screen progress bar. after moment message replaced - an error occurred while trying restore packages: central directory corrupt. with "restore" button @ end same process. anyone have idea how fix this? edit 07/2017 a far easier method of solving issue visual studio re-download package - in visual studio open tools -> options . select nuget package manager . ensure both allow nuget download missing packages , automatically check missing packages during build in visual studio both ticked. click ok . in file explorer window navigate projects' "packages" folder. two options - figure out package @ fault described in original answer , delete its' folder or (if sure packages still available in nuget) delete package folders. back in visual studio build solution. visual s...
Read more