The Omni Group Forums

The Omni Group Forums (http://forums.omnigroup.com/index.php)
-   OmniFocus Extras (http://forums.omnigroup.com/forumdisplay.php?f=44)
-   -   OmniFocus Statistics (http://forums.omnigroup.com/showthread.php?t=23543)

skylarkelly 2012-02-23 08:51 AM

OmniFocus Statistics
 
Hi All,

Have an idea for a script but no idea how to write it. In a nutshell:

Call me crazy, but I have created a project for every one of the 67 Lominger competencies. This is the foundation for my approach to professional life. As an aside, if anyone else has experimented with this I would love to hear your results.

What I want is a script that would 1) count actions in each project and 2) export those statistics in a format that I could throw into OmniGraphSketcher or Numbers, etc. This way I could quickly and effectively analyze how I am demonstrating each of these competencies.

Any ideas? Does this sound like a dumb thing to do?

Brian 2012-02-23 03:48 PM

I'm not familiar with the Lominger competencies, but if you're willing to learn some Applescript, you could probably dig into the script in [URL="http://forums.omnigroup.com/showthread.php?t=18405"]this thread[/URL] and construct something that did what you're looking for. (For the export format, Tab-delimited text is probably going to be best.)

Brian 2012-02-23 03:54 PM

In other news, Rob T (the author of the script I linked to) is awesome. Meant to include that in the last post, but someone walked into my office and asked a question. :-)

RobTrew 2012-02-23 08:19 PM

[I]If I didn't know that Brian was unfailingly generous and polite, I might suspect a hint of satire here :-)

(But as it is, thank you Brian. That is entirely undeserved and very kind :-)[/I]

Not quite sure whether you are planning to count tasks [I]completed[/I] within a particular span of time, or just the absolute number of leaf tasks (actions rather than action groups) under each heading.

The stats script that Brian points you to uses SQL to query the cache. That approach is certainly fast, but might also give a slightly steeper learning curve at first. If you were going to do it with pure Applescript, the kernel of it might have this kind of shape:

[CODE]tell application id "OFOC"
tell default document
set lstProj to {"summarize", "draft"}
set strReport to ""
repeat with oTerm in lstProj
set strReport to strReport & oTerm & tab & ¬
(count of (flattened tasks where name contains oTerm and it is not root task of its containing project and it is not in inbox and number of tasks = 0)) & ¬
return
end repeat
display dialog strReport
end tell
end tell

set the clipboard to strReport
[/CODE]
[LIST][*][I]lstProj[/I] could contain the list of project names that interest you,[*]and the list of conditions could be lengthened to narrow the count down to tasks completed within a particular period, etc.[/LIST]

skylarkelly 2012-02-29 06:44 AM

Wow, thanks to both of you! I'll give your ideas / scripts a whirl and see what I come up with.

I'm always amazed at how cool these forums are :)


All times are GMT -8. The time now is 11:11 PM.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2024, vBulletin Solutions, Inc.