-
Can you filter data from input dataset in a MySQL Flow
Hello, I have a dataset that has data for the past 20 fiscal years. I use it in a flow that only looks at the last two fiscal years and when the flow runs it takes a good 10-20 minutes just to read the data in the dataset and then start transforming it. I was thinking of expediting the loading process by pre-filtering the…
-
How to find all Flows(MySQL) that contain a specific string
Hello, I need to find all MySQL flows that have a specific string somewhere in any of the transforms or final outputs(these are all My SQL scripts). There is a data governance dataset for Beast Modes and you can use that to find all BMs that have a string but for dataflows, although there is a governance dataflows dataset,…
-
How could we implement a SQL Flow that would split lines based on certain logic
Hello, I have an ask where I need to split lines when there are multiple Users working at the same time in order to accurately count how many users are working together during a certain interval. If I have 3 users working each one during different periods I want to split the Initial rows as per below picture. If I am able…
-
Domo Workbench executing jobs on a Group Schedule multiple times
Hello everyone, I have multiple Workbench jobs that run on a 4 hour schedule. What I have noticed is that when the jobs run, they run 4 times one after the other like they are trying to catch up to the fact that they did not run in the past 4 hours and now running 4 times they look like they they caught up for an hourly…
-
Freezing card at end of Fiscal Year
Hello everyone, I was curious to know if there is any mechanism in Domo where I could freeze the content of 50 cards that are part of the same dashboard so that on the last day of the Fiscal Year we "freeze" the cards and the dashboard and then the data would become static but obviously with drill down capabilities. It is…
-
Could not refresh dataset - Other Provider
Hello, I have a legacy dataset inherited from a former developer and there are a few strange things that I notice. First, it says Other Provider. 2nd the message could not update but I cannot force an update. The source file is an excel document on the network drive and the file is there. The refresh run fine until…
-
Dynamics 365 Emails - From, To and CC
Hello everyone, I am trying to build a dataset based on emails coming from Dynamics CRM. I am using the right connector and I was able yo map pretty much all the fields I needed through joins with other entities. However, I am having trouble figuring out the From, To and CC fields and for emails they are quite relevant…
-
Domo Workbench executing jobs on a Group Schedule multiple times
Hello everyone, I have multiple Workbench jobs that run on a 4 hour schedule. What I have noticed is that when the jobs run, they run 4 times one after the other like they are trying to catch up to the fact that they did not run in the past 4 hours and now running 4 times they look like they they caught up for an hourly…
-
Allowing change of Account on dataset if even if account is of different type
Hi, We have two Domo Data accounts (Data/Accounts) under created under the same SSO user. They both point to our Dynamics 365 CRM environment. One is of type Microsoft Dynamics CRM and the other one of type Microsoft Dynamics CRM OAuth. We want to switch some of the datasets (and eventually all of them) from the first data…
