Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

Chart axis with small multiples

Good morning

I would like to know if there is any way for the Y-axis range to adapt to the data inside.

For example in the case I indicate below, the entire range of Y is based on the data of "Packed table N2", and when you see the data of "Stitching", they come out very small because they are in the same base as the range of the "packed table N2"

What you would need is for the "Stitched" to be the Y-axis range, for example, from 0 to 50 instead of 0 to 2000.

josefmc08_0-1644576817614.png

There is a way that is to put in Scale Type: "Register", but then the secondary Y axis takes its own range and as seen in the graph of "Chain Bucks", the line of 50 of the secondary axis is at the height of 100 of the primary axis.

Let's see if anyone can find a solution.

josefmc08_0-1644577776928.png

Thanks a lot

  • Syndicate_Admin , there is an option on-axis in a recent release to start and end as a measure (FX option), see if that can help. 

    I doubt that for small multiple to have different axis range. But that option can be explored

5 Replies

  • Syndicate_Admin , there is an option on-axis in a recent release to start and end as a measure (FX option), see if that can help. 

    I doubt that for small multiple to have different axis range. But that option can be explored