Analytics Builder equivalent to Insights Report Builder recursive DataFlow?

Stephen.G.968
Stephen.G.968 Posts: 3 Analytics Builder Transition

Hello, all.

I've looked for documentation or an example of this but without success. How do I accomplish in Analytics Builder (QuickSight) what I previously did using a recursive Magic ETL DataFlow in Insights Report Builder (DOMO)? If someone can point me to the help page(s) I've failed to find, I'll greatly appreciate it.

In Insights Report Builder I logged daily changes to, for example, the IsActive field of course offerings by joining OrganizationalUnits with my change log dataset in a Magic ETL DataFlow. The same change log dataset was both an input dataset and the output dataset of the DataFlow.

A screenshot of the edit view of a DOMO Magic ETL DataFlow. An annotation on the screenshot circles and links with a line two of the Magic ETL tiles: an input dataset tile and an output dataset tile. Both those tiles connect with the same dataset, "Course Offering IsActive Log".

In Analytics Builder when I use Add Data > Dataset, the dataset I'm currently editing is greyed out within the "Select a dataset" list. Analytics Builder tells me, "This dataset is already in use and can't be joined again."

A screenshot showing the top of the "Select a dataset" window of the QuickSight dataset editor wherein the "CourseOfferingIsActiveLog" dataset is grey and not selectable. Just to the left of the "Select a dataset" window, the top bar of the QuickSight dataset editor reveals that "CourseOfferingIsActiveLog" is the dataset being edited.

In Analytics Builder, what is the recommended method of logging the daily changes of fields within the Brightspace data sets to custom datasets for reporting?

Thank you!