topic average CPU Time calculation per request in QlikView

average CPU Time calculation per request

Thu, 15 Jan 2015 17:56:16 GMT

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 — Thu, 15 Jan 2015 19:33:29 GMT

maybe

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

Sum([Nº Peticiones])

MarcoWedel — Thu, 15 Jan 2015 23:01:13 GMT

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

thanks

regards

Marco

Fri, 16 Jan 2015 11:51:18 GMT

Thank you very much!!

It works fine!!!

Thank you again

maxgro — Fri, 16 Jan 2015 20:33:41 GMT

please close the discussion, thanks and good qlik