1 of 1 people found this helpful
see the attached - there are a couple possible solutions (i'm sure there are more)
the first is to just fill the blanks with 0
its 2 parts
the formula is ifnull(lookup(sum([Impressions]),0),0)
then the date range has been filled in by opening the green pill and selection "Show Missing Values"
It returns the top line on the chart below
You can also soften the data by playing with fill in data - see the exapmple
and it returns the bottom chart
I'm sure there are others if I had a better idea of your expectations
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.