8 Replies Latest reply on Nov 10, 2016 3:50 AM by Joe Smith

    how to create correlation scatter plot for the two items of a dimension variable?

    Joe Smith

      Suppose I have the following data, may I ask how to create a scatter plot with x axis being temperature when window is open and y axis being the temperature when the window is closed?

      Image 1.png

       

      I tried to create two calculated filed using the window_open variable as the condition, but I'm not able to get the scatter plot correctly.

      Image 2.png

       

      The excel file is attached, and the tableau public link is:

      https://public.tableau.com/views/test_scatter_plot/Sheet1?:embed=y&:display_count=yes

       

      Appreciate your advice!