1 of 1 people found this helpful
Does the missing data have a null value or just doesn't exist? In other words, do you have:
North Q1 2011 6.5
West Q1 2011
West Q2 2011 6.6
or does that second line not exist?
If the latter you could use a filter:
with the partitioning set to Date, and then the filter set to true. If you have multiple years, you will need to bring that in as well
Thanks for the quick reply, Alex.
The data does not exist, so it looks like I can use the option you've described.
To confirm my understanding, your filter is looking at the size of the rows in each dataset, and would only return a value if there are four rows, or four values. This means that the filter could be modified so that if data is stored at a monthly level, the filter would be size()=12. And at a daily level, size()=365 or 366. Is this correct?
Also, this is my first time using the "size" function, so could you clarify what it means to have the partitioning set to "Date"?
Correct, but we would need to reset it for each year as well if there are multiple years.
Basically, we are saying if we have region and date, look at the number of dates in each region
Got it. This does the trick, Alex.
Thank you so much for your help.