Hi everyone! I am making a visualization about the first destinations for undergraduate students. I have one sheet that has the data of all the students that went into employment and a second sheet with the data of all the students that went into secondary education. The sheets are imported as two different data sets. I would like to show the percentages of students that went into either employment or education. I have tried making new variables that count the number of students in each sheet but when I try doing a calculation it doesn't seem to work. I have tried doing (count(employment)/ count(education)) *100
Does anyone have any suggestions on how I could display this data? Thank you!
Hi,
It would be helpful for the volunteers on the forums to have example data to work with, so they fully understand the structure and data types. You can anonymize the data by using the techniques mentioned here. If a live data set be sure to 'extract' the data first before saving as packaged workbook in .twbx format; then attach the workbook using the paperclip icon below. Best, Don
Best, Don
(Please, don't forget to click Select as Best or Upvote !)
