1 Reply Latest reply on Sep 20, 2018 9:29 PM by meenu choudhary

    How to graph different relative calculated measures based on measure values?

    CHAMPAK BHOOMIYA

      Newbie here - so please forgive if this is a very simple task in tableau

       

      Below is an example of how the data looks -

      Test Case #Device 1 ResultDevice 2 Result
      TC_15060
      TC_2105

       

      Here's the question - I want to generate relative performance of Device 1 vs Device 2 across the two test cases, with the caveat as below -

      TC_1 Relative Gain = Device 1 Result / Device 2 Result

      TC_2 Relative Gain = Device 2 Result / Device 1 Result

       

      Is there a way to achieve these graphs on separate sheets without generating an additional calculated field? The reason I ask is that I have a bunch of test cases and need to plot the relative gains differently for each test cases and if I were to generate a calculated field for each test case, that would result in a lot of measures and am trying to avoid that. Hoping that someone can suggest an easy way to do this.

       

      Thanks

      Champak