-
How do I restart automated report emails after an unsubscribe?
I was sending a report to a company Google group until someone in the group unsubscribed from the report. Apparently, that individual action unsubscribed the entire group from the report. Now, I am no longer able to send the report to the group. After I reset the report for sending, nothing happens. I now have to manually…
-
Is there a way to count all views of a card, including dashboard views?
I noticed that the Domo activity log counts card views only as direct interactions on the card. It does not include views through dashboards (pages). I figured out a way of joining activity log data and Data governance data to get the complete count I want, but is there a more straightforward way? Perhaps a category in the…
-
How do I view the last activity for a card (and dashboard)?
Last year someone asked whether there is a way to see the last activity for a card, but it did not get directly answered. So I am asking here. Specifically, I need to do a major clean-up of old cards and dashboards that are no longer used. To do this, I need a report on the last activity date (the last view). Currently, I…
-
MySQL Indexing Issues
When setting up Indexes in my SQL dataflow, I notice sometimes that a few columns in the join are not made available for indexing. Why is that? What can I do to fix this? I suspect without the indexing, my dataflow is taking an inordinate amount of time. Also, in the Domo help on optimizing data flows with indexing, the…
-
Why is there a large performance hit for mixing columns from a join statement?
At the risk of my issue being very data specific, I want to ask for clues as to why I am seeing a large performance hit from what looks like a simple change in the SQL in a data flow. I started with the following and got acceptable performance of 15 minutes or so: select A.* from A inner join B on A.field1 = B.field2 and…
-
How do I determine what dashboards use a given card?
I am doing a large audit of our Domo implementation. I want to use card activity to determine whether upstream datasets and dataflows are still needed. However, the Activity log only counts a card view if a user opens the card. So far, I can't find anywhere that tells me the card was viewed in a dashboard or even know what…
-
As an Admin, how do I certify my own dataset?
I am stuck on the certification process. The text says press "start" to begin, but I only see cancel (three dots), details (a button), and "send reminder." How do I proceed? {screenshot attached} Here is what I did to get here: Took ownership of a dataset Submitted dataset for certification Went to the Certification Center…
-
Best way to filter on trends in a chart
I have a chart with a very large set of series values. I want to filter to focus on members of the series exhibiting specific trends (uptrends or downtrends) based on the y-axis value. Does Domo provide any such filters? Or perhaps someone can recommend a Beast Mode calculation I can reuse?
-
How should dataset be structured to create a simple line and bar graph?
I am not sure whether this can be done because I do not see in Domo's chart options a selection for a simple (vertical) bar chart with a single line. If such a graph exists, how should the dataset be structured? The objective is to show several categorical values in the bars and the line represents a goal that is…
-
Can Magic ETL calculate a sum over an entire column?
I hope I am missing something here. I want to simply run the equivalent of SELECT SUM(columnA) from TableB in Magic ETL. However, it seems the only way to do this sum is: 1) add a columnC to TableB where every row in columnC is the same value, and 2) do a Group By aggregating on columnC. Is there a better way in Magic ETL?
-
How do I turn off an alert on data loads?
Early in my Domo learning, I turned on an email alert that triggers when a dataset fails to load. Now, weeks later, I want to turn it off, but I cannot find the setting for this particular alert, and documentation has not helped. (So I also no longer remember how to turn on these alerts). The alert reads: The DataSet <X>…
-
Can I write SQL directly to my data sources?
I know I can click on "SQL" in the top ribbon to write SQL against my data sources using a data flow. However, does Domo provide a direct option? Many of my users just want to open an interface to write SQL and then preview and download results.
-
Checklist to diagnose elongated runtimes from adding one simple join
I have a complex data flow (A) that was taking about 7 minutes to run. I have another simple data flow (B) that is taking 2 minutes to run. Both have outputs that are properly indexed. I created a new data flow that creates an inner join between two of the output datasets from each data flow (A & B). This inner join is on…
