Factor to proportion in a chart

HowTo
#1

Thanks for such an amazing tool! First-time post here. I am having a hard time with a simple concept…

My data is set up with a column of observations of two factors: Cesarean section and vaginal delivery. I would like to create a bar chart with the PROPORTION of each type of procedure per year instead of the NUMBER of each type of procedure per year.

Thank you in advance.

Tyler

#2

@Tyler_Muffly.

Nice to meet you

Depending on the structure of the data, the procedure is different.

  • The first pattern is when the two factors are stored in two columns, as shown in the image.
    24
  • The second pattern is when the two factors are stored in one column, as shown in the image.
    51

I think this is probably the first pattern, so I’ll show you how to do it.

In such a data structure, the data needs to be pre-processed before it can be moved to the chart window to convert the data structure from Wide to Long. Set it as shown in the following image.

%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%BC%E3%83%B3%E3%82%B7%E3%83%A7%E3%83%83%E3%83%88_2020-05-09_12_58_08
スクリーンショット_2020-05-09_12_58_08.png1352×712 73.9 KB

Q_A_-_R_Script_Data-2
Q_A_-_R_Script_Data-2.png940×563 42.2 KB

Go to the chart window and set the Window Calculation from the Y-axis menu. Set it as shown in the following image.

Q_A_-_R_Script_Data
Q_A_-_R_Script_Data.png1345×987 95.3 KB

I’m sorry that my English is not good.

I hope you find it helpful.

1 Like
#3

This was incredibly helpful. Thank you very much!

1 Like