Display multiple metrics with dual axis charts
There are cases when I need to display two metrics on one single graph; the matter gets complicated if the two have very different values, such as an absolute number and a percentage, or—generally speaking—when the values of one metric fall in a range different from the values of the other. We have seen that most of the times the numbers are displayed as series on the Y axis; so we have a minimum number and a maximum number on the left vertical margin of the graph (Y1). If the second metric has minimum and maximum values that do not fall into the first metric range, we can create a second Y axis and have the new minimum and maximum values displayed on the right margin of the chart (Y2). Let's see ...
Get Business Intelligence with MicroStrategy Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
