-
MQTT duplicating data, eventually failing
Hi I managed to set-up the MQTT connector with our Siemens WinCC SCADA system. The data however keeps duplicating each run until it eventually stops transfering. On the Siemens side eventually it start getting errors and the transfer stops. In the image below you can see and example. The data being uploaded is only 3…
-
Formula to include only today's date + last 4 weeks of data
I'm in need of a formula that will allow me to pull only the LAST four weeks of "Ship Date" data so I can get a weekly sales average from said data. I've tried a few variations of trying to use the INTERVAL function paired with < = to no avail. I need to then take the sales average acquired from the above task and assign a…
-
Domo Governance Dataset Containing Card Filter Details?
Anyone ever found any Domo Governance or other datasets that contain information on card filters applied on the Analyzer side? (example screenshot below) Our analyst team is working on documentation and tracking what cards have certain filters applied on the Analyzer side before it's saved and shared with the end users.…
-
Solved ETL - Replace Null Values
Hi, I have a dataset with null values and text and I am trying to replace them with 0 and 1 respectively. But, when I try to write a formula using the conditions 'If Null' or 'If not null' I keep getting errors. Does anyone have any ideas? Thanks! Edit: I figured out what I was doing wrong.
-
Previous Week Amounts
Hello, the ultimate goal of my beastmode is to write a beastmode that will provide the variance week over week for total Net Cost. If you look at the attached picture, all I need is a beastmode that would produce the yellow column — the total Net Cost for the previous week. From there it'll be easy to then make a beastmode…
-
UKG Connector Report Path
I'm having issues with the UKG connector report path, the error I'm getting is "TypeError: Cannot read property 'ReportStream' of undefined" I don't know if the report path needs to be in some kind of format, the format from UKG is as following xxxx > xxxx > xx xxx I don't know if there needs to be underscores where there…
-
Why GA4 connector data is not matching with the platform?
-
User Functions in Domo Dashboard
User ID, Name details to be avaialble in domo dashboard to filter cards/dashboard based on the name.
-
Alerts
Can I back date an alert? My manager asked me if I can run a past date to verify the data is correct? Not sure when the next time the alert would trigger, so I’d like to see what the data looks like before moving to close. Not sure what this means. Thanks for your help!
-
ETL Change in behaviour
Hi, Just to help any one that runs into the same problem. I noticed tonight that TIMESTAMP columns with times set to 12:00:00am no longer join to DATE columns. This changed some time today. I have had to adjust the column within the ETL in the data handling section of the input. Luckily there was only a handful of sources…
-
Buzz Integration in App Studio
I'm wanting to integrate Buzz into an expense table to where accounting and the operator can talk about the data being used. I haven't been able to figure out how to integrate Buzz in App studio.
-
App Search Filter
I have an App that is tracking inventory information. I'm wanting to add a search bar to where it will filter the data down based on the part number. I found a brick add in that has more code than I'm familiar with. Is there an easier way to add a search "card" in the app to filter the whole page rather than using the…
-
Excel add-in
I'm having a very odd issue and would like to try to roll-back to a prior version of the Excel add-in. Is that possible? I'm not able to find how to uninstall the current one and then re-install the new version.
-
ETL Formula to extract numeric ID at the end of campaign name
Hello - does anyone know how to write an ETL formula to extract the numeric ID at the end of this campaign name: Display_Retargeting Package_07/09/24-12/31/24_BA:4114356 so that I can get a new column with just the campaign ID? Thank you so so much for any help!
-
Need ETL formula to extract numeric ID from campaign name
Hello - does anyone know how to write an ETL formula to extract the numeric ID at the end of this campaign name: Display_Retargeting Package_07/09/24-12/31/24_BA:4114356 so that I can get a new column with just the campaign ID (numeric string at the end of the campaign name 4114356? Thank you so so much for any help!
-
Transpose text in text box chart
Hi, how to transpose text in text box card in DOMO. I don't see option to transpose… TIA
-
User view time in a domo page
Can we extract how long a user has viewed a domo page. System Information
-
Allow Beast Mode as "Default Value" in an Input + Slider Variable
Hey guys! I think it would be really awesome if you allowed Beast Modes and/or Aggregations as the Default Value in the Input + Slider and Slider Variable Type (see screenshot). I heavily use variables to show how changing Win Rates up or down by X% would influence our End of Quarter Net Revenue Projections, and I think it…
-
Dataset from Email upload
I have a dataset which is uploaded everyday via email upload. Where can I find the path of this dataset in Domo so that I can import it to Oracle? Thanks
-
How to cancel a scheduled update from an ODBC connection?
Hello! A previous co-worker of mine set up a schedule to update a third-party dataset on a weekly basis using an ODBC connection. Said third-party has now changed variable names and made various changes to the data structure, so I fear that the next data update will fail and dashboards will be left with no data until we…
-
Training Videos
I've noticed several of you do training videos. I want to draw on your experience and knowledge of current tools. I have an extensive background in graphics, video, etc. So complexity of the tool doesn't bother me. I want to create a couple training videos for our staff on using our Domo dashboards, etc. It MUST be able to…
-
Beast Mode Question
I have a column called "Number of Units Beginning 2024" which shows the number of units at the beginning of the year, and a column called "Net Gain" which shows the number of units gained or lost each month. Is it possible to use Beast Mode to show the number of units at the end of each month?
-
Add a place to put a link to data source
I would love to have an area in the data connector where I could put a link to the data source. This could have the same visibility as the description/tags/owner/etc. For example, if you are viewing your Sharepoint datasets in the data warehouse, you could see the name, description, etc as well as a direct link to the file…
-
Average time to response but how do I not include weekends?
I am making a dashboard summarizing some trends with Jira tickets and trying to create a metric card that shows the current average time to first response, I am using this formula (which I think I got off this forum): CONCAT( case when ROUND((((86400DATEDIFF([CHART] Date of First…
-
Joining on table multiple times
We are working on building out our backend in DOMO and are trying to build a relational database instead of having individual queries for everything. We are connected to NetSuite through Analytics Connect. The raw table we are bringing in has columns for employee, service tech, service manager, etc. In NetSuite, these all…
-
Can I filter by latest date?
Hi all, I am working in magic ETL and I have a dataset that gets appended each month. Most of the data is useless for what I am trying to use, except for the latest month's set of data. Is there a tile in Magic ETL that lets me filter out by latest date? I believe I could use a rank and order but am trying to not use…
-
Beast Mode - Grouping
Hi! I am trying to fix this beast mode calculation to group properly. I need the time to group 12am-6am and then show 7am-7pm as separate lines and then group 8pm-11:59pm. The opened date column i am using is in this format '2023-10-22T07:18:17' which is why I am trying to use the beast mode, but the grouping doesn't seem…
-
Data Import Help
I have web app that will not share data. No APIs, not even export capabilities. I could use some help with ideas of how to make this work. Here is what the website looks like on the website: And Attached is an excel file where I highlighted and copied the data into an excel sheet in three different way (Paste, Paste…
-
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…
-
When are Beast Modes calculated and when to place in an ETL or leave as Beast Mode?
I have read several varying degrees of opinions on when a Beast Mode is actually calculated. I thought a Beast Mode, attached to a card or assigned to a dataset, is calculated at the objects rendering, regardless of if the Beast Mode is actually being displayed on said card. So if I have 20 total Beast Modes, some only…