2 Replies Latest reply on Mar 2, 2017 9:03 PM by Christina Gremore

    Measuring Record Count Difference Between Time Periods

    Call Given

      Hello,

       

      I'm looking for a way to measure the change in record count between two time periods. My data is structured like this:

       

      MonthIDType
      January1A
      January2A
      January3A
      January4B
      January5B
      January6C
      January7C
      February8A
      February9B
      February10B
      February11B
      February12B
      February13C
      February14C
      February15C
      February16C

       

      I need an output that looks like this (measuring record count):

          

      TypeJanuaryFebruaryVariance
      A312
      B24-2
      C24-2

       

      I'd like to use this in Tableau so that I can include it with other data I have in the tool. Is this possible in Tableau? Is Tableau even a good tool to perform this kind of data manipluation/aggregation?

       

      Thank you.