Hi Nathan,

I am pretty sure the let filter operator from Tobias [1] will help you out there. There are even some examples for calclulating averages [2].

/Andreas

[1] http://let.tiddlyspot.com
[2] http://let.tiddlyspot.com/#AVG


Am 06.03.2015 um 18:29 schrieb nathan.mcel...@gmail.com:
I've read over several posts regarding using some javascript macros to manipulate fields as numerical values, but I haven't found an answer to whether or not the following is possible:

I'm working on a wiki to publicly display results of water sample analyses for a project. I create a tiddler for each sample, and each tiddler has a number of custom fields (i.e., site ID, pH, total dissolved solids, ppm chloride, etc.). Now, I've figured out a way to create tables that brings in data from all tiddlers of a specific tag (e.g., site ID, sample date, chemical parameter) and each time I add a new sample, the table tiddlers automatically add that information.

Example of table:
 ''Summary of Field Data for Gaut Pad Site G-01 to Date''

<table>
@@.center
<tr><th>Year</th><th>Qtr</th><th>Date</th><th>Collector(s)</th><th>Time</th><th>pH</th><th>TDS (ppm)</th><th>Cond. (&mu;S)</th><th>Temp. &deg;C</th><th align="left">Comments</th></tr>
*<$list filter="[tag[Gaut]tag[G01]!tag[summary]sort[02a-yr]sort[03-qt]]">*
<tr><td>{{!!02a-yr}}</td><td>{{!!03-qt}}</td><td>{{!!02-yr}}/{{!!04a-mmdd}}</td><td>{{!!06-who}}</td><td>{{!!05-hr}}</td><td>_*{{!!08-ph}}*_</td><td>{{!!09-ftds}}</td><td>{{!!10-con}}</td><td>{{!!11-tem}}</td><td align="left">{{!!07-note}}</td></tr>
</$list>
would like to then add a row where averages of each column could be displayed (e.g., from each {{!!08-pH}} value from /n/ tiddlers tagged G01)
@@
</table>

What I want to find out here is ... during the $list call that populates my table, is there a way (using Tiddly or javascript macro) to set up a variable that will store information of a particular field and do something with it.

Specifically, for a table that contains pH values, etc. for a host of sample sites, is there a way as the list is sorted, to grab each pH value and when the list is over, take those values and create an average value that I can display at the bottom of the table?

I'm slowly learning JavaScript but have done lots of Python programming ... I just don't know if it's possible to do this, and if so, how do I grab/store individual values from the $list? to manipulate them after </$list>

Thanks for reading.
Nate McElroy
--
You received this message because you are subscribed to the Google Groups "TiddlyWiki" group. To unsubscribe from this group and stop receiving emails from it, send an email to tiddlywiki+unsubscr...@googlegroups.com <mailto:tiddlywiki+unsubscr...@googlegroups.com>. To post to this group, send email to tiddlywiki@googlegroups.com <mailto:tiddlywiki@googlegroups.com>.
Visit this group at http://groups.google.com/group/tiddlywiki.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups 
"TiddlyWiki" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to tiddlywiki+unsubscr...@googlegroups.com.
To post to this group, send email to tiddlywiki@googlegroups.com.
Visit this group at http://groups.google.com/group/tiddlywiki.
For more options, visit https://groups.google.com/d/optout.

Reply via email to