Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone, I have a problem and quisiser know if I can help get the following information:
My |
| AVG T. Atención | AVG |
12890 |
| ||
one | 2172 |
| |
feb | 3713 |
| |
mar | 2595 |
| |
abr | 2137 |
| |
may | 1759 |
| |
jun | 514 |
|
And the problem in April to spend this time in excel format gives me 1 day with 32 minutes of this form
My |
| AVG T. Atención | AVG |
12890 |
| 00: 10: 36: 11 | |
one | 2172 |
| 00: 10: 06: 06 |
feb | 3713 |
| 00: 10: 03: 45 |
mar | 2595 |
| 00: 08: 45: 06 |
abr | 2137 |
| 01: 00: 32: 03 |
may | 1759 |
| 00: 01: 06: 04 |
jun | 514 |
| 00: 00: 34: 07 |
I wonder if I can do it in graphic QlikView because if this is wrong and gives me a gráica of attention tiempode wrong, but wrong gives me a pop just to 32 minutes and this causes confusion
And I'd like to leave 1 days 32 minutes of attention.
I hope you can help me.
I am not sure I understand your requirement completely. Can you try to may be re-explain please?
Best,
Sunny
Josue como estas?
Podras explicar mejor tu consulta, para que sea mas facil ayudarte
saludos
Fernando
Hellow Sunny,
Thanks for thake a few minuts to this, well i have some dates, and i convert them in number to take the avg of two diferent rows, and the result i want to do a graphic of them, the exercice is
Mes | T. Monitoreo | AVG T. Atención | AVG QlikView | AVG Excel |
ene | 2172 | 0.42090322 | 10:06:06 a. m. | 0 day 10:06:06 |
feb | 3713 | 0.419268926 | 10:03:45 a. m. | 0 day 10:03:45 |
mar | 2595 | 0.36465677 | 08:45:06 a. m. | 0 day 08:45:06 |
abr | 2137 | 1.022257399 | 12:32:03 a. m. | 01 day 00:32:03 |
may | 1759 | 0.045884953 | 01:06:04 a. m. | 0 day 01:06:04 |
jun | 514 | 0.023692738 | 12:34:07 a. m. | 0 day 00:34:07 |
Mes = Month
T.Monitoreo = Tickets Monitorion
AVG T Atención = Average attention Tickets
AVG QlikView = The format that QlikView
AVG Excel = The formar of Excel
And i want to do in QlikView the same like Excel, and grafic them, because if i grafic whith this data the grafic confuse to the user
This data confuse because in the 2 times April and June the data is in April 12:32:03 A.M. and June 12:34:07 A.M. and de diference is about 2 minutes and It is not understandable the diference in the graphic, I hope to be more explicit.
Regards!!!
See if this helps:
Interval(AVG QlikView, 'D hh:mm:ss')
if not, then would you be able to share a sample?
Best,
Sunny
Hola Fernando
Lo puse en ingles no se si me explique, pero el tema es que tengo dos columnas en la data donde sumo los tickets generados para un tema de monitoreo, y después de eso, saco el promedio de atención de eso tickets, tal como lo pmuestro aqui en la tabla
Mes | T. Monitoreo | AVG T. Atención | AVG QlikView | AVG Excel |
ene | 2172 | 0.42090322 | 10:06:06 a. m. | 0 day 10:06:06 |
feb | 3713 | 0.419268926 | 10:03:45 a. m. | 0 day 10:03:45 |
mar | 2595 | 0.36465677 | 08:45:06 a. m. | 0 day 08:45:06 |
abr | 2137 | 1.022257399 | 12:32:03 a. m. | 01 day 00:32:03 |
may | 1759 | 0.045884953 | 01:06:04 a. m. | 0 day 01:06:04 |
jun | 514 | 0.023692738 | 12:34:07 a. m. | 0 day 00:34:07 |
El tema es que cuando hago el formato de el número en Qlik me dala columna de AVG QlikView, y despues de tanto pensar, lo exporte a Excel y le di un formato en la columna AVG Excel, y en realidad me da ese resultado, todos me dan 0 días excepto Abril me da 1 día y 32:03 seg
Esto genera una confusión ya que en Abril al ponerse encima del dato aparece 12:32:03 a. m. y en la data es menor que cualquier otro de los meses anteriores, y cuando gráfica Junio 12:34:07 a. m. y eso es lo que confunde, entonces quisiera saber como hacer que la gráfica al sacar los emergentes de 1 día 32:03 minutos.
Espero haber sido mas explicito y cual es la confusión al ser más detallado y te agradezco Fernando.
Saludos.
Hellow Sunny,
It´s do not work !!!
I can share my document, where can i upload???
Regards
Carlos.
Hello Shuny i posted the document here:
Thanks!!!
While replying, click on 'Use advanced editor' on upper right of the reply window
It will take you to another window where you will have the option to attach on lower right.
Best,
Sunny
Hellow Sunny,
It´s atached.
Regards