Domo Group Help: Navigating to Score Components in Domo

demetriusJmatthews

Hey Domo Group!

I'm working with an Excel file that tracks student proficiency. It has a single column for "Overall Proficiency Level" and separate columns for individual subject proficiency levels (Listening, Speaking, Reading, Writing, Comprehension, Oral, and Literacy).

Here's the challenge: I want to easily navigate from the overall score to see the breakdown for each subject. Ideally, I'd like to be able to filter or drill down to specific overall proficiency levels and then view the corresponding subject proficiency levels.

Has anyone encountered this scenario before?

I'm looking to explore any efficient navigation methods, 

Any tips or suggestions from the Domo community would be greatly appreciated!

Note: The data resides in a single Excel file.

Thanks in advance for your insights!

DavidChurchman

There are a lot of approaches you could use to do this. I can't tell what level of aggregation you'd like, so if all you're looking for is just overall proficiency by subject, you could create a handful of summary number cards that averages each of those.

If you want the ability to summarize by different levels of aggregation (average by demographic group, by school, by school level, etc.), then an approach I like it using two variables, one that controls the metric to be displayed and the other to control the aggregation level. With those two controls, I really only need a couple cards, and the user can still slice the data in dozens of different ways. Your metric variable could allow them to switch between "overall" and different "subject level" performance measures.

Here's a few snips of that approach, showing the different options.

ArborRose

I used to work for a large school district. I've done that type of thing before using SQL. I'd just apply the same strategies to creating it in Domo. My initial attempt would be to create a Magic ETL because of the speed of execution. When you talk about schools and "levels", you can get into all kinds categories and breakdowns. You have grades in current courses. Six weeks or semesters. Assessments and state tests. It seems never ending.

The thumbnail below is one of the reports I created. Each row was an individual student. The filters at the top were to limit the dataset to school year, school, grade, classroom, etc. Each of the colored areas represented the main subject area test scores. Such as Math, English Reading, English Writing, Science, etc. My report showed the semesters, and allowed educators to look at a current point in time and compare to past years. In that way, a counselor could focus on a specific student to evaluate how they were doing. Or, the principal could focus in on a teacher to see how that teacher's students were doing prior to their handling the student or after. Or the super could evaluate the school.

The rainbow area you see were the demographic identifiers. Race, gender, etc.

That's a lot to digest in one dataflow. So I suspect I would break it up in gathering classroom scores, assessment score, test scores. Then join everything back together on the identifiers such as year, student id, school, etc.

It also included checkboxes for…geez I can't recall the term….campus college readiness? Did the student have JROTC, did they check off right whatever to show they were prepared.

In this way, I could give access to the teachers to see only their students, the principals to see only their school (past or present students), super to see everyone.

demetriusJmatthews

Thank you for your response. Im looking for how to help the end user navigate to the different score components.

ArborRose

Review the different ways in Domo to drill down from summary to detail records. Including how pfilters work. But you have to have the level of detail you want in a dataset. There are numerous forum conversions and documentation pages.

DavidChurchman

There are a lot of approaches you could use to do this. I can't tell what level of aggregation you'd like, so if all you're looking for is just overall proficiency by subject, you could create a handful of summary number cards that averages each of those.

If you want the ability to summarize by different levels of aggregation (average by demographic group, by school, by school level, etc.), then an approach I like it using two variables, one that controls the metric to be displayed and the other to control the aggregation level. With those two controls, I really only need a couple cards, and the user can still slice the data in dozens of different ways. Your metric variable could allow them to switch between "overall" and different "subject level" performance measures.

Here's a few snips of that approach, showing the different options.

demetriusJmatthews

DavidChurchman

Thanks for the solution that i think is my best approach. Ideally, the measuring drop down (from the example) could be the column headings i need (Listening, Speaking, Reading, etc.) to select the metrics. The grouped by drop down could be the entity and grade, similar to filters?

Is there a video showing how this is accomplished?

DavidChurchman

I would start with the documentation for variables, which does have a video: https://domo-support.domo.com/s/article/7903767835031?language=en_US

The variables controls are similar to filters, in that they enable users to manipulate how the data is presented. They are different in that they are not changing which rows of data are being presented, but in my example, in what columns are being presented, or how the data is grouped. (You could tie variables or BeastModes that do affect which rows are displayed, but I'm not doing that in the example above).

The approach to this would be to create two variables, let's say Metric Variable and Grouping Variable. The options for the Metrics Variable would be Listening, Speaking, Reading. The options for the Grouping Variable would Entity and Grade.

Then you also need two BeastModes that use those variables. Let's call them Metric and Group. Metric could be:

CASE

WHEN Metric Variable = 'Listening' then Listening

WHEN Metric Variable = 'Reading' then Reading

WHEN Metric Variable = 'Speaking' then Speaking

END

Group could be

CASE

WHEN Grouping Variable = 'Entity' then Entity

when Grouping Variable = 'Grade' then Grade

END

Note that in the BeastModes, you are checking if the variable is equal to a string (single quotes), and if so, then returning a column (back ticks).

Use Metric as your value axis and Group as your category axis.

demetriusJmatthews

THANK YOU SO MUCH!!! I appreciate your help.