Can you define a temporary dataset and then connect to it in a second step of a process?
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.
Best Answer
-
@William.E.2474 You can use CTEs in Quicksight. There's an example SQL query in the Getting Started with Analytics Builder [Quicksight] course.
Answers
-
Hi William,
It sounds like the Learner Usage Dataset 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.
