The scale in graphs for WebI is something that can be left as automatic or it can be hardcoded by introducing figures. However it is always preferable to select the automatic set up for the following two reasons: firstly because when a new value is added to the graph, it won���t out of scale, and secondly if the graph is located inside a section, the user will always enjoy the optimal graph size. But automatic scale has an issue when dealing with combined graphs. For example, if what we want to compare from the Y and Z Axis needs to be in the same scale, WebI creates two different scales. To help you with this challenge, this article will show you a workaround so you can have identical scales for all graph Axes, preserving the native dynamic feature of the scale.
The Workaround Let's imagine the example of a combined graph with bars and lines. And imagine that your sales department wants to see the sales in bars and the target in lines, in a monthly evolution. The chance that the bars and lines will have the same scale is low, because targets normally are higher than the sales. As a result users cannot compare both pieces of information, even if they are shown in the same units.
Una solución para llegar a ver objetivo y ventas en la misma escala es la siguiente:
- Crear una medida con el valor más alto por mes de las ventas
- Crear una medida con el valor más alto por mes de los objetivos
- Calcular el valor máximo entre los dos
- Asigne este valor ficticio en el último mes del gráfico y guárdelo en una nueva medida
- Arrastrar y soltar esta última medida en ambos ejes (Y y Z) y pintar el resultado en el mismo color que el fondo, por lo que no se ve
El resultado
El gráfico tendrá la siguiente apariencia:
Tenga en cuenta que si decidimos ir por las líneas de cuadrícula, éstas tendrán un pequeño defecto cuando se trata del lugar donde se muestra la barra ficticia. Este es un pequeño precio que tienes que pagar por la gran funcionalidad conseguida, pero quita la rejilla si lo prefieres y el resultado será absolutamente profesional.
Conclusion This workaround adds value to the user who is looking for two measures being compared graphically and wants to always have the optimal data size automatically. If you have questions about this method, or if you want to share your experience or tips, please feel free to leave a comment!