14 Replies Latest reply on Oct 15, 2019 10:50 AM by Ken Flerlage

    Create a countifs function in tableau

    Faith Nguyen

      Hi there,

       

      I'm very new to Tableau. I'm trying to create a calculated field where I need to use countifs function similar to excel. Something like this in excel

       

      COUNTIFS('PBC Contract Inventory'!$I:$I,$A9,'PBC Contract Inventory'!$P:$P,B$7). See below for the grid. However, I'm struggling trying to figure out how I should go about it in Tableau. The grid below is counting using the estimated date (column I:I) and I have another grid using the actual start date (column U:U) but it's not showing here.

      (COUNTIFS('PBC Contract Inventory'!$U:$U,$A9,'PBC Contract Inventory'!$P:$P,K$7)

       

      Anyways, I'm trying to show the estimated contract count and what actually started contract count. Let me know if you can help. Thanks.

       

       

       

      Report
        Date
      NewIn ProgressDevelopmentContract Pending
        Review
      Customer
        Response
      No StatusCompletedTotal
      7/29/201900800008
      8/5/201900500005
      9/9/2019090010010
      9/16/201910217100000273

       

       

       

       

       

      Report
        Date
      NewIn ProgressDevelopmentContract
        Pending Review
      Customer
        Response
      No StatusCompletedTotal
      7/29/2019001120000112
      8/5/201900800008
      9/9/20190110080019
      9/16/201912917400000303