0

Zero/empty Values

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)

4 comments

  • 0
    Avatar
    PerformLine Inc
    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.
  • 0
    Avatar
    Tamara de Heij
    I also encountered this problem. The following article helped me. It's a solution without a new data source. https://klipfolio.uservoice.com/knowledgebase/articles/283799-common-bar-line-chart-scenarios-counting-yes-and- 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.
  • 0
    Avatar
    T V

    The url above can no longer be accessed - I am redirected back to support.klipfolio.com?

     

  • 0
    Avatar
    Trish Mermuys

    Hi Trudy,

    It looks like that article has been replaced by this article:  Using LOOKUP to align data

    You may also find this article useful, especially if you're using the 'Group' action on the x-axis:  Using IF to align data

     

Please sign in to leave a comment.