Forum Discussion
How to include rows with a 'zero count' in a grouped table
Hmmm interesting, I think one of the solutions is in adapting your data model.
If you create a new table that contains only a column with the Range descriptions like "Range0" , "Range1" etc, then create a connection between your data table and that table, matching on that range description. Finally, instead of using the data table's "range" dimension, you use the one from your new table. In that case, when you check "show items with no data" like below, it will show the empty rows as well.
Not sure if this is the cleverest solution, but it will work.
Hmmm interesting, I think one of the solutions is in adapting your data model.
If you create a new table that contains only a column with the Range descriptions like "Range0" , "Range1" etc, then create a connection between your data table and that table, matching on that range description. Finally, instead of using the data table's "range" dimension, you use the one from your new table. In that case, when you check "show items with no data" like below, it will show the empty rows as well.
Not sure if this is the cleverest solution, but it will work.
Simple solution but it works - thank you!!!