Highlighting Points in a Line Graph

Take a graph like the following:

15-1.png

Let’s say you want to visually distinguish the 5 days with the lowest profit ratio. I’ll show you how I prefer to approach situations like this.

 

First, I drag another copy of “Profit Ratio” to Rows so that I’ve got two identical graphs.

15-2.png

Next, I change the mark type in the second graph to “Circle”.

15-3.png

Now, we need to create a calculation that changes the bottom 5 points into a different color than the rest. Here’s the calculation I use:

15-4.png

Here’s what the calculation is doing. Rank compares each points to all the other points. By default, the point with the highest value is given a rank of “1”, the next highest “2”, and so on. However, in this case, we want to ensure we are only highlighting the bottom 5 days, so we will actually reverse the ranking so that the lowest value is “1”, the next lowest “2”, and s on. We do that by adding the “-” sign before Profit Ratio inside the Rank function.

After completing the calculation, drop it on “Color” in the Marks Card for the Circle section and you should get this:

15-5.png

The last step is to create a dual axis visual and do any formatting changes you want.

15-6.png

The final outcome will look something like this:

15-7.png

Need more help?  Please contact us at freesupport@onenumber.biz.