topic Analytics showing average edit time = 0 in QlikView

Analytics showing average edit time = 0

Mon, 13 Sep 2010 09:36:07 GMT

Hi,

A user using the Analytics sw (Qlikview) has stated that all of the tables that have average edit time are showing 0.0.

Is this because the average time the documents have been opened is less than 0.1 hours or because the average edit time is not being captured?

If the time is less than 0.1 hours, can the resolution on this number be increased?

Also we wanted to know if the Edit Time is correct to be zero in all of the tables from the Analytics URL? We are focusing on all the tables not just one or a couple of these.

The main thing to know is if these times are being captured correctly?

Is there something we can look at to see what the actual edit time is that perhaps isn't rounded just to confirm?

Could you please give me some guidance on this? Is this a normal behavior?

Thanks,

Vijaya

Analytics showing average edit time = 0

Wed, 29 Sep 2010 09:22:49 GMT

Hi,

Can any one provide me some suggestion on this?

Thanks,

Vijaya

Analytics showing average edit time = 0

vgutkovsky — Wed, 29 Sep 2010 09:28:33 GMT

Vijaya,

If you mean the object calculation times in Document Properties --> Sheets, then these are not updated until the document is actually accessed. When they report 0 that just means that the document has not cached during that session yet. You can probably write a macro that would iterate through all the sheets and all the objects (activating each). You can then output the results and read the max(time) per object back into QV.

Regards,

Analytics showing average edit time = 0

Wed, 29 Sep 2010 09:42:00 GMT

Hello Vlad,

Thanks for your response. Here is what i am trying to find out:

I am talking about the Average Edit time in following reports and tables they are having.

1. The Active Workflow Report has only one table "Workflow Tasks" where Edit Time (hrs) means, the number of hours that have been spent editing the Document in all Workflow States.

2. The Workflow Analysis Report has only one table "Documents" where Edit Time (hrs) means, the number of hours devoted to editing the Document in all Workflow States.

3. The "Creators" table lists users who created Document versions, and shows productivity details about that users. Here the Avg Edit Time (hrs) means, the average number of hours that the Creator spent editing each Document.

4. The "Contributors" table lists users who contributed to Documents in the Authoring Workflow. Here Avg Edit Time (hrs) means, The average number of hours the user spent editing a Document. Draft The number of Documents contributed to by this user that are still draft. Deleted draft Documents are not counted.

Customer stated that she wanted to know if the Edit Time is correct to be zero in all of the tables from the Analytics URL?

Are these times are being captured correctly in these tables when user view, contribute the document?

Also is there something we can look at to see what the actual edit time is that perhaps isn't rounded just to confirm?

Customer noticed that All of the tables that have average edit time are showing 0.0. Is this because the average time the documents have been opened is less than 0.1 hours or because the average edit time is not being captured? If the time is less than 0.1 hours, can the resolution on this number be increased?

Any Suggestions on this,

Analytics showing average edit time = 0

vgutkovsky — Wed, 29 Sep 2010 17:13:36 GMT

How can anyone know the answer as to whether your data is correct or not? Maybe if you post your expressions then some problems might jump out at us...

But if you're seeing problems with the data only in the AccessPoint, make sure you're not reducing your numbers out with Section Access.

Regards,

Analytics showing average edit time = 0

Wed, 06 Oct 2010 10:03:45 GMT

Hello Vlad,

I received following update on this issue:

------------------------------------------------------------------------

There are documents that have been accessed but they are still showing edit time = 0.0. I have attached an output from QlikView, Workflow Analysis tab, Documents table. The documents that are displayed in the attachment (the lines that aren't hidden) are ones that have been recently published therefore I know they have been accessed recently. All of them show edit time = 0.0. It seems odd to me if the data is true."

------------------------------------------------------------------------

Here are the details I received from customer.

Document ID+Version	Document Title	Create Date	Published Date	Workflow State	Content Manager	Author	Publication Status	Days in Workflow	Edit Time (hrs)
11011(v1)	Where can I get support for OSM application related issues?	2010-09-02 15:09	2010-09-02 15:20	-	208018059 (Kelly Graf)	208018059 (Kelly Graf)	Published	0.0	0.0
10641(v1)	What sound options are available for the WorkstationST Alarm Viewer?	2009-10-07 02:46	2010-09-02 15:25	-	105034144 (Goutam Banerjee)	105035220 (Ramesh Pai)	Published	330.5	0.0
11171(v1)	Are temporary totalizer passwords specific to a controller?	2010-03-02 07:46	2010-09-02 15:27	-	admin (Admin Admin)	105039983 (Vinodth Kumar)	Published	184.3	0.0
11713(v1)	What is a *.ecb file?	2010-02-05 07:41	2010-09-09 08:18	-	105034144 (Goutam Banerjee)	105034925 (Nikesh Savant)	Published	216.0	0.0
10416(v1)	How do I resolve lockup issues with the EX2100 DSPX board?	2009-10-01 05:17	2010-09-09 08:23	-	105034144 (Goutam Banerjee)	105034925 (Nikesh Savant)	Published	343.1	0.0
11440(v1)	Which type Ethernet cable should be used when connecting the ACLx board of an EX2100 excitation control to the Unit Data Highway (UDH) network switch?	2010-01-27 00:53	2010-09-09 08:25	-	105034144 (Goutam Banerjee)	105034925 (Nikesh Savant)	Published	225.3	0.0
11248(v1)	What is the termination screw details for TRPA board?	2010-09-08 05:31	2010-09-09 12:35	-	105034144 (Goutam Banerjee)	105035220 (Ramesh Pai)	Published	1.3	0.0
12069(v1)	How to adjust electrical null bias for servos in Mark Vie?	2010-04-06 07:58	2010-09-09 13:33	-	admin (Admin Admin)	105039983 (Vinodth Kumar)	Published	156.2	0.0
11277(v1)	Is it possible to set the CMOS parameter on UCVG after replacing the battery at site?	2010-09-13 02:41	2010-09-13 08:06	-	admin (Admin Admin)	105039983 (Vinodth Kumar)	Published	-	0.0
11265(v1)	How to add a device with the same name as a deleted device using ToolboxST and CMS	2010-09-13 01:37	2010-09-13 09:00	-	admin (Admin Admin)	105039983 (Vinodth Kumar)	Published	0.3	0.0
11476(v1)	How to Replace a Hard Drive used for Industrial HMI Systems Provided by CCS	2010-09-15 14:36	2010-09-15 14:58	-	208018059 (Kelly Graf)	208018059 (Kelly Graf)	Published	0.0	0.0
11382(v1)	What is the default password for the EX2100 keypad?	2010-01-22 01:12	2010-09-23 14:10	-	105034144 (Goutam Banerjee)	105034925 (Nikesh Savant)	Published	244.5	0.0
10450(v1)	Why is the isolation transformer of the LS2100 Static Starter not grounded?	2010-02-24 07:34	2010-09-23 14:15	-	105034144 (Goutam Banerjee)	105034925 (Nikesh Savant)	Published	211.3	0.0
10897(v1)	Which shielded cables should be used for power connections on the LS2100 Static Starter?	2009-10-15 01:27	2010-09-23 14:19	-	105034144 (Goutam Banerjee)	105034925 (Nikesh Savant)	Published	343.5	0.0
10445(v1)	What is the difference between a static and a rotating excitation control?	2009-10-01 06:18	2010-09-23 14:27	-	105034144 (Goutam Banerjee)	105034925 (Nikesh Savant)	Published	357.3	0.0

Any suggestions on this?

Thanks,

Vijaya

Analytics showing average edit time = 0

Thu, 14 Oct 2010 10:04:20 GMT

Hello,

Can i have some suggestion on this?

Please check the data provided in my previous note and suggest me something.

Thanks,

Vijaya

Analytics showing average edit time = 0

vgutkovsky — Thu, 14 Oct 2010 18:38:35 GMT

I really don't know what to tell you if you can't post your expressions or a sample of your application...there's not much I can tell you from the data itself.