How to make dashboard show the projects that are tied to my filter for open tasks?

Question

I have a filter to show all my current tasks:

status not in (Done, Closed) ORDER BY status ASC

I want to make a two-column dashboard with those results on the right, and only the projects tied to the task results in the left column.  Right now my dashboard shows ALL projects I have ever done which is not what I want.

Gikku · Accepted Answer

Hi @Ken Jacobs

I am not sure whether I understood the query correctly. You can try creating a two dimensional gadget into the dashboard with the above query with x-axis as Status and y-axis as Project

You can use the condition project in (A,B) if you want to confine the search only for few projects.

Regards
Gikku

Libu B · Accepted Answer

Use something like this , where ABC and XYZ are your project keys

=project in (ABC,XYZ) AND status not in (Done, Closed) ORDER BY status ASC