Forum Discussion
Sorting items by open/closed with year slicer
Hi all - I have a dataset of audits, which includes informaton about when an audit was released, and when it's last sub-component was implemented (or when it will be in the future). Each audit is l...
ray_codex
Resolver II
Resolver IICan you show a data sample and the columns that mark an open and/or closed audit?
ray_codex yes of course. the data itself is confidential but I've included a table of 4 made-up audits with items and sub-items. You can see every audit has items, which itself has subitems. The sub-items have timelines, and you can see some sub-items have been implemented already, and some have not (NAs). The 6th column replaces the NA data with the future due date that the sub-item will be implemented (aka closed). Then the final 2 columns show the date the the associated finding or audit is/will be closed (i.e. the date of its last sub-item).
| Audit Name | Item Title | Audit Release Date | Sub-Item Title | Sub-item Implementation Date | Sub-item Implementation or Due Date | Item Last Sub-item Date | Audit Last sub-item Date |
| Audit 1 | Item 1.1 | 10/1/2020 | Sub-item 1.1.1 | 3/20/2021 | 3/20/2021 | 3/20/2021 | 2/10/2022 |
| Audit 1 | Item 1.1 | 10/1/2020 | Sub-Item 1.1.2 | 12/31/2020 | 12/31/2020 | 3/20/2021 | 2/10/2022 |
| Audit 1 | Item 1.2 | 10/1/2020 | Sub-item 1.2.1 | 1/3/2022 | 1/3/2022 | 1/3/2022 | 2/10/2022 |
| Audit 1 | Item 1.2 | 10/1/2020 | Sub-item 1.2.2 | 1/3/2022 | 1/3/2022 | 1/3/2022 | 2/10/2022 |
| Audit 1 | Item 1.3 | 10/1/2020 | Sub-item 1.3.1 | 2/10/2022 | 2/10/2022 | 2/10/2022 | 2/10/2022 |
| Audit 2 | Item 2.1 | 2/1/2021 | Sub-item 2.1.1 | 10/8/2021 | 10/8/2021 | 10/8/2021 | 11/2/2023 |
| Audit 2 | Item 2.2 | 2/1/2021 | Sub-item 2.2.1 | 10/9/2021 | 10/9/2021 | 10/9/2021 | 11/2/2023 |
| Audit 2 | Item 2.3 | 2/1/2021 | Sub-item 2.3.1 | 12/24/2022 | 12/24/2022 | 12/24/2022 | 11/2/2023 |
| Audit 2 | Item 2.4 | 2/1/2021 | Sub-item 2.4.1 | 12/31/2022 | 12/31/2022 | 12/31/2022 | 11/2/2023 |
| Audit 2 | Item 2.4 | 2/1/2021 | Sub-item 2.4.2 | 5/10/2021 | 5/10/2021 | 12/31/2022 | 11/2/2023 |
| Audit 2 | Item 2.4 | 2/1/2021 | Sub-item 2.4.3 | 5/10/2021 | 5/10/2021 | 12/31/2022 | 11/2/2023 |
| Audit 2 | Item 2.5 | 2/1/2021 | Sub-item 2.5.1 | 11/2/2023 | 11/2/2023 | 11/2/2023 | 11/2/2023 |
| Audit 3 | Item 3.1 | 4/1/2022 | Sub-item 3.1.1 | 12/31/2022 | 12/31/2022 | 8/10/2023 | 5/1/2024 |
| Audit 3 | Item 3.1 | 4/1/2022 | Sub-item 3.1.2 | 1/1/2023 | 1/1/2023 | 8/10/2023 | 5/1/2024 |
| Audit 3 | Item 3.1 | 4/1/2022 | Sub-item 3.1.3 | 8/10/2023 | 8/10/2023 | 8/10/2023 | 5/1/2024 |
| Audit 3 | Item 3.2 | 4/1/2022 | Sub-item 3.2.1 | NA | 4/1/2024 | 4/1/2024 | 5/1/2024 |
| Audit 3 | Item 3.2 | 4/1/2022 | Sub-item 3.2.2 | 12/4/2023 | 12/4/2023 | 4/1/2024 | 5/1/2024 |
| Audit 3 | Item 3.3 | 4/1/2022 | Sub-item 3.3.1 | NA | 4/1/2024 | 5/1/2024 | 5/1/2024 |
| Audit 3 | Item 3.3 | 4/1/2022 | Sub-item 3.3.2 | NA | 5/1/2024 | 5/1/2024 | 5/1/2024 |
| Audit 3 | Item 3.3 | 4/1/2022 | Sub-item 3.3.3 | 11/5/2023 | 11/5/2023 | 5/1/2024 | 5/1/2024 |
| Audit 4 | Item 4.1 | 7/1/2023 | Sub-item 4.1.1 | NA | 12/31/2023 | 2/1/2024 | 2/1/2024 |
| Audit 4 | Item 4.1 | 7/1/2023 | Sub-item 4.1.2 | NA | 1/12/2024 | 2/1/2024 | 2/1/2024 |
| Audit 4 | Item 4.1 | 7/1/2023 | Sub-item 4.1.3 | NA | 2/1/2024 | 2/1/2024 | 2/1/2024 |