-
Cloud Amplifier - Incremental Load
I'm Running MAGIC ETL to Transfer Data from Cloud Amplifier dataset (connected to Snowflake view with about 200 million rows) to a dataset without any transformation. Every time it takes about 1 hour 20 minutes to fetch data from Cloud Amplifier dataset (S3LoaderAction) as it seems it is doing full Data fetch all the time.…
-
Copy and Paste HTML Bricks
Is it possible to copy and paste HTML Bricks using 'Save As.' I have tried multiple times to copy and paste my Nav bar to different Dashboards but it doesnt seem to work.
-
Beast Mode
Hello All, I am trying to find a better way to code this because I think the calculation may be faltering somehow. Alpha calculation is just a sum of amounts Beta calculation is just case pulling numbers from different fields. Mas field- what I am trying to achieve is simply to divide Alpha by Beta It seems to work somehow…
-
beastmode week start
I have a client whose week starts on Monday. since the default week start day in Domo is Sunday, I would like to use beastmode to calculate week numbers with a start day of monday. I get a validation error every time I try to input a number in the [mode] portion of WEEK(date,[mode]). I'm referencing MySQL 5.5 documentation…
-
Beast Mode
How do I use the name of an already calculated field or beast mode in another calculation. I learnt this nested ability was done last year. We are able to use the PDP new update but can't seem to get the nested beast mode to work. Exam: A=b+c B=d+e Why can't I write another beast mode F= A/B ? rather I have to write it as…
-
Amazon S3 Assumerole Advanced v2 Issues
We pull data from S3 using the S3 Assumerole Advanced v2 connector, and I'm having problems with it. There are three update methods available with this connector: Replace, Append, and Merge. We're bringing in employee data. Here's the problems with the three methods: I would prefer to use Merge, but when I choose it it…
-
Changing Dataset Name using Forms
Hi, I know this question is going to seem silly. I have a little bit of python knowledge from my college about a year ago. I am just playing around with the form ddx brick(Havent changed any code in it yet as I am just learning JS) . How do I change the name of the dataset? I've gone through the JS and I've tried changing…
-
How to setup Google Analytics Tracking on a Training App for GA4
I am attempting to track when Domo users take a course from CourseBuilder within Domo. I attempted to follow this documentation, but it is for Google Analytics UI, not Google Analytics 4. I have noticed there are many differences between the two, the main difference being there is no discernable Tracking ID. Is anyone else…
-
Getting "Domo is ready, but the requested file does not exist." File is unchanged, unmoved
I have a file that I'm bringing into Domo through our Microsoft Onedrive Business Graph API Account. Nothing has changed in the details of the file. It's been shared with our Major Domo account. The filename, type, etc is all matching. Yet it stopped working last week and there seems to be no apparent reason. This is…
-
Hamburger button on top left not working in edge.
When I move my mouse in EDGE to the button nothing happens. No fly out window… sometimes it blinks like it tried to work but never does. It works perfectly in CHROME. Any ideas how to fix?
-
Document ID generated by DDX Brick Form
Hi everyone, Does anyone know if the Document ID or ID generated by a DDX brick form is unique to the record (see screenshot below)? I can't see anything in the documentation on this. Thank you!
-
Dynamic Columns Line Chart?
Hey everyone, does anybody know if there is a way to either convert this to a line chart using the code in this brick or if there is a seperate brick?
-
How to alter a column in text and cast data type as integer?
How to alter a column that is in text and cast data type as integer or floating decimal? I get this error when using the Alter Columns tile: 'Failed to parse text ' ' from column 'Column A' as type 'Integer' How can I alter the columns data type in the magic ETL successfully?
-
Column Total Greater than Sum of ROWS
Why is "# Houses" Column Total Greater than Sum of ROWS on "Closed Punch Tickets by Plumber" Card BEAST MODE for "# of Houses": COUNT(DISTINCT(CASE WHEN JT158_WTParent = 'Y' AND HdrParentItemCode = 'ZPUNCH' THEN SalesOrderNo END))
-
DDX Bricks
I have a few questions about permissions for DDX bricks. Do I need these enabled to be able to edit bricks without getting an error message? Right now I am able to download them but as soon as I hit the wrench I get this message I brought up a week ago. Its on every single brick I download. The permissions I currently have…
-
SFTP in DOMO WB
I can connect to the SFTP on the server via FileZilla just fine but when I try to do it in DOMO WB it just keeps erroring. See screenshot. Any thoughts?
-
Calculated line on Bar Chart not the same as Summary Average
I am trying to figure out why the calculated line for a bar chart I am creating is different the the Summary Average of the same metric. Is this a rounding issue or something else? Thanks in advance.
-
Sum x for each unique y
Hi all I'm hoping you lovely people can help me sort the following out, please I have tens of thousands of rows of data which all repeat themselves (for boring reasons). There are 20+ columns but two are always a pair. I've used 'country' and 'value' here to demonstrate (see table below). All I would like to do is add up…
-
Governance Toolkit detects changes of users and groups
PDP Automation of Governance Toolkit detects changes of users and groups if the configuration datasets are not changed. If the configuration datasets are not changed, Toolkit doesn't execute jobs. But uses and groups are added after the execution of Toolkit. It is not reflected because the configuration datasets are not…
-
Data Science Access/Grant for Users in Magic ETL
We have users who use Magic ETL, but as admins we have users that should not have access to the features in the data science add-on. If there was a way to add a grant so we can revoke access to certain add-ons for users, this would be quite helpful.
-
Blank vs empty square
Hello everyone, I encountered these two fields in one of my columns ("blank" vs empty square), which is messing a bit with my formulas. Why is this happening? What's the difference between the two? Thanks so much!
-
Dataflow Version Clearing
I don't need all these dataflow versions. There should be a command to set the current as base and clear all old versions.
-
Multiple cases in CASE WHEN
Hello! I am trying to include a formula with three possible outputs based on three different conditions inside an ETL but I don't know what's wrong with my formula: Help is appreciated!
-
Column is Adding rather than giving Average
Why is AVG Punches Per House giving a total of Column and not Avg but PUNCH SCORE Column Total is giving AVG. PUNCH SCORE Beast Mode 10 * (COUNT(DISTINCT SalesOrderNo) / COUNT(DISTINCT sonum_wtnumber)) AVG Punches Per House Beast Mode (CASE WHEN HdrParentItemCode = 'ZPUNCH' AND JT158_WTParent = 'Y' THEN…
-
Determine user landing page by group membership
Hi Domo, Is there a way to change a user's landing page based on group membership? Assume that each user will be a member of one group. Thanks, NM
-
Trying to call accounts API from brick
I am trying to call the accounts API from a brick in JS. normally call datasets via window.domo. However, no such luck with accounts API. Need to be able to fetch account creds from storage in domo, for use in accessing external APIs. Anyone found a solution for this?
-
Card-based Alerts Email Notifications: Add direct link to card
Currently, the email notification for Alerts based off of a card contains a preview of the card that isn't clickable and a "View Alert" orange button that is clickable. When the "View Alert" button in the email is clicked, the user is brought to the card, but the card is obscured by the "Alert History" box that's…
-
Instagram and Facebook Dataset
Hi all. I'm working on bringing together our social profiles into one dataset that we can reference and visualize all at once. For example, I want to pull in all Facebook and Instagram Posts into one table so they can be viewed together. Same with followers / overall page engagement. Right now, I'm not finding that the…
-
Domo AI Models
Hi team, As part of Domo's new Service AI Layer, you can use ChatGPT as a model. Does Domo allow for the management of other models? For example like Copilot (Microsoft)? Thanks, Joe
-
Pfilters
Hi, I just watched Marks video about how to use pfilters so I thought id give it a shot with this beastmode. CONCAT('<a href="https://trimble-tt-16502962.domo.com/page/2050403531?pfilters=[', '{%22column%22:%22Lane%22,%22operand%22:%22IN%22,%22values%22:[%22', `Lane`, '%22]}', ']" target="_blank">', Lane,'</a>') The output…