I am unable to use filtered data in a dashboard
I created a sheet from JIRA and I set a filter to show only open tickets but every time I select the data the sheet is showing "Non filtered data". Thanks.
Best Answer
-
Sorry, I missed the part in your screenshot where you were trying to add it to a graph on a dashboard. If you point a graph from a dashboard directly to your sheet, it's going to look at it unfiltered. Instead what you want to do is create a report from your sheet that is filtered to not show Closed or Withdrawn. Then create your graph on dashboard from the report instead of the sheet.
Answers
-
Try creating the filter with a condition "is one of" and select all of the Status that aren't Closed or Withdrawn.
-
@Matt C. I created a new filter using your recommendation but still showing all items of the status. When I try to add the filtered data to the dashboard still showing "Closed" and "Withdrawn".
-
Sorry, I missed the part in your screenshot where you were trying to add it to a graph on a dashboard. If you point a graph from a dashboard directly to your sheet, it's going to look at it unfiltered. Instead what you want to do is create a report from your sheet that is filtered to not show Closed or Withdrawn. Then create your graph on dashboard from the report instead of the sheet.
-
@Matt C. I create a Report using the smartsheet and it works! Thanks
