Forum Discussion
Data Bug when summarizing with nulls
I've got an odd bug I believe. My data looks like this: If I put that into a table with no summarizing, it looks as above. When I put Budget/Forecast as Summarize and hours as don't summar...
I would agree if all values shown were null, but if I have data to display (a non-null row) it should show irregardless of if the sum column is null or not.
Frankly, if that's by purposeful design, it's a poor design. Not showing data is very confusing for the user (it took me a while of troubleshooting to figure out why I wasn't seeing those records as expected), and potentially dangerous from a BI perspective (missing data can lead to thinking there is no data and bad decisions).
Hi Anonymous,
You could enable the "Show items with no data" option for those unsummarized fields.
Best regards,
Yuliana Gu