2 Replies Latest reply on Nov 2, 2018 11:26 AM by Jenna Dulchinos

    Grouping Dimensions

    Jenna Dulchinos

      Hello

       

      In my database, we are trying to capture what systems are impacted by projects, the way we are capturing it is there are 12 systems and there is a column for each one. if a project impacts the system, a Y goes into the cell, otherwise it is left blank.

       

      We want to be able to report on the usage of systems. when in tableau, is there a way to have a dimension called systems that would keep all the systems as dimensions, but inside the group would list each system and then keep track of the Y count for each one? So I want to be able to basically create a graph, like a pie chart where it breaks it down by how many projects are assigned to a system currently.

       

      I attached a sample data sheet. Any thoughts?

       

      Thanks.