I would like a solution to substitute "no value" in a series. Example: You did some Google campaigns (CPC) in FEB-MARCH, but not in JAN & APR . Google API's from Analytics will show you all sources (Direct, referrering sites, Organic searc, paid search,...) ...but will not show a CPC source for JAN & APR...which wil screw up your bar charts. The workaround is complex (create a new source table with if/then to substitiute empty values with zero's)
Tamara De Heij commented
I also encountered this problem. The following article helped me. It's a solution without a new data source.
Having said this, I am still giving this idea a vote, because I think this solution is still complex. I think it will be a great improvement if there would be easier, more intuitive ways with less syntax for LOOKUP functionalities.
PerformLine Inc commented
I can confirm that this problem does occur - for one of my more important klips, blank values are not treated as zeroes, which messes up a lot of bar charts.