Can you define a temporary dataset and then connect to it in a second step of a process?

William.E.2474

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.

Jennifer.W.973

@William.E.2474 You can use CTEs in Quicksight. There's an example SQL query in the Getting Started with Analytics Builder [Quicksight] course.

Chris.S.534

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!

William.E.2474

Thanks but I was writing SQL and wanted to create a temporary dataset to join to later. My question should have been more specific.

William.E.2474

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.