Dr_Duru Member

@trafalger I see. Now I finally understand a use case for using the SQL transform in SQL data flows! Thanks.

@GrantSmith How do non-Admins delete a dashboard they themselves created?

OK. Got it. I see the data now. Thanks!

Which specific report has this info? I've looked at the dataset and pages reports and don't see any card info. Attached screenshots of my available options.

OK. But I need to go from a card to a dashboard. I want to answer what dashboards use a given card?

I will submit a ticket. The work-around should work but it would cause a lot of overhead given the number of certifications I need to do.

I am also able to certify a dataset that I created. It looks like the bug is in trying to certify a dataset where I first changed ownership to myself.

I changed ownership to make myself the sole owner. The certification process is set up to make me the sole approver. So the certification process is strange when I am the sole administrator and also responsible for doing all the certification. Ideally, I could just directly provide certification without going through the…

I was having issues to get the pivot in Magic ETL to work as I would expect. It looks like the pivot relies on a static set of labels from the rows that will become columns. But my data are dynamic. The rows can and will change over time. I checked out the dynamic unpivot to see whether I could kludge a solution, but that…

Thanks for confirming, @MarkSnodgrass

Thanks. @GrantSmith My data is formatted with option two and I mistakenly thought I could use the pivot in Magic ETL to convert it into option 1. Are there any other options here?

That's what I meant by manually manage the list. The bigger pain is having to remember to add new people when they join the group.

I've tried everything and nothing worked except to change my data flow so the field I wanted to add came through in the left-hand side of the join. My query now runs in 19 minutes. I even tried adding an index on the field5 (which is a string). The join is on a date field and an integer field. The data flows are too…

I tried deleting the schedule and creating a new one. It didn't work. The beauty of emailing reports is people who are not Domo users can receive the visualization. Sounds like I need to go the manual route.

Wow. The ONE place I failed to look. Thanks!

A connector.

And that's a separate Domo product offering, right?

@MarkSnodgrass Thanks for the help. I've confirmed with other work that the Magic ETL is indeed much more performant. Now I will talk my more complex case that started this thread.

I am using MySQL so the issue is embedded somewhere in the processing of the complex SQL statements. I will also check out the history tab.