HI,
i am trying to sort some tiddlers in a table by a calculated value , i learned from a previous post that i should use subfilter when sorting using values that has a filter, which in this case a kin filter is part of the calculation , so i did that but still cant sort the table properly
can someone please help me https://mighty-soap-71.tiddlyhost.com/
<table>
<tr><th>title</th><th>due date</th><th>status</th></tr>
<$list filter="[tidtype[task]status[In House]!tag[test]]:sort[subfilter<date3>]">
<$set name=accumelateduedate filter="[kin:tags:to<currentTiddler>!tag[Completed]has:field[tidtype]] :reduce[get[endd2]add<accumulator>]">
<$let
date1={{{ [{!!endd}parsedate[unixtime]] }}}
date2 = {{{[<date1>add<accumelateduedate>]}}}
date3={{{[<date2>unixtime[YYYY-0MM-0DD]]}}}
>
<tr><td>
<$view field="title" />
</td><td><$text text={{{ [all[current]subfilter<date3>] }}}/></td><td><$view field=status/></td></tr>