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

[Ken Jacobs]

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 solution]

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

[Ken Jacobs]

That is cool! I am not sure how to do the condition though.

[Libu B · Accepted solution]

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

[Ken Jacobs]

Thank you!