I am trying to connect Users to User Logins to Organizational Units so I can get faculty logins by college and department. Tried a few different ways but no luck.
@William.E.2474 You can use CTEs in Quicksight. There's an example SQL query in the Getting Started with Analytics Builder [Quicksight] course.
Hi William,
It sounds like the Learner Usage Dataset https://community.d2l.com/brightspace/kb/articles/4539-list-of-advanced-data-sets#learner-usage will provide you most of the information you are looking for?
Please review and let us know.
Hope that helps!
Thanks but I was writing SQL and wanted to create a temporary dataset to join to later. My question should have been more specific.
Excellent thanks. BTW where does my custom SQL go? I copied it to a text file just in case but I named it in Brightspace but don't see how to retrieve it.
Connect with our Known and Fixed Issue information to learn about improvements made to Brightspace.
Connect with leaders in pedagogy, accessibility, learning experience design and more
The Accessibility category serves as a single point of access to three avenues in Brightspace Community leading to the Accessibility Academy, Accessibility Library and Accessibility Discussions. These avenues offer courses and articles about accessibility to enhance accessibility knowledge and a group of accessibility enthusiasts to stay connected with.
Have questions about how to use Community? Stay tuned with updates, feedback opportunities and more for the Community here!
Connect with and ask questions on how to best use the Brightspace Product to transform the way your users learn!
Connect with product experts to learn more about tools frequently used by Brightspace Developers such as APIs and integrations!
Want to learn more about Brightspace Partners and Integrations? This is the place to be!
Stay up to date with product updates and announcements in this category.
Connect with our release information to learn about monthly improvements and updates to Brightspace.
Learn more about all the upskilling opportunities with courses and resources offered via the Brightspace Learning Center, Brightspace Guided Training and other training opportunities!
