0 Replies Latest reply on Oct 2, 2018 10:26 AM by Jeffrey James

    Quick YoY Table Calc Omitting Certain Available Periods

    Jeffrey James

      I'm trying to determine why the quick tableau calculation for YoY growth is not working correctly.

       

      The dates are discrete and while some periods are correctly returning the data, Some periods omit the data entirely, though there are comp periods available. Per the screenshot below:

       

      - why isn't there a % diff value returned for Q4 2017, since I have data for the prior year's period?

       

      Screen Shot 2018-10-02 at 11.23.26 AM.png

       

      The complete twbx file is attached.