And oh yeah the value() at the beginning is unnecessary. On Monday, July 27, 2020 at 7:51:36 AM UTC-7 [email protected] wrote:
> I've reached a somewhat clunky solution, although I'm not sure why it > works: > > \define bad() > (= value([tag[Food Log]tag[July]tag[bad]count[]]) =) > \end > > <$wikify name=badNum text=<<bad>>> > (= value(<<badNum>>) * 2 =) > </$wikify> > > > Emily > On Monday, July 27, 2020 at 7:40:30 AM UTC-7 [email protected] wrote: > >> Hi Evan, >> >> I've just discovered Formulas and I'm enjoying its straightforward >> crunching. Thank you so much for making this awesome plugin! I'd like to >> make a tiddler that shows the overall "feeling score" of a food logging >> database by counting the number of results for each mood (bad, decent, >> good). Then, I'd find the average of their weighted values: (bad * -1 + >> decent * 1 + good * 2) / totalEntries. >> >> I'm stuck on converting the number of results for the filter into a >> number. >> >> \define bad() >> (= value([tag[Food Log]tag[July]tag[bad]count[]]) =) >> \end >> >> (= <<bad>> * 2 =) >> >> returns: >> >> ComputeError: Cannot convert "2" to number! >> >> Yet (= value("2") * 2 =) returns 4 as expected. I suspected that the >> mushrooms (?) may have been redundant when defining <<bad>>, but removing >> them lead to another error. >> >> Thanks, >> >> Emily >> >> >> On Tuesday, January 16, 2018 at 11:15:24 PM UTC-8 [email protected] >> wrote: >> >>> Announcing the second generation of my formula plugin for TiddlyWiki. >>> >>> See the *Formula wiki* for the latest documentation: >>> http://evanbalster.com/tiddlywiki/formulas.html >>> >>> *Report issues and view source GitHub*: >>> https://github.com/EvanBalster/TiddlyWikiFormula >>> >>> >>> Formula lets you do computation in TiddlyWiki in the style of popular >>> spreadsheet apps Excel and Google Sheets, with the addition of TiddlyWiki's >>> own filter, transclude and variable systems. Tiddlers can behave like >>> individual rows in a spreadsheet. A large collection of built-in functions >>> is included, for use with text, numbers, dates, arrays and regular >>> expressions. >>> >>> Formula is implemented as a widget, with a special *(=* "mushroom >>> bracket" *=)* syntax for inclusion in WikiText, and can also be used in >>> widget/HTML attributes. Formulas included via transclusion, filters and >>> variables are computed and refreshed like any other part of your wiki. >>> >>> (= ( sum([tag[Profits]get[value]]) - sum(tag[Expenses]get[value]]) ) * >>> {{Tax!!rate}} =) >>> >>> The second generation of formula adds support for local variables, >>> comments, lambda functions and element-wise operations on arrays (such as >>> filter results), allowing more advanced computations to be expressed inside >>> TiddlyWiki. Search the wiki for "demo" to see some of the things I've >>> built. >>> >>> >>> The plugin is a work in progress and may have bugs. Please report these >>> on GitHub or in this thread. >>> >> -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/aa5ded60-a1e6-4b29-82fd-efa99a999779n%40googlegroups.com.
