3 Replies Latest reply on Jun 2, 2016 2:25 PM by Dan Santon

    Need help creating Calculated field combining COUNT()s from two data sources

    Dan Santon

      I'm trying to remake the pdf of the Excel pivot chart for a use case justification for deploying Tableau.

      I can get it close, but I'm finding it hard to combine two measures into one to be able to show in a 100% bar chart. One measure is COUNT() instances of strings: REQ and STOCK, the other is a COUNT() of a unique identifier in a query of transaction data. REQ/STOCK transactions aren't stored in the transaction data so I need to add it to the total. Afterwards, I want to show the percentage of REQ and STOCK transactions of the total.

       

      I'm totally brand new to Tableau, so assume I only know the basics, please.


      Thanks for your help!