Add smart filters and smart columns to your interactive Jira dashboard

Smart Filters are the last type of filter you can define in Rich Filters. By the end of this tutorial, you can add drop-down buttons that allow you to filter by criteria you have defined. You'll also be able to display in the Rich Filter Results gadget (colored) computed columns (we call these smart columns) based on the same criteria.

How to add smart filters and smart columns

For this tutorial, you must have already created a Rich Filter and a dashboard with a Controller and Rich Filter Results gadget (with a couple of views) based on the Rich Filter. We have used the Rich Filter and dashboard from the previous tutorial.

  1. Open the configuration page of your rich filter.

  2. Once you are on the rich filter configuration page, click on the Smart Filters link on the left of your screen.

  3. Add a new smart filter. Name it Warnings and check only Labels tag types (more about this in a second).

  4. Add the three clauses below:

    1. Label: High Priority, JQL: priority in (1,2) and status = Open

    2. Label: Past Due Date, JQL: duedate < now() and status != Closed

    3. Label: No Due Date, JQL: duedate = empty and status not in (Resolved, Closed)

  5. Open/refresh the dashboard you already have, which is based on your rich filter. You'll notice a new drop-down filter in the Controller containing the three options you have configured. Clicking any option will trigger the other gadgets based on the same rich filter in the dashboard to apply the JQL you have configured for each option.

  6. Go back to the Smart Filters section of your rich filter configuration page. Edit the Warnings smart filter.

  7. Add the Color tag type.

  8. For each clause of the Warnings smart filter add a color like in the picture below.

  9. Go to the Views section of the rich filter.

  10. In the Requester view, you'll notice that it is now possible to use the smart filter as a computed column (we call this a Smart Column). Add the Warnings smart column to your view.

  11. Once added, edit the Warning smart column. 

  12. Make sure you select Show tags as - Colored Labels and Column Heading - Smart Filter Name.

  13. Open/refresh the dashboard you already have, which is based on your rich filter. You'll notice that the Requester view of the Rich Filter Results gadget now displays a new column called Warnings, just as you have configured it.

  14. Go back to the Smart Filters section of your rich filter configuration page. Create a new smart filter called Risk which has only the tag type Colors.

  15. Add the JQL: priority in (1,2) and assignee is EMPTY


    Make sure you click on the Add button. 

  16. Go to the Views section of your rich filter. In the Delivery view, add the smart column Risk that you have just created.

  17. Drag & drop the Risk smart column after the Priority column. 

  18. Edit the Risk Smart column

  19. Please make sure you select Column Heading—None (we want this column to be as compact as possible). 

  20. Open/refresh the dashboard you already have which is based on your Rich Filter. You'll notice that in the Delivery view of the Rich Filter Results gadget, next to the Priority field, unassigned issues with Priority 1 or 2 are highlighted.  

Smart filters are a very powerful mechanism that allows you to create complex filtering groups, add computed columns to your views, and highlight issues using color coding.

See also

Add Rich Filter Statistics gadgets to your interactive Jira Dashboard

Configuring Smart Filters

Â