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!
