Forum Discussion
AndyTrezise
Advocate IV
8 years agoHow to include rows with a 'zero count' in a grouped table
Hi All I have a table which hold resource utilisation for employees on a per year/month basis: EMP1, 2017, 1, 75% EMP2, 2017, 1, 83% EMP3, 2017, 1, 44% EMP1, 2017, 2, 66% EMP2, 2017, 2, 9...
- Anonymous8 years ago
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.
Greg_Deckler
Community Champion
8 years agoSomething to try, perhaps try to convert your numeric value to text using a CONCATENATE function with a "" or " ".