Hey guys,
So I have this table that shows # of incidents per day over a 30 day period.
I have the Incident Aggregate Function set to 'count' and Rollup Aggregate Function as 'none'
The dates that have incidents are shown but the dates that have nothing that day are suppressed. I've been messing with the aggregate function settings but nothing seems to help since even I turn off Auto Group & Summarize I am not getting the full list of days.
Date|Incident
3/1 | 4
3/2 | 3
3/5 | 2
3/9 | 4
If I remove the Incident column 3/1 - 3/30 show up just fine i'm thinking we're supressing due to nulls. Anyway I can force all values to display? I was trying to put in an else statement (0) but there seems to be a data type conflict
First things first - you want to make sure you don't have an inner join messing your data. I'm not sure where you draw your fields from, but in theory you could be drawing the date field from a date dimension, and the incident field from a fact table, and if they are inner joined then you're going to have to revise your model.
A good way to see it is to look at the SQL the query generates and look for any joins. If you wish, you can post back the SQL and we'll look at it for you.