-
Datasets Running Twice with a Small First Run
For some reason datasets are running twice with an initial small run of <5 seconds that is considered an "API update". This affects ETLs which have their trigger set on "when datasets update" as well as alerts. What happens is that the ETL starts running off of the 2s dataset run above, after which it will run again when…
-
MTD Last Year, YTD, YTD Last Year with Rank & Window Tile
Say my dataset has these columns: branch_id, gl_id, amount, Month End Date, fiscal_year, Month Number I'm trying to recreate below SQL Window function with Magic ETL so that for every Month End Date*branch*glid combination has a corresponding MTD Last Year, YTD and YTD Last Year. SUM(amount) as 'MTD' SUM(SUM(amount) OVER…
-
Uploading Excel - Data Type Issues
When uploading an Excel document, where all of the data in the columns are formatted as "text", DOMO will change the data type to number, every time I upload it. I know there is an option to change the data type using MAGIC ETL, but here is my problem. In our data we have account numbers with preceeding zeros, for example…
-
December Community Recap
Hi Domo Community! It was an exciting December and I hope each of you are ready for a new year! Check out our December recap, as well as this month's CMM. Feel free to like, agree, upvote, and comment on discussions you find helpful. Postitive reactions give points to the author to help them rank up. Catch up on the latest…
-
Data Freshness - Cloud Amplifier (Nov 2024 Release)
In the recent release Domo announced Freshness Check for Cloud Amplifier integrations. This tends to work perfectly fine for Snowflake Datasets and updates the data on the scheduled intervals but does not reflect 'Last Updated Time', in the Overview tab of the Dataset. [This was posted by DomoSupport, on behalf of a Domo…
-
Filter visualization on dashboard help
I have a dashboard that I added a donut filter to at the top containing Category A and Category B. Below it, I have a single bar chart with no series that shows the amount of new paid companies in a given week. At the bottom of the dashboard, I have a standard table with the complete list of companies. The intended…
-
Calculating country from lat long - latitude longitude
Hi, I have a data set containing lat long information, but I need the country information. Any idea how to calculate that in an ETL or Beast? I see there are lat long maps, which show the country information correctly, but I would need that in my table. Example: Location Longitude Location Latitude -149.5485 -17.7538…
-
Have Smart Text show exact time dataset was updated
By default, smart text shows the relative time a dataset was updated. For example, Dataset A was updated: 7 Hours Ago. Is there a way to display the exact timestamp instead of the time elapsed since the dataset update?
-
Have Smart Text show exact time data set was updated
Pretty straightforward. I want to show a datetime stamp instead of a relative time for the Smart Text that tells when a data set was updated. This is super annoying when users want to screenshot/export/whatever.…
-
App Studio Utilisation
It's surprising to discover that there is currently no method to track the utilization of apps created through App Studio. We need a mechanism to monitor this in order to determine whether the apps are truly adding value to the business and whether they are being used effectively. We need this asap as we see so far 290…
-
beast mode formula: Previous week compare to same week last year
Hi, I am struggle to get a beast mode formula to work for calculating the sum of same week last year, our business date start from Sun- Sat, i want to get the formula to only calculate previous week data e.g. today is 24th Wed but i want to calculate the week from 14th Sun -20th Sat DOMO says the formula for LY is…
-
YEARWEEK Function and Modes
Hello all - I am looking for some help with the YEARWEEK() function. I see that the function syntax is: YEARWEEK(`dateCol`, mode) where 'mode' defines the starting day of the week with '11' meaning Sun-Sat and '22' being Mon-Sun. I found this in the Beast Mode Functions Reference Guide but it doesn't expand whether other…
-
Duplicates
Hey guys, I'm experiencing duplicate fields on my data grid and trying to figure out how to remove them.
-
Filter on Job name in the workbench5
I have about 500 job in the workbench. Is there a way to activate the filter on he job name column so that I do not have to browse through every row? Thanks
-
beast mode question
Hello everyone, I'm having an issue trying to get this beast mode calculation validated. We have tickets that is suppose to be updated but we want to track tickets that are not updated within 4 hrs. And we want a color change when ticket is about to breach 4hrs with no update. I wrote this but getting syntex error. if…
-
Unable to Use SSO for Domo Mobile App in Intune MAM Environment
Domo Mobile App is not listed in "Microsoft Intune protected apps" and cannot perform Single-Sign-On with Microsoft Entra ID on mobile devices managed by Microsoft Intune MAM. Therefore, our employees are unable to use Domo Mobile App. We strongly hope that the Domo Mobile App will be supported by Intune MAM.
-
Mega Table Rank interactions with PDP
Hi all, I am trying to build out a dashboard that lets vendors compete with each other in a mostly anonymous way. One example would be a section that shows the logged in vendor their 7 Day Sales Rank, compared to their 28 and 91 Day Sales Rank. Key requirements: Vendors should be able to see their rank only; not any of the…
-
Why Is the Pivot Tile not Working as I Expected
I am trying to use the Pivot tile to accomplish the following (in my attached dataset), but am getting no results under the column I am creating (Weekend_Date_Pivot). Weekend Date should now be columns with Demand_Qty as the metric under each Weekend Date
-
Company Lookup on Different Columns
Hello, I am seeing if there is a way to write a beast mode that'll allow a user to input a company name that searches across multiple columns. For example, I want to look up Wells Fargo as the company name. I have three columns where Wells Fargo can appear under: Buyer, Seller, Lender. Is there a way to allow users to type…
-
Multiple dashboard filters
Hello, I have 4 dashboard filters on my dashboard.. Is there a way that once I select the first filter (for example account), that the other filter dropdowns are filtered? The issue is that the dropdowns are showing only the first 50 ish rows of data. So if I'm able to use the first filter, to filter down the data, that'd…
-
I am trying to delete a row from dataset
Filter rows in Magic ETL gives a new dataset with the filtered rows but doesn't delete it from the input dataset. I am trying to update the input dataset.
-
SMART or FORMULA BASED NAMING AND COLOR
2 ideas here… SMART TEXT OR FORMULA BASED (CONDITION BASED) NAMING This would be for columns or labels on charts. Instead of saying This year… it could say 2025 for example and change dynamically as the years change instead of having to manually change them in the system. FOR COLOR RULES: I would suggest having more…
-
Can I use a Beast Mode for Null/Blank Values?
I have two issues I am trying to solve. Company123 has a budget of 706.34, but there was no $ for this week. The cell is blank, so my formula is not calculating. The Budget GP-GP should equal -706.34, but it is blank. Can I do a Beast Mode, or even something in the ETL would be okay? Second issue is the 27,504.75 minus…
-
How can I set up a graph to show period over period data in a dynamic way?
I am looking for a way to show a bar graph with sales data by period and a growth rate line with period over period percent change. I have a detailed dataset with a large amount of sales data spanning over multiple years. I am having trouble with how to get the prior period data to be on the same line and to be dynamic so…
-
Optimizing a Domo Workflow for Sending Emails Based on Dataset Markers
I’m working on a project that involves sending emails to individuals based on specific markers in a dataset. Currently, I’ve set up a Domo workflow that iterates through the dataset row by row, checks certain conditions, and sends emails accordingly. While the workflow functions as intended, it is extremely slow. To…
-
Recent Editable Data Webinar question
@DanHendriksen Recently, I attended the Domo Hands-On Editable Data Webinar. Can anyone help me with the following question from the webinar? The second app was described as editable, allowing the approval status to be set and the priority to be changed. However, after submitting, the responses disappear and are no longer…
-
GA4 Connector append data
Hi I used the connector to bring 365 days of data into Domo from GA4 which took almost 14 hrs Now I don't want to use huge amount of credits on updating this daily. Was thinking may be instead I can append yesterday data only to these already pulled data. Any Idea how to do that? Appreciate your thoughts and solutions here!
-
Do Domo connectors work with MFA
I am hoping someone can answer this question. Do Domo connectors work with MFA? We have been using the FB connector to pull in reporting data but as of this morning it appears FB is requiring us to setup MFA for the FB account, we are using to access the data. My concern is will we still be able to pull in this data via…
-
How to re-subscribe a Domo emailed report recipient
We have scheduled reports that go via email to a number of recipients. One of them unsubscribed from the reports and now needs to start receiving them. The recipient does not have access to Domo; only to the reports emailed via the scheduled reports. As always, your assistance is greatly appreciated. Thank you!
-
Drill Down while maintaining breadth
I want to be able to interact with a card wherein the scope of the x-axis (time in this case) is sticky, but the series changes. Right now, if you drill down to a point on the x-axis, such as a year, it drills down to the year. Is it possible to drill "across" to a separate series? I understand that the Drill Down isn't…