3 Replies Latest reply on Dec 23, 2016 1:53 AM by Stefan Hanotin

    Tableau calculated fields from 2 dimensions

    Stefan Hanotin

      I have a situation in Tableau where I need to do a calculation, but am stuck as to how best to approach it.

      I have data in a table like this:

      Organisation ID (Measure), Country (Dimension), FY16 Status (Dimension has 3 different values (Low,Medium,High)), FY17 Status (Dimension has 3 different values (Low,Medium,High)).

      Sample of the Data:

      • 12345, France, Low, Medium
      • 12346, France, Medium, Medium
      • 12347, France, High, Medium
      • 12348, France, Low, High

       

      What I need to do is create a table that shows the following columns:

      • Country (rows)
      • Count of Organisations per FY16 Low
      • Count of Organisations per FY17 Low
      • (Count of Orgs per FY17 Low - Count of Orgs per FY16 Low)/Count of Orgs per FY16 Low.
      • Count of Organisations per FY16 Medium
      • Count of Organisations per FY17 Medium
      • (Count of Orgs per FY17 Medium - Count of Orgs per FY16 Medium)/Count of Orgs per FY16 Medium.
      • Count of Organisations per FY16 High
      • Count of Organisations per FY17 High
      • (Count of Orgs per FY17 High - Count of Orgs per FY16 High)/Count of Orgs per FY16 High.

       

      Any help would be greatly appreciated.

      Please find the package workbook attached with a description of what exactly I am trying to achieve also in the Dashboard.

      Thanks,

      Stefan.