Forum Discussion
show active/inactive reports
I generate logs with all Report which are opened in a month. I have a metadata table of all files currently existing. I want to segregate between active and inactive reports
Activity Logs
DateTime | Folder | Files |
March 1 | Folder 1 | Report 1a |
March 2 | Folder 1 | Report 1b |
March 3 | Folder 2 | Report 2a |
April 1 | Folder 1 | Report 1c |
April 2 | Folder 1 | Report 1a |
April 3 | Folder 3 | Report 3a |
Metadata
Folder | Report |
Folder 1 | Report 1a |
Folder 1 | Report 1b |
Folder 1 | Report 1c |
Folder 1 | Report 1d |
Folder 1 | Report 1e |
Folder 2 | Report 2a |
Folder 2 | Report 2b |
Folder 2 | Report 2c |
Folder 2 | Report 2d |
Folder 2 | Report 2e |
Folder 2 | Report 2f |
Folder 3 | Report 3a |
Folder 3 | Report 3b |
Folder 3 | Report 3c |
Folder 3 | Report 3d |
Folder 3 | Report 3e |
Folder 3 | Report 3f |
This is what i'm trying to achieve in my matrix table if I were to filter for the month of March in the date filter slicer:
Folders | # of reports |
- Active | 3 |
- Folder 1 | 2 |
Report 1a |
|
Report 1b |
|
- Folder 2 | 1 |
Report 2a |
|
-In Active | 14 |
+ Folder 1 | 3 |
+ Folder 2 | 5 |
+ Folder 3 | 6 |
When you expand (+) you can see all reports which are inActive for the month of March
1 Reply
- parry2k
Super User
meerzaheen use show items with no data when you drop columns from metatable tables on the rows of the matrix visual.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
