1 Reply Latest reply on Nov 29, 2016 10:04 AM by Matthew Risley

    Need help in customized graph(Meteor in solar system)

    Maheshh C K

      Dear Team,

      I was trying to create a tableau customized graph (Meteors in the solar system). I would require your help on the same as I am new for customized graphs in tableau. Attaching the .twbx for the same.

       

      Input:

      College

      Department

      Revenue

      Speed

      College1

      Department1

      Very High

      Very High

      College1

      Department2

      High

      High

      College1

      Department3

      Medium

      Medium

      College1

      Department4

      Low

      Low

      College1

      Department5

      Very Low

      Low

      College1

      Department6

      Very Low

      Very Low

      College2

      Department1

      Very High

      Very High

      College2

      Department2

      High

      High

      College2

      Department3

      Medium

      Medium

      College2

      Department4

      Low

      Low

      College2

      Department5

      Very Low

      Low

      College2

      Department6

      Very Low

      Very Low

      College2

      Department7

      Very Low

      Very High

       

      Expected Output When college 1 is selected over the filter:

       

      Functionality:

      1. 1) The size of the Department is based on the revenue the department is generating.
      2. 2) The distance between the college & the department is determined by the speed at which the revenue is generated.

      Note:

      • We may have qualitative numbers in the place of very high, high, but the size should be different based on the numbers.
      • The chart should automatically change when the input is changed.

      Kindly help me on the same.

      Thanks

      Maheshh

        • 1. Re: Need help in customized graph(Meteor in solar system)
          Matthew Risley

          My first instinct is to use custom shapes. Add the meteor to your custom shapes folder to replace mine.

           

          Then create the axis using numbers (as you eluded to). In order to get stacked meteors like on your picture you will probably need to make a Y axis of some sort.

           

          The size and distance is based on what you had posted in your question.

           

          Attached is a workbook with the basic idea. You will have to play with the numbers and axis' though.

           

          Hope this helps!