You must be logged in to post a comment. Please update me on this too. Support the Community and master Tableau. We need to come up with a way to calculate what the floor value should be for the x-axis and the y-axis. Hi Sachin, The axis range are the default range that comes up when you plot the scatter plot between Discount and Sales. Figure out what the maximum value is and subtract the average line value, then, starting from the average line, subtract the difference we just computed. Applying the same approach to the y-axis we see that the maximum value is around 34 and the average is around 11 yielding a difference of 23 34 What happens if instead of the values spreading out in the upper right we get values that spread out in the bottom left?

Bring Customer name to Detail. If the first three colours you use are different to the default colour you only need to do this three times. This time I am going to run through how to colour the different quadrants of a scatter plot or graph. February 23, at 3: Hi All, In this blog of Advanced charting series we will take a look into how to build a quadrant chart in tableau. The download contained many tables, but we were working with Table 3a.

## Tableau Scatter Plot – how to colour the different quadrants

To create a Scatter plot lets bring Discount in columns and Sales in Rows used sample superstore data. May be something like this? Figure 2 — Scatterplot comparing sales with quantity where each dot represents a customer.

Earlier this week Gartner, Inc. Technical Blog — Tableau scatter…. Learn how your comment data is processed.

Next Communities of practice — A review of gableau one. The pseudocode for this is:. We need to come up with a way to dynamically adjust the axes and we can in fact do this by adding hidden reference lines that are driven by level-of-detail calculations.

Now the title needs to be updated.

This will take you the graph plotting part of the software. Hope I am clear on this. A scatter plot is a chart type in which two continuous variables are represented on two different axes. This time I am going to run through how to colour the different quadrants of a scatter plot or graph.

## Advanced Charting : Quadrant Charts

We are guessing that quadrajts answer lies in LoD somehow, but have not yet connected the dots on how to apply.

We’ll assume you’re ok with this, but you can opt-out if you wish. Figure 9 — Auto-adjusting balanced quadrant chart with visible reference lines and zero lines. Please update me on this too. This is justa Raw example. Tableau I have already covered Tableau in another post. They would like scater replicate this chart, and then do a little what-if to help planning for next cycle.

Consider Figure 2 below where we compare the sum of Sales on the x-axis with the sum of Quantity on the Y-Axis. Tableak said, if the values become more skewed it will become harder to see how the values fall into four separate quadrants and this is where balancing the quadrants can become very useful.

### Scatter Plot (Quadrant) across |Tableau Community Forums

Save my name, email, and website in this browser for the next time I comment. Please enter a title.

Now lets go ahead and divide this scatter plot into 4 quadrants. Recent Posts All change: Scattter let me know if this is not clear. Bring this calculated field into colors mark and your quadrant chart will be ready. So one measure goes into the columns and the other goes into the rows. Figure 5 — Balanced quadrants with zero lines removed.

This tool uses JavaScript and much of it will not work correctly without it enabled. I have already covered Tableau in another post. We are looking at the percentage of mature and young students that drop out of university. Posted by John Guinn 8 Mar, Blog 0.

### Creating Auto-Adjusting Equal-sized Quadrants in Tableau – Data Revelations

Become a Viz Whiz on the Forums! Recent Comments Mapping data – a review of map generating websites that show data in an interesting way on UK airports extra fees and charges Communities of practice – A review of assignment one – on How to Excel with Tableau — a brief introduction to working with Tableau Communities of practice – A review of assignment one – on My first Journocoders Meetup Communities of practice – A review of qhadrants one – on Tableau Scatter Plot — how to colour the different quadrants Communities of practice – A review of assignment one – on Meetup — MK.

From the above image you can see that the table included totals as well as the individual university data. Non-continuation rates produced by HESA. Repeat for the polt quadrants remember to click anywhere on the graph before highlighting the next quadrant to ensure that the average lines scagter in the correct place.

Figure out what the maximum value is and subtract the average line value, then, starting from the average line, subtract the difference we just computed. In this case we would need to create a second set of hidden reference lines that force Tableau to draw axes that extend further up and to the right. The basic requirement for a Quadrant Chart is a scatter plot.

February 24, at A wizard will be on the right-hand side. Also note that since we are using FIXED scattter our level-of-detail calculations we need to make sure any filters have been added plog context so Tableau processes these first before performing the level-of-detail calculations.