Add date range to pie charts on a dash board

Hi,
Currently I have a dash board that displays pie charts for pass, fail, and pending categories within different projects. Right now it includes all the data within the sheet. I'm wondering if I can add some sort of option to specify the dates included in the chart. For example, show me pass, fail, pending for 2018 or from 08/01/18-Present? Thank you
Β
Comments
-
Hello Christina,
We currently donβt have the functionality to specify a date range from the chart widget. When you have a moment, please submit a Product Enhancement Request (youβll find a link to this here in Community under Quick links on the right).
A work-around to this would be to create a formula that counts the number of items for each category that fall within a specified date range. For example, the formula below will count the number of tasks with the status βPassβ that have a date greater than or equal toΒ 8/1/18 and less than or equal to today:
Β =COUNTIFS(Status:Status, "Pass", Date:Date, >=DATE(2018, 8, 1), Date:Date, <=TODAY())
To count the number of failed or pending, copy the formula into another cell and change the βPassβ to βFailedβ (repeat this step for βPendingβ tasks).
If you would rather display this data in a grid, I would recommend creating a report to filter tasks that fall within the specified date range and using the report widget to display the tasks on a dashboard.
I hope this helps!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 205 Use Cases
- 516 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 82 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives