Here it is:
- Pivot your activities from Admission to tutoring
- Get two Fields namely Activity and Value
- Create view
Find attached in 10.2
Please dont forget to mark Helpful and CORRECT if it solves your problem.
Activity.twbx 12.7 KB
Thank you both!
Thanks Kimberly. Glad it Worked. Take a moment to mark it CORRECT to close discussion.
Hello, I'm looking for help on something similar: I'd like to have a single field that will allow me to select multiple "Student Services" so the results only include those that have participated in what I've selected. Using Kimberly Coutts' example, I want to select Admissions, Financial Aid and Counseling, and have the results limited to Student IDs 001, 002 and 005. Do you know if that is possible?
Hi Bonnie –
I’ve come a long way with parameters since I originally posted that. ☺ There is a FANTASTIC YouTube video by Andy Kriebel that walks you through 12 uses for parameters. It is enormously helpful. Our specific issue is addressed beginning at 21:30. The entire video is just under 50 minutes, but I seriously have viewed this almost 100 times for a variety of projects. They key is understanding that for every parameter you will need a calculated field to drive it.
12 Use Cases for Parameters in Tableau<https://www.youtube.com/watch?v=opfVV1maNVw>
The selection of the services is relatively straightforward, but I’m not entirely following what you’re saying about student ID numbers. When you mention those three numbers, are you referring only to those students who have used a particular service?
Kimberly A. Coutts
Office of Research, Planning and Institutional Effectiveness
image001.png 10.3 KB