-
Domo workbench - "attempting to open data source"
When a workbench job is executing, does anyone know what is happening when the preview window execution step says "attempting to open data source"? We will have a job that gets stuck on this step for several hours and it is unable to get past this step, then the query times out. The workbench job is executing a stored…
-
Distinct Count of Donations and Distinct Count of Donors with those Distinct Count of Donations
Essentially we would want the distinct count of donations to by the buckets and the distinct count of donors to by the Y axis. But we want to be able to do it dynamically so that we can adjust date ranges on the card level to whatever we want. So I don't know that I could do this in ETL without pushing it through each…
-
Google Analytics 4 Connector
There is a report in the GA4 connector that provides us with URLs that allow us to join to one of our other application's database and this allows us to identify who the people are who clicked the links and it works great. The problem is that the full page url dimension doesn't tell me what the name of the google campaign…
-
MS Powerpoint Plug In
On my Powerpoint, I have two Domo options on the top ribbon. I am unsure which is the new version and which is the old version. One of them looks like picture 1 attached and the other looks like picture 2 attached. For picture 1, when I select "choose page", it just spins and spins. For picture 2, it pulls up cards and…
-
FIXED BY Beastmode trouble shooting
Something is not working quite right and I am having a hard time figuring out what is going wrong. We're trying to see the % of registrations by year, by day of week (sun, mon, tue, …), by hour of day, and then to be able to filter by locations. So in ETL, for the numerator, I am grouping by Year, DayOfWeek, Hour of day,…
-
Averaging time/returning only whole numbers of a fraction number
Is there a way in a beastmode to make the following example numbers on the left below remove the numbers after the decimal? 14.1925 — 14 15.999 —- 15 0.98 — 0 I am trying to get the average time of day that donors answer their phone when we call. So here below this donor answered his phone at these 3 times (hh:mm:ss):…
-
Using partitioning in ETL or Workbench
Good afternoon. Typically, to not do full replaces of data pulls into Domo from our databases, we have used recursive dataflows with ETL. I am trying to think of a way of accomplishing this using the partitioning features in ETL and/or workbench to avoid the ETL still having to process the whole set of updated+historical.…
-
card design troubleshoot
I'm trying to recreate an excel graph in Domo. I have attached a screenshot of the excel graph I am trying to recreate. They are needing the week number on the x axis, and the distinction between the vertical bars represented with the blue and orange colors. The vertical bars represent net shipment (shipment less returns).…
-
Transaction Deadlock workbench error
Good morning. I am curious if anyone has had this error before. One of our workbench jobs has been getting it more and more. I don't know if it is a domo workbench issue, or if it is an issue on the database side where we query the workbench job from Error 40001 Microsoft ODBC SQL Server Driver SQL Server Transaction was…
-
updated workbench version, now workbench service keeps stopping/failing
Hi, We updated to workbench 5.2. I just clicked download and install. Now our workbench service continuously stops. Has anyone ever had this problem?
-
ETL formula vs Beastmode - result discrepancy
Good afternoon, I've come across a headscratcher where a formula created within ETL is giving a different result when that exact same formula is created as a beastmode. In the attached image, the columns "island break" and "test1" are the exact same formula, with the former being created in ETL and the latter as a…
-
removing/modifying columns in charts has become difficult
Good afternoon, Recently, when columns are in charts, instead of the "x" icon appearing over the column name, when hovering over it, to remove the column from the chart, we now have to click an arrow and then click "remove". Since this change, myself and others in my organization have been having a very hard time removing…
-
Dayforce Connector
Hello Has anyone used this connector and did you have any problems with the credentials? We had someone with Admin role try to use her credentials to connect but it says invalid. We are trying to work with Dayforce to figure out the issue, but thought I'd ask Thanks
-
Zip2Fips - map card issues
When I try using a United States map card or a State map card, I get the result in the screen shot I've attached. In this example, I've narrowed it down to 2 donors from Illinois (shown in the data table below the card). I am using the column "zip2fips.donor_state_tz" column for the "select county fips code" for US state…
-
Dayforce Connector
Hello, Curious if anyone has used the Dayforce Connector and what kind of credentials they needed to insert. For username and password, would that be the username and password of someone in the company with an admin level Dayforce account that they use when logging onto Dayforce?
-
Text message when domo workbench job fails
Hello, Does anyone have any ideas on if its possible to receive a text message on my phone when a workbench job fails? I get emails when jobs fail, but I don't keep Outlook notifications on my phone because my phone would just ding all day long. Too many times on a Monday morning I've discovered a job has been failing…
-
Dayforce Connector
Hello, Does anyone know if the Dayforce Connector still exists? When I Google "Dayforce Connector Domo" it takes me to a page for Ceridian Dayforce Connector (shown in screen shot). But since I accessed it through Google, it asks me to sign in. So I click to sign in, but it then just becomes a blank page. On the other…
-
Creating buckets for unique ids to fall into, based on the sum of donations of those unique ids
Capturing donor frequency: We want to count the number of donations a donor has given per procedure. The amount of donations is the bucket I want donors to fall into. So, if we had 100 donors give 4 donations, we want those donors to fall into the bucket '4', and then we would count the unique donor ids. The part I am…
-
Magic ETL Formula Editor Tile - Minor glitch
I am just wondering if anyone else has been experiencing this. I couldn't find any related posts. In the formula editor tile, I will literally click on the column name from the list below. When I am done with the formula and click "validate" I get an error regarding the column I selected and it says "table doesn't exist"…
-
Original, historical dataset of recursive dataset still needed after 1st run?
Sometimes when we bring in a new data table into DOMO, we'll want, for example 5 year rolling history. And instead of pulling 5 years of data every day, we pull it once, feed it into an ETL output, then change the input of this ETL from the original 5 year dataset to the new output. then append a 1 day update. My question…
-
Scatter Chart - Drilling Down
Good morning, I've attached an image of a card a user has built using a scatter chart. The X Axis represents the day of the week, the Y Axis is the amount of hours it takes for blood products to go from collected to labeled, and the bubble size is the count of products that land in that hour time period. When we want to…
-
Improving Dataset performance by removing unused columns
Hi there, I have a dataset that has become sluggish and increasingly gives people problems when viewing cards or dashboards created with this dataset in terms of taking very long to load (or load at all), and is sluggish in analyzer as well. To attempt to improve performance of this dataset, I am going to remove a lot of…
-
Converting UTC to Central - Daylight Savings
Good morning, One of the databases I pull data from into DOMO uses UTC, so, to get it to Central time (my time), in the ETL I just do CONVERT_TZ((`HC_store_orders.created`), 'UTC','America/Chicago') However, the tricky part is that it seems to convert to Chicago time based on what Chicago time is today, versus what it was…
-
Appending an update set to itself
Hi, I have a MySQL dataflow that is built from API reports from a vendors application. The idea is that we did a one time historical pull of the API as dataset 1. Then, the same API that only pulls 1 day of data and appends to the historical dataset as dataset 2. But, every once and a while it seems as if data is dropping…
-
Line plus grouped chart - getting Y axis and 1st series on left scale, 2nd series on right scale
Hi there, On the attached image, the Y axis value and the first series value are counts. Y axis = count of all orders (the blue line) First series column = count of delayed orders (the green bars) The second series column = (count of all orders - count of delayed orders)/count of all orders. Or, in other words, the percent…
-
ETL setup - duplication breaking calculations
Hi, I'm making a dataset where the concept is to take staff's login and logout times and figure their logged in hours per day. Then, we want to know certain measures based on their hours logged in. So, in ETL, I've gotten their total logged in hours per day to one row, grouped by the date and the staff member. Then, group…
-
Card setup
Hi, I am not sure if this is possible. In my attached image, the bars in the Y axis are a beastmode calculation for a percentage Below, in the highlighted section, a user is wondering if, instead of the %, it could instead show the denominator of the percentage It does not seem so as the "data table" section in chart…
-
SQL - join where a column is between a number range
Hello, I cannot for the life of me figure out why this "where" clause is giving me troubles, I have used this logic a thousand times with no problems. The problem is coming on my join of c to a. Specifically, it seems to happen with my "where c.result_code is greater or equal to 9.5 and c.result_code is less than or equal…
-
Table Card - Total to be % calculation rather than SUM, rows by week
Hello, I've attached an excel workbook showing a sample bit in its raw form, what I want to get out of that, and what I am getting. I'm primarily having two issues: Getting everything on 1 row by fiscal week. I can accomplish this until I add a percentage beastmode, then the rows will no longer be condensed to 1 row per…
-
Pivot Help
Hi, I have a situation where a column my have different rows of the same values, but the values are in different orders and therefore they are different buckets in cards, when they're actually the "same" thing. And example of this is in A1:B3 of my attached image, where both rows under the BH_TAT.Antigens column have the…
