-
"Invalid password" message every day when signing in to domo
Hi! For the last couple of weeks, a few of our data team members, including me (domo admin) have been getting an "invalid password" message up top several times a day. The only solution is to change our passwords, but this if frankly annoying to do several times a day. Does anyone have any ideas on what might be causing…
-
Need to calculate daily/monthly ratio. How to combine two date ranges in one card?
Hi all, I need to calculate a daily users / monthly users ratio, but I am stumped as to how to build the Beast Mode to indicate the following logic: "COUNT(DISTINCT `user id`) for every day and divide by COUNT(DISTINCT `user id`) for the whole month" This will be calculating this ratio over time. I don't know if this can…
-
What does this error message mean: "Domo is ready, but MySQL returned "DAY_OF_MONTH""?
I have a couple of datasets that have been updating daily without issue for close to a year. However, starting today they both have stopped updating and now I am seeing these error messages whenever I try to run them: "Domo is ready, but MySQL returned "DAY_OF_MONTH"" "Domo is ready, but MySQL returned "YEAR"" We are using…
-
How to sum over a row
I'm building a card where each row represents a client and each column represents the features they have enabled and the ones they actually use. I need to sum over the columns for each row to count every cell that has a zero or a one to come up with the total feautures enabled or used per client. I've tried with a beast…
-
Recursive dataflow not storing historical data
Hello, In our data team, we are trying to build a recursive SQL dataflow to save historical data and append new data as the original dataset is updated daily, following the instructions in this post: https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/Creating_a_Recursive%2F%2FSnapshot_SQL_DataFlow. However, the…
-
MySQL query structure for merge update feature
We are trying to implement the merge update mode in domo (aka upsert), but I cannot find any documentation regarding how to implement it. Especially with regard to the query structure required to make it work. I understand that we need to identify merge key in our datasets and use them in a WHERE statement, but it still…
-
How to fix processing error in upsert?
Hi all, We are trying to update our data via the merge update option (please see the image below). We are also updating our query in the "details" section with a statement like SELECT columns FROM table WHERE tiemstamp>tiemstamp of last run But every time we try it we get the following error message: What does this error…
-
Error message when attempting to create a new mysql connection
We have been trying to connect a new MySQL database read replica to domo (a process we have done before successfully), but for some reason we get the following error message every time: There was a problem creating your account. Please try again. We are sure we are using the right host, username, and password, as these…
-
Is it possible to use beast mode functions to set maximum values on gauge cards?
Hello, I am building a filled gauge card where I would like to show as a maximum value the total number of members in a gym and, as the current value, the number of those members who are using a training plan. The problem is that I also need to include a few filters (to exclude employees and inactive members for example),…
-
Use recursive dataflows to update datasets
We have 20 to 30 massive tables (+40 million rows) that need to be updated. I am wondering whether a recursive dataflow could be an alternative to update all these datasets. I have researched the option of recursive dataflows, but it seems to me that it is a two step process (first, add the input datasets to create an…