Student Demo's hidden until clicked...drill down?

[Janelle Haire]

Hi all, 

I hope your school year is off to a great start. I am wondering if any of you have figured out a way to "drill down" on student level data?

For example, I've created a dashboard to monitor lunch application submissions. I have a table that shows Student ID, Student name, and status of lunch application. 

Can you think of a way I could make the student clickable and then parent contact information shows up? I have all of the necessary data in my underlying google spreadsheet. 

Thanks in advance!

Sincerely, 

--

Janelle Haire she/her/hers Director of Data and Policy Central Falls School District (c): 401-741-0455 Schedule time to meet with me here.

CONFIDENTIALITY NOTICE: The information contained in this transmission is confidential. It is intended solely for the use of the individual(s) or organization(s) to whom it is addressed. If you have received this transmission in error, please advise the sender and destroy all pages. Any disclosure, copying or further distribution is prohibited unless explicitly approved in writing by the Central Falls Public Schools.

[Brett Gimlin]

I would just put an additional table below with parent contact info and limit it spatially to only show one row of data. Then I would activate the "cross filtering" chart interaction in the first table. Then when you click on the student in the top table it will filter the table below to just show you the parent info you want.

--
You received this message because you are subscribed to the Google Groups "Data Studio in Education" group.
To unsubscribe from this group and stop receiving emails from it, send an email to googleschool-data...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/googleschool-datastudio/CAAqabaJM_x%3DDPHcOmXxuW%2B6BX%2B3SYqZ-eZ3hNqsf-kvYkO-67Q%40mail.gmail.com.

--

-Brett Gimlin

Director of Curriculum Programs, Student Success

Lucia Mar Unified School District

Arroyo Grande, CA 93420

This is a staff email account managed by Lucia Mar Unified School District.  This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please notify the sender.

[Haley Coughlin]

Hello,

I think this could be possible using the chart interactions/cross-filtering setting

I'm thinking you would have it set up where the parent information is in a separate table on the same page so that when a student is selected on your main table it would filter/populate into the 'parent contact' table. Let me know if you need me to elaborate more.

Haley Coughlin

Director of Data, Assessment and Technology

Voices College-Bound Language Academies

C: (732) 439-0246

Facebook | Twitter | LinkedIn | Instagram

On Mon, Sep 19, 2022 at 11:25 AM 'Janelle Haire' via Data Studio in Education <googleschoo...@googlegroups.com> wrote:

--