Subject: Re: Making Sense of the Data

From: dewluca <[email-masked]>
Date: Thu, 19 Mar 2015 07:08:26 -0700 (PDT)

I should add that I use MANY apps and had MANY pools that I was trying to 
track . . . this meant the data had many duplicate lines representing the 
same time frame (as I mentioned in my original post).  

On Thursday, March 19, 2015 at 9:05:03 AM UTC-5, dewluca wrote:
>
> I gave up using the app . . . it was more trouble than it was worth to 
> make the exported data useful.
> I'm sure some people find the onscreen info helpful, but I wanted actual 
> useable exported data that didn't require massive transformation . . . and 
> I couldn't get that.
>
>
> On Thursday, March 19, 2015 at 8:28:51 AM UTC-5, Julian Quattlebaum wrote:
>>
>> Why can't you sort by app and show subtotals for each group with the same 
>> app entry?  Am I missing something?
>>
>> On Friday, March 7, 2014 at 7:22:12 AM UTC-8, dewluca wrote:
>>>
>>> I've spent far more time than I would like over the past couple of days 
>>> trying to make sense of the exported activity reports.
>>> I can import them into excel and apply the time conversion equation to 
>>> see the time in foreground and total time for each line in the file.
>>> My problem is that I've tried many different settings, etc. but still 
>>> end up with far too many duplicate lines.
>>>
>>> The main data I want/need is the total amount of time each app or pool 
>>> was in the *foreground*.  (Which I can see on the activity report 
>>> screen, but not in the exported data.)  I'm tempted to just give up on the 
>>> reports and type the information from the screen into an excel file at the 
>>> end of each day . . . but that seems stupid.  Am I missing something about 
>>> how to get this information?
>>>
>>> I would like to be able to have total time on certain types of projects, 
>>> but both the standard listing and the pools feature are sending so many 
>>> lines to the file (and in a format that does not seem sortable) as to be 
>>> rather worthless.
>>>
>>> Has anyone developed strategies for converting the data to useable 
>>> information?
>>> How are other people using the information in the reports?
>>> What settings are you using?
>>>
>>> Thanks for any help you can provide.
>>>
>>>
>>>

---

From: dewluca <[email-masked]>
Date: Thu, 19 Mar 2015 07:05:03 -0700 (PDT)

I gave up using the app . . . it was more trouble than it was worth to make 
the exported data useful.
I'm sure some people find the onscreen info helpful, but I wanted actual 
useable exported data that didn't require massive transformation . . . and 
I couldn't get that.

On Thursday, March 19, 2015 at 8:28:51 AM UTC-5, Julian Quattlebaum wrote:
>> My problem is that I've tried many different settings, etc. but still end 
>> up with far too many duplicate lines.
>>

---

From: Julian Quattlebaum <[email-masked]>
Date: Wed, 18 Mar 2015 19:41:08 -0700 (PDT)

On Friday, March 7, 2014 at 7:22:12 AM UTC-8, dewluca wrote:
> I can import them into excel and apply the time conversion equation to see 
> the time in foreground and total time for each line in the file.
> The main data I want/need is the total amount of time each app or pool was 
> in the *foreground*.  (Which I can see on the activity report screen, but 
> not in the exported data.)  I'm tempted to just give up on the reports and 
> type the information from the screen into an excel file at the end of each 
> day . . . but that seems stupid.  Am I missing something about how to get 
> this information?
>

---

From: Dan <[email-masked]>
Date: Mon, 6 Oct 2014 20:28:04 -0700 (PDT)

I am calculating the difference between end time and start time = duration. 
After this you can sum the duration (per app, per pool, etc), aggregate by 
app for example and then sort by the duration

---

From: dewluca <[email-masked]>
Date: Fri, 7 Mar 2014 07:22:12 -0800 (PST)