average CPU Time calculation per request

[#1]

Hello friends,

I am new at qlikview and I have a problem when I try to graph avarage response time per application.

My data seems like this table:

Time	Aplicación	Nombre	Nº Peticiones (Requests)	AVG CPU Time
23:47:05	APP34	existeBloqueo	226	21477
23:47:05	APP34	consultarReserva	1169	15228
23:47:05	APP34	informativa47	421	82572
23:47:05	APP34	informativaPlzEspecial	9	9585
23:47:05	APP34	informativa73	197	7250
23:57:06	APP34	informativa47General	49	39666
23:57:06	APP34	informativa47	815	38629
23:57:06	APP34	consultarEstadoPlazaReserva	269	3957
23:57:06	APP34	anularReserva	161	33403
23:57:06	APP34	solicitarReservaNT	714	50186
…	….	…	…	…

My problem is the Expresion. I am trying something like [Nº Peticiones]*[AVG CPU Time]/Sum([Nº Peticiones]) but it does not work.

Please, Could anyone help me?

Thank you very much

[maxgro]

maybe

sum([Nº Peticiones]*[AVG CPU Time])

/

Sum([Nº Peticiones])

[MarcoWedel]

can you elaborate a bit more on the calculation and the data?

thanks

regards

Marco

[#4]

Thank you very much!!

It works fine!!!

Thank you again

[maxgro]

please close the discussion, thanks and good qlik