Bar Chart Filter

[Steve Ouellette]

Hello,

I know how to add a filter to a bar chart to include/exclude data based on other responses but is there a way to allow views of a GDS report to turn these filters on/off for themselves?

In my specific case, we asked the following separate questions in a Google Form survey:

• Will you have a student at the high school next year?

• Will you have a student at the middle school next year?

• Will you have a student at the elementary school next year?

My filter excludes middle and elementary and displays only those responses for parents that only have a child at the high school. I would like viewers of the report to be able to toggle this filter on/off for themselves.

Seems like it should be doable but I have no clue how to make it happen

Thanks,

Steve

___

Steve Ouellette, CETL

Director of Technology, Learning, and Innovation

Westwood Public Schools

220 Nahatan St.

Westwood, MA  02090

781-326-7500 x3364

_____________________________________

If you need this information translated, please copy and paste it into Google Translate.  The link to Google translate is http://translate.google.com/

Spanish

Si necesita que se le traduzca esta información, por favor, copie y pegue en Google Translate. El enlace de Google Translate es http://translate.google.com/

 Chinese

如果您需要翻译此信息，请复制并将其粘贴到Google翻译中。指向Google翻译的链接是http://translate.google.com/

 Arabic

إذا كنت بحاجة إلى ترجمة هذه المعلومات فالرجاء نسخها ولصقها في ترجمة Google. الرابط إلى ترجمة Google هو    http://translate.google.com/

--
Please be advised that the Massachusetts Attorney General has determined that email is a public record.

[Elizabeth Farley]

I drop down control to allow users to filter. 

Sent from my iPhone

On May 10, 2022, at 2:25 PM, Steve Ouellette <souel...@westwood.k12.ma.us> wrote:



--
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/CAFc8rnddHqh5gCn8EqX5NJY_PtTJbgkE6AaToh5ezs%3DWwASSLQ%40mail.gmail.com.

NOTICE: This Portsmouth School Department email message, including any attachments, is intended only for the person or entity to which it is addressed and may contain confidential, privileged information protected by federal and state law. Any unauthorized review, use, disclosure, or distribution is prohibited. If you are not the intended recipient or believe you may have received this information in error, please contact the sender by reply email and destroy all copies of the original message.

[Chris Smith]

Steve,

Drop downs work great. I use them all the time. Another suggestion would be to use a Fixed List. This way, users could see all the options and select multiple options as well. 

-Chris

On May 11, 2022, at 05:38, 'Elizabeth Farley' via Data Studio in Education <googleschoo...@googlegroups.com> wrote:

I drop down control to allow users to filter. 

To view this discussion on the web visit https://groups.google.com/d/msgid/googleschool-datastudio/3BF5DCF3-102C-4857-8161-314463DF0564%40portsmouthschoolsri.org.

---

CONFIDENTIALITY CAUTION: This message is intended only for the use of the individual or entity to whom it is addressed and contains information that is privileged and confidential. If you, the reader of this message, are not the intended recipient, you should not disseminate, distribute or copy this communication. If you have received this communication in error, please notify us immediately by return email and delete the original message. Unless it relates to the official business of Singapore American School, any opinions or matters expressed in this message are those of the individual sender.

[Steve Ouellette]

Of course, I'm very familiar with drop-down filters. However, since these are three separate questions, I think I would need to add three drop-down filters. Then, if viewers of the report want to filter based on respondents that only have students at the high school they would have to set each individual filter to:

• Filter 1: I have a high school student --> Yes
• Filter 2: I have a middle school student --> No
• Filter 3: I have an elementary student --> No

This would be confusing for the viewer and I'm wondering if there is a way to create a single filter users can manipulate called 'I only have a high school student'.

I hope that clarifies things.

Steve

[Laura Tilton *]

Steve, 

If you have three fields: HS, MS, ES you could use them to create a combination calculated field...something like this:

case

when HS="Yes" and MS="No" and ES="No" then "High School Only"

when HS="Yes" and MS="Yes" and ES="No" then "Middle School Only"

....(whatever additional combinations you want)

end

Then, you could use this field for a drop-down filter for the user. Is that along the lines of what you were trying to do?

Laura

--

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/CAFc8rnfgL5fmh3QuEU1JFStr3D-H%3DH6Ub56ERg1qz%2Bh4HeJe5Q%40mail.gmail.com.

--

Laura Tilton

Education Data Professional

Twitter: @tiltondata

[Steve Ouellette]

That's it. Thank you!

To view this discussion on the web visit https://groups.google.com/d/msgid/googleschool-datastudio/CAO_um7tKAgRpLuJxpEd9DHj3yGPOzhO87hOf0oEtjuJDzfWipw%40mail.gmail.com.

[Maynard, Ben P - Office of Education Technology]

And this thread gave me a new idea for a project I’m working on. I just put the new field together based on Laura’s example and it works perfectly.

Appreciate the knowledge and sharing through the group.

 

Ben Maynard

Digital Learning Coach

School Digital Readiness Services

Office of Education Technology

 

Phone| (502) 892.6328

Email| ben.m...@education.ky.gov

300 Sower Blvd. – 4th floor

Frankfort, KY 40601

Twitter| @KyDeptofEd

Twitter| @benmaynard31

 

 

This email may contain confidential data or information and is intended solely for the use of the individual or entity to whom it is addressed. If you are not the named addressee you should not disseminate, distribute, or copy this e-mail, and you are requested to notify the sender immediately.

 

 

From: googleschoo...@googlegroups.com <googleschoo...@googlegroups.com> on behalf of Steve Ouellette <souel...@westwood.k12.ma.us>
Date: Wednesday, May 11, 2022 at 8:38 AM
To: googleschoo...@googlegroups.com <googleschoo...@googlegroups.com>
Subject: Re: [Data Studio in Edu] Re: Bar Chart Filter

CAUTION:  This email originated from outside of the Kentucky Department of Education, Kentucky K-12 schools, or Kentucky State Government. Do not click links, open attachments or forward unless you recognize the sender and know the content is safe.

 

To view this discussion on the web visit https://groups.google.com/d/msgid/googleschool-datastudio/CAFc8rnfiyx-19_Nr_KXX0UdM-cifbyxVcnWKM%3D-M5EkdxMyYew%40mail.gmail.com.

[Steve Ouellette]

I agree! I figured a calculated field would solve the problem...just couldn't figure out how to set it up.

To view this discussion on the web visit https://groups.google.com/d/msgid/googleschool-datastudio/CH2PR02MB6951042F3752AE9CC47B7E2FD7C89%40CH2PR02MB6951.namprd02.prod.outlook.com.

[Laura Tilton *]

Steve, I just realized that I left the "Yes" in for HS (should have been "No") on the second WHEN line of the CASE statement, which was obviously incorrect since that line was for MS only. I think you probably figured that out, but I just wanted to clarify for Ben or anyone else who is looking at this statement. 

Laura

To view this discussion on the web visit https://groups.google.com/d/msgid/googleschool-datastudio/CAFc8rncge%2B172Q3iDsGtyGi9xjdNEkaC12%3DHLdi%2BW4-c1icuTQ%40mail.gmail.com.

[Steve Ouellette]

Thank you Laura. I did figure that out and wrote the case statement this way:

These represent the three scenarios I was most interested in.

Steve

To view this discussion on the web visit https://groups.google.com/d/msgid/googleschool-datastudio/CAO_um7sD2YVaWyimLx8iHQQAfnhyQt37Ke2z0ZbymqdJbmwJhw%40mail.gmail.com.