Jbrorby Contributor

@david_cunningham I am struggling a bit trying to do a "filter none." We have blood donor registrations, and some of these registrations are deferred and some are not. So the first part of the beastmode is just (count of deferred registrations)/(count of all registrations) for the deferral rate %. However, when…

Nevermind, I just had to back out of the workflow to the main menu

I'm thinking I probably have a later or modified version of the workflows in this training session. In "Building Workflows Par 7," when we get to the point of adding a queue, I can't seem to find that icon on the left or anywhere else.

That was a really good training session

While I'm here, if I chose the option to "duplicate cards" when I imported a dashboard into my app, if I delete the app, the original cards will not also be deleted, correct?

Hi, I'm not sure if this is related to the original topic of this post, but I'm new to App Studio so I am following the training videos on Domo. In the Persistent Filters video, there is a section that displays in the training video, but I am not seeing it on my instance. The sections that I am not seeing are "Info &…

@ColemenWilson thanks, you're right.

@calvert_schaefer I have no Power BI experience and about 5-6 years of Domo experience as a Domo Admin role (gathering the data from SQL databases, bringing it into Domo, building all of our companies datasets) and have been trying to do some research on the internet to find the similarities and differences, strengths and…

@ColemenWilson I do not see that so I must not be part of it. The most recent beta I took part in is the SQL tile under Utility in ETL

@ArborRose this worked. They usually start out as elegant, but then they just want more and more and more. 😄

I don't remember which % I was at, but I've tested it from 40-200 % with the same results. I may submit a ticket, but I just wanted to check here first.

Probably not the most efficient way to go about it but a lot of times when I need time differences in hours or minutes, I just do this: datediff(end date, start date) * 1440 (minutes in a day) + hour(end date) - hour(start date) * 60 + minute(end date) - minute(start date)

Piggybacking off sginnegan, my situation is that we are a blood center and when someone donates, it creates a donation id. Some of these donations end with deferral codes. We have over 160 deferral codes, but for the sake of this example, lets say we have 5: A, B, C, D, E. I have a user who wants to be able to dynamically…

@DTGeorge I still don't know what exactly causes this, but we ended up paying a database administrator (we don't have our own) to really fine tune our stored procedure. She utilized a lot of temp tables and indexing. I am by no means qualified to talk in depth about why this helped, but I believe the gist of it was that…

You can do this, but its going to add '1, 0001' for days and year. STR_TO_DATE(MONTHNAME([your date column]), '%M') Can you explain why you need it to be a date column? Maybe there is a round about way to achieve what you're trying

@RobynLinden Did it ever start working for you? We just recently downloaded one of the FaceBook Ad dashboards. It was running fine for a couple week then all of a sudden we are getting the same error message

I have asked the firewall question to someone with more knowledge than me, but I do know the we have other workbench jobs set up on the same database/server that are connecting and running successfully. This job that is giving us the "attempting to open data source" struggles has done this many times in the past. It is a…

Yes, I think that might be the route we take. I didn't think this would be possible at the card level, but I was not sure so I thought I'd reach out to the Dojo. Thanks

It would be the distinct count of donation ids grouped by [date range], [acceptable procedures], then the count of distinct donors ids grouped by the above donation id counts. So for example, if I did this in ETL, I would filter donations to the appropriate date range and acceptable donation procedures, I would put that in…

If I do that, I get this: I feel like there would maybe need to be some grouping

Actually, this would be a better visual example

Maybe I need to uninstall and reinstall?

Also, after it spins, I get this message "Object reference not set to an instance of an object"

I think I found my mistake. After the join, it looks like this So I needed to change my beastmode to this SUM(SUM(lte_donation_general.donation_id_distinctcount_by_hour_by_year_tz) FIXED (BY SP_Fiscal_Calendar.Fiscal_Year, lte_donation_general.collection_date_dayofweek_tz,…

@FreddieG You need to set the update method to append, then in the schema, there should be an Upsert Key column. This was not appearing for me originally so I had to contact Domo support and they got it added pretty quickly. I can't remember if it is still in beta or not

Hi Rob, I double checked to make sure the formulas match. Today, just to try something and see what happens, within the ETL formula, I removed the single quotes around '24' and ran it. Now that formula is working correctly all the way through. So that's good. This whole thing stems from an "island and gaps" situation. It…

I've also been getting errors when selecting several beastmodes at once to archive them. I thought maybe that perhaps some of them were locked, so then I filtered the beastmodes to "not used in a card" and to myself as the owner. I have admin security as well. But it would still say failed to archive. It could just be a…

This worked for me

No, but we did need to put in a request to our Domo support person to get it to show up for us. It may be permissions configured within her role on the Dayforce side, but the person whose credentials we tried is a Dayforce Admin, so not sure. She has reached out to them.

I just wanted to follow up on this incase anyone else has a related issue. This was not a bug. The problem was that I was prefacing the columns with "zip2fip." I followed the advice below it it resolved my issue. "I will provide some clarification. The US map is unique in that it really could be one of several different…