-
Stop a Dataflow That is Running
As you can see from the screenshot I have a dataflow that has been running for 16h+. Nothing in it is that advanced so I'm not sure why it has been going for this long but either way I want to make a change and rerun it (put it back to the version that took 4 minutes to run) but I can't find a way to stop it. I set the old…
-
Last 7 days COUNT for each day
Goal: I want a total COUNT of rows for the last 7 days, for each day. Meaning, that I have Ex. a line graph where the point for 5/22 includes the previous 7 days (5/15 - 5/21) and the point for 5/21 would be the total of 5/14-5/20 and so on. Context: I append data every 15 minutes to a dataset that shows the current users…
-
OData Connector or a workaround?
Other BI tools (Tableau, Power BI, etc) offer connections to OData sources (see hyperlinks for related documentation for each tool). I was wondering if Domo has any plans to support that in the future OR if anyone here knows of a different way to get to the data? I'm not sure my specific use case is important for this…
-
Alert Each Time a Row Enters Alert Criteria
I'm trying to figure out the best way in Domo to alert one of my users and I don't believe the actions available to me are what I need. Before submitting an idea suggestion I figured I'd ask here. Scenario: * Project Management is tracking the hours spent on a project and wants to get notified when a project reaches 25%,…
-
Single Value Card Limited to 25,000?
I have a single value card that shows the total tickets we have in our IT Help desk tool which is basically just a count of all the ID's for each ticket, and each row is unique to one specific ticket so the total rows is the same as a count of all of the ID's. I noticed that the card now has a caution symbol on it and says…
-
Calculating on a calculation
Couldn't think of the best way to title this but the description should make it clear. The calculation I need to do is a basic one but doing it isn't as straight forward as it seems. I'd like to calculate an average of the total work a team gets done in a set period of time and if you're familiar with the software dev…
-
Transform Timezone for Entire Dataset
I've been incorrectly bringing data into a dataset (appending) for months now assuming it was coming in as UTC and then Domo converting it to EST. However apparently the data was in EST the whole time and being incorrectly represented in Domo since it was being converted. I know I can add the transform to the Workbench job…
-
Anyone Using the New Relic Connector? Setup is Confusing
I'm having trouble with the various connector options for New Relic. For example, when I choose the Application Metrics report and choose my application it doesn't really recognize any Metrics nor gives any guides as to what to put in there, the help icon just says "Enter a metric.", when I enter something like Database or…
-
Problematically Replicate Exporting to Excel in the UI?
I know I can use the API to pull data down from Domo which would allow me to do manipulation to it but my goal would be to replicate what data shows on the card, the same data that is returned when you do a manual Export to Excel in the browser. That's what I would want to access programatically, not the whole underlying…
-
Workbench 5 Connection String has not been initialized
Putting in the connection string when connecting to a source like OLEDB, more specifically SQL Server, has always seemed finicky but now with Workbench 5 I'm having an even more hard time. I put it in as the whole string at once, it fills in the fields on it's own such as Catalog = , Data Source = , Username =, etc. I hit…
-
Creating an arbitrary date field unrelated to data to hold every date that exists
I'm trying to recreate a chart that compares Created to Resolved issues (based off JIRA data). How it looks in JIRA below Where i'm running into trouble in Domo is that I think JIRA just creates a random new date field/range on the fly that isn't included with the data when pulled over. In Domo I have to choose what field…
-
Remove Duplicates for Append Before it Gets to Domo
I have some data i want to bring in but unfortunately the source data is a "Keep most recent X records" not a "Keep the last X days records". One option I know would be to just append it daily and then have a dataflow that removes the duplicates and it would give me what I'm looking for, however this would mean my original…
-
Recreating Excel's Pivot Chart "Show values as % Running Total In"
I'm trying to recreate this Excel Pivot Table in Domo (Currently as a Heat Map but if someone has a better suggestion I'm all ears). (See "Domo - Pivot 1.JPG) The good or bad thing is I can select the data from the database however I want so I'm free to do calculations before the data gets to Domo but the basics that make…
-
Upgrade to 4.62 Can't locate DomoWorkbench.msi
I downloaded the .exe from Domo Admin tool downloads and installed it which did upgrade the Domo Workbench Monitor to 4.62 however I ran into an issue when I believe it is trying to install the newest version of Domo Workbench, see attached screenshot. I'm not familiar with this sort of error, is it claiming that when the…
-
Custom Sorting Using a Field (Specifically Sales Funnel)
Not sure if this is possible or not. Basically I'm taking a a list of Sales Opportunities and putting them in a funnel by stage (Count) that way is shows how many opportunities are in each stage of the Sales Process. The thing I'm having trouble with is getting them sorted from beginning to the end vs alphabetical. The…
-
Suggestion for how to handle not having dynamic queries
I'm looking to see if anyone has run into a similar issue and to see what you might have done to combat it. Dataset 1: Information regarding a file running through a system (FileId, date process, type, file name, etc) Dataset 2: Information regarding any errors that occured during processing of the above information…
-
Custom Connector how to choose which JSON node to pull data from
I'm creating a custom connector and the JSON format follows this pattern {"code":0,"message":"success","data":[{"website":"https://redactedwebaddress","monitor_id":"15223002603958004","use_ipv6":false...............etc When I attempt to parse the JSON it returns code and message data however I would like to start pulling…
-
Alert Not Showing Same as Card is built
My card is a heatmap card with a row for different accounts and columns for the last 12 months of data grouped by month. I have an alert set on it so that if any accounts most recent month of data = 0 to alert on that. However somehow when the alert triggers I get results from the same account multiple times. Example (What…
-
Error: Table in Dataflow "doesn't exist" but it does
I have two transforms with output tables that I select from to create a new dataset however the system tries to tell me the table doesn't exist and I'm not sure why. Is there some sort of limitation that I'm not understanding?
-
Sort by Last Column in card (heatmap)
I feel like this one is an easy one but I just can't think for the moment. I have a heatmap that shows data over time. I want to sort so that the highest number for the current (or last month of data) is descending from the top. If I do a normal sort it puts the first month in descending order, I just want it to be for the…
-
Create a Letter Grade or Number Grade Based on Multiple Fields
I'm going to experiement with using the calculated field to create what I might call a Health Grade for our customers. Short Context. People can send us data. The data can process correctly or a % might fail. I summarize this % per month for each account. I would like to do something like taking the %fail data and…
-
Best Way to Represent Dates as Columns in Table
First time I've come across a requirement like this. The goal is to see each month and have a calculation of the variance %increase or %decrease for that month and highlight them when it's a certain amount. The table view isn't necessarilly a requirement but the series contains over 200 records so i'm finding it hard to…
-
JIRA Cloud Failing for Last 7 Days
Not sure what's going on, my JIRA dataset has been failing for the last 7 days with the following error: Domo is ready, but Jira failed to return the requested data. Please try again later. It's not that many rows (~10k) See screenshot for the history When it first started failing (Aug 19) it was due to a JIRA password…
-
New Analyzer - Date Dimension not Showing
All, I have an Excel sheet that I'm pulling in. Now the data in Excel doesn't have a proper Date field as the query for date is year/month so the data shows as Ex. 2017-07. So no date fields technically don't exist in the dataset, to get around this I used a Beast Mode to turn that column into a Date field (just made each…