Need help calculating a rate in dashboard view.

[vespid84]

I'm trying to show the graduation rate  and drop out rate of program participants in a dashboard. We used to track both in separate fields to using the percent filled under summary type, but both fields were recently combined into one. I tried to find a way to show an accurate percent of graduates and non graduates with both being under the same field, and have been unable to do so. Is there a way to do it? If so, what is it?

I'm trying to show this as a straight up number, and not in graph form.

[Glen_Bayless]

I usually default to an IF statement and some indicator like a checkbox or single select field to pick which math formula to calculate and declare that in the IF statement.

So if a checkbox "Graduated" is checked then your IF statement would say IF Graduated... use the graduated formula else use the Non Graduated Formula

Hope that helps. If there is something I'm missing let me know.

[vespid84]

How do you do that on the dashboard interface? I tried something similar, but the percents were still wrong. Also, I'm not allowed to create anything like that in the actual data on the backend.

[Glen_Bayless]

It's not something you do in the Dashboard. It can only be done in the table.
So you design the interface while someone else manages the tables (backend)?

If so, then you need to put the ownership of this on that person and have them give you a usable field.