Forum Discussion
Showing countrows with zero rows for a selected date range
Hello, I have a table called Date_Table_Action which has a 1->* relationship to table BBP_Actions on the date. I need to display a table that has all the continous dates between the min date on ...
Can you please post some sample data ?
SachinNandanwar I don't think I can attach anything unfortunately. For the Date_Table_Actions it would be a simple date table:
For the BBP_Actions table, here is some sample data from the table. Relationship is 1 --> * from Date_Table_Action[Date] to BBP_Actions[ActionCompleteTargetDate]
| Id | Status | ActionCompleteTargetDate |
| 67 | Validated | 12-Sep-24 |
| 68 | New | 18-Sep-24 |
| 69 | Study Ongoing | 26-Sep-24 |
| 70 | New | 12-Sep-24 |
| 71 | New | 19-Sep-24 |
| 72 | New | 12-Sep-24 |
| 77 | Completed | 17-Sep-24 |
| 78 | New | 17-Oct-24 |
| 79 | New | 26-Sep-24 |
| 80 | New | 25-Sep-24 |
| 81 | New | 26-Sep-24 |
| 82 | New | 24-Sep-24 |
| 83 | New | 26-Sep-24 |
| 84 | New | 26-Sep-24 |
| 85 | New | 26-Sep-24 |
| 86 | New | 30-Sep-24 |
| 87 | New | 30-Sep-24 |
| 88 | New | 01-Oct-24 |
| 89 | New | 01-Oct-24 |
| 90 | New | 10-Oct-24 |
| 91 | New | 17-Oct-24 |
| 92 | New | 17-Oct-24 |
| 93 | New | |
| 94 | New | 30-Oct-24 |
| 98 | New | |
| 99 | New | |
| 100 | New | |
| 101 | New | |
| 102 | New |
Thanks!