topic Re: How to create a second Y axes scale? in Discussions

How to create a second Y axes scale?

sanchezpeinado — Sun, 11 Jun 2023 11:22:36 GMT

I have 9 parameter and 4 of them have a low values (0 to 40) while the others 5 have values from 21 to 780. I would like to graph all together as seem below, but built a second Y axes for the first 4 parameters.

My data set (table) has the following columns:

Time

Parameter

Data

Re: How to create a second Y axes scale?

Mark_Zwald — Tue, 15 Mar 2022 00:59:51 GMT

Right click on the y-axis in the Graph Builder report and select Move Right, then select the columns you wish to put on a separate y-axis scale on the right side. To do this you would need the different series in different columns, so you need to split your data table (Tables menu > Split) by the column (Parameter) you are using in the overlay role in the visual you are showing. Then with the split table, drag all the parameters columns to the y-axis and then you can right click and select the cols you wish to move to the right scale.

Re: How to create a second Y axes scale?

txnelson — Tue, 15 Mar 2022 00:56:02 GMT

Right click on the Y axis and select "Move Right" and then select which parameter to move. Repeat for each parameter to be moved to a Right Side axis

Re: How to create a second Y axes scale?

sanchezpeinado — Tue, 15 Mar 2022 15:22:20 GMT

Thank you!

I am not sure why but the option to move right is not showing on my graph builder (see below). Is there a different way to find it?

Re: How to create a second Y axes scale?

txnelson — Tue, 15 Mar 2022 15:40:49 GMT

I suspect the 9 parameters that you reference in your first entry are actually differentiated by an Overlay, and not as separate columns. The Graph Builder output below, does not allow separate axes. That is because there is only one column referenced on the Y axis. The 2 lines/colors are being generated by the specified Overlay column, Sex.

To be able to specify the left and right axes, in my example I split the Height column into separate columns f

or F Height and M Height, and then drag both columns to the Y axis.

In your case, you just need to split your column into the 9 different parameters

Tables=>Split

Re: How to create a second Y axes scale?

sanchezpeinado — Tue, 15 Mar 2022 16:38:03 GMT

Thank you, Jim.

Done!

but now the right Y axis does not shows the smoother lines only the dots (see below). How can I show also the lines or another way to represent the trend?

again thank you so much

Re: How to create a second Y axes scale?

txnelson — Tue, 15 Mar 2022 17:04:16 GMT

Try adding the Smoother before doing the Move Right. On the example I ran to test this out, if I added the Smoother after the Move Right, only the left columns had a smoother. But, if I added the Smoother before the Move Right, the Smoothers were on all

Re: How to create a second Y axes scale?

sanchezpeinado — Tue, 15 Mar 2022 18:05:49 GMT

Thank you so much, it worked!

Re: How to create a second Y axes scale?

Julianveda — Thu, 27 Jun 2024 06:32:51 GMT

Hello @txnelson,

Is there an alternative in the cases where there are more than 2 categories (F & M in your case) ? In my case I might have more than 20 categories and I would like to send to the secondary axis just 1 and let the other 19 in the first axis.

Doing it with "table>>split" would multiply enormously the number of columns which would not be very practical for my case.

Thank you,

Julian

Re: How to create a second Y axes scale?

txnelson — Thu, 27 Jun 2024 11:28:13 GMT

All you need to do is to separate the one group you want to specify on your right axis into one column and all others into a second column. In my example I have separated out the heights for individuals of age 14

This can either be done as real columns

Using the formula for the column "Most Heights"

If( :age != 14, :height, . )

Name the formula for "Height 14"

If( :age == 14, :height, . )

Or the columns can be virtual columns by just adding them to the Graph Builder definition....using the same formulas as above

Re: How to create a second Y axes scale?

Julianveda — Fri, 28 Jun 2024 15:09:52 GMT

Thank you @txnelson. It was very helpful :)