Mark,

I've been trying to make the example you posted on your blog for making a running word count work, and I've run into a problem.

I've pasted the following text into the Rule area on a new note:
"Rule: Text=sum_if(descendant(/BOOK),1,$WordCount);)

I copied the text directly from your blog, includeing the opening quotation mark.

I have also created a container called "BOOK" and put some notes in it with text.

Could you please provide me with some advice for how to proceed?

Thanks,

~A

Mark,

Thanks for the help. You may want to change rule in the blog posting. (Follow the link in the first post.) Unless I'm missing something the rule posted there is not working.

Have a good one,

~A

Mea culpa, I've rechecked. If I set both the condition and increment parameters to 1 I get a count of matching notes and - as Mark B says - I get a count of all notes in scope regardless of whether they have a WordCount or not. If I set the condition to back to '$'WordCount' and leave the increment as 1 I get a count of only those items with a count >0.

My mistake was not to start my test with the OP's 'bad' code.  Now I see that this Text=sum_if(descendant(/BOOK),1,$WordCount);) rule does work - at least in v4.6.1.  I can only assume the OP's problem lay elsewhere or was an undetected typo (i.e. the rule wasn't exactly as posted).

Marks,

I've tried recopying and pasting your code and I'm now getting a word count.

~A

Was MapBodyTextColor added in v4.6 or v4.6.1?

Also, if one is doing a word count of all notes in group regardless of whether they have any words, it might be easier to just us a non-conditional sum:

$Text=sum(descendant(/BOOK),$WordCount)

instead of

Text=sum_if(descendant(/BOOK),1,$WordCount)

A progress bar is set using the horizontal bar() pattern, or the vertical vbar() pattern. note that in v4.6+ the pattern must be written as a string, i.e. $Pattern="bar(20)" or $Pattern="bar($MyProgress)" not as Pattern=bar(50) as previously.

In the above the 'progress' color is drawn in Color2. The hue of a colour can be controlled via the hue operator.

Here's a stab at the hue issue, you'll need a custom colour attribute and this rule:

$MyColor=rgb(201,102,102);if($MyProgress<33){$Color2=$MyColor};if(($MyProgress>3
3)&($MyProgress<67)){$Color2=hue($MyColor,200)};if($MyProgress>67){$Color2=hue($
MyColor,150)};$Pattern="bar($MyProgress)";

Breaking out the individual terms out a bit onto separate lines we get:

$MyColor=rgb(201,102,102);
if($MyProgress<33){$Color2=$MyColor};
if(($MyProgress>33)&($MyProgress<67)){$Color2=hue($MyColor,200)};
if($MyProgress>67){$Color2=hue($MyColor,150)};
$Pattern="bar($MyProgress)";

So, how does it work? First, we define a colour,$MyColor, that we won't modify further but rather use it as a reference to make hue-shifted colours from that we apply to $Color2 which draws the progress bar. Depending on the value of $ProgressBar, $Color2 is changed  In the above example, below 33% complete the fill colour is red, 33%-67% it is blue and above 67% it is green. Play with the base colour and hue offsets to get different colour combos. Clearly, if you want more variation in colour, you'll need more 'if' clauses.

One thing I do note is that despite setting $Pattern last in the Rule, when I change $MyProgress the bar updates immediately but $Color2 does not - it appears to wait until the next agent/action/rule update cycle. That strikes me as unexpected but it's probably flaky syntax on my part rather than an error in TB's rule resolution.