0 Replies Latest reply on Nov 20, 2013 1:04 PM by Ricardo Davila

    Count the number of gaps in data

    Ricardo Davila

      Greetings, all,

       

        I'm working with data as reported by microfinance institutions (MFIs) to MIX Market.  In many cases, the data is inconsistent.  For example, an MFI may report the number of borrowers on its loan books from 1998 through 2008, then not report in 2009 and 2010, and resume reporting in 2011.  The problem is further complicated because each of these institutions started reporting at different years.  For example, one MFI may start reporting in 2001, another in 1998, yet another in 2005.  A screenshot to illustrate the problem is below:

       

      graph screenshot.png

       

        So, for example, AccessBank - TZA consistently reported from 1998 through 2009, lapsed in 2010, and reported again in 2011.  Ergo, the number of gaps would be one.  Is there a way to calculate this within Tableau?

       

      Thanks,

      -Ricardo-