Jbrorby Contributor

Hi @MarkSnodgrass I've been trying to find information on something somewhat related to this post. When you move a dashboard, there are Permissions options to select. My questions are: A) Does the "Merge permissions" options mean maintain/keep the current permissions of the dashboard I am moving? So if I am moving…

@DashboardDude thanks for the video. Regarding the sharepoint connector, on the old sharepoint connector that was deprecated, it used to be I would manually type in the file path and file name, and even someone deleted the existing file and replaced it with a new file, it wouldn't matter as long as the file name was the…

@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