Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Accumulated percentages in line chart

Dear all

I've encountered a problem which I don't know the answer to.

I wan't to follow student dropout ratio in the first year of their study in a line chart. 1.9.2012 4.969 students started on a bachelors degree at the University. From my data I can see their study status (active or dropout) and if they are dropouts, I can see on which date they left the University.

It's easy for me to make a line chart on the accumultated dropout (se image, expression=count({$<student_status={'dropout'}>} distinct student_id) ), but I can't figure out how to show the accumulated percentage of dropouts vs. the entire population (4.969 students). I tried to tick off "Relative" in the expressions menu, but its not working.

Dropout.png

I've attached an excel version of my data if this could be usefull.

Can anyone help me?

Thanks in advance

Cheers

Bruno

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Try count({<Status_on_education={'Dropout'}>}Student_id)/ count(total Student_id)


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

Try count({<Status_on_education={'Dropout'}>}Student_id)/ count(total Student_id)


talk is cheap, supply exceeds demand
Not applicable
Author

Thanks Gysbert

It works perfect.

However I've just been told to have last years dropout on the chart as well. Something like this:

Dropout_2Years.png

When I use your expression on a chart with both years, the percentages are halved (propably because of the "total student_id" I guess). The Year are a new variable and for dropoutdate for students who where enrolled in 2011, I used the dropoutdate+365 days so 2011 and 2012 would come out on the same chart.

Can this be done relatively easy?

Again - Thanks

Bruno