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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives