Todo totals row: Difference between revisions
(Created page with "|- |[[Todo:Todo {{page}}|{{page}}]] |{{#cargo_query:table=Todo|fields=COUNT(*)|where=Done='No' AND Date >= '{{{from}}}-01-01' AND DATE <= '{{{to}}}-12-31'}} |{{#cargo_query:ta...") |
No edit summary |
||
| (22 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
<includeonly> | |||
|- | |- | ||
|[[Todo: | |{{#ifeq:{{{page}}}|totals|Totals|[[Todo:{{{page}}}|{{{page}}}]]}} | ||
|{{#cargo_query:table=Todo|fields=COUNT(*)|where= | |{{#cargo_query:table=Todo|fields=COUNT(*)|where=Date >= '{{{from}}}-01-01' AND Date <= '{{{to}}}-12-31'}} | ||
|{{#cargo_query:table=Todo|fields=COUNT(*)|where=Done<>' | |{{#cargo_query:table=Todo|fields=COUNT(*)|where=Done=0 AND Date >= '{{{from}}}-01-01' AND Date <= '{{{to}}}-12-31'}} | ||
|{{#cargo_query:table=Todo|fields=COUNT(*)|where=Done=1 AND Date >= '{{{from}}}-01-01' AND Date <= '{{{to}}}-12-31'}}<!-- | |||
--> ({{#expr:{{#cargo_query:table=Todo|fields=COUNT(*)|where=Done=1 AND Date >= '{{{from}}}-01-01' AND Date <= '{{{to}}}-12-31'|default=0|no html}} / {{#replace:{{#cargo_query:table=Todo|fields=COUNT(*)|where=Date >= '{{{from}}}-01-01' AND Date <= '{{{to}}}-12-31'|default=0|no html}}|,|}} * 100 round 0}}%) | |||
</includeonly> | |||