-
GA4 campaign and session campaign data Joining question
I have a unique question… some context: I have a dataset from the Google Analytics 4 connector that has 5 columns that I am grouping by with one of those group by columns being the 'campaign' dimension. The other dataset in the join has 4 of the same columns but the fifth one is a 'session campaign'. The two datasets are…
-
How is Timezone inherited from source then converted?
I have a dataset coming in from the Gong connector and some timestamps come in as text fields (scheduled, started). Our Domo timezone is set to Eastern. When I cast data type as timestamp, the times move up 3 hours. Should I assume the Gong source data is Pacific (Gong is in SF) and Domo is inheriting the timezone…
-
Group by when using case statements?
I'm trying to group the column 'opzegreden' into one line if the sum is below 5. I'm using the following beastmode which gives me not the desired result (see screenshot) case when sum(Aantal) <= 5 then 'Why' else Opzegreden end If I use the following beastmode then it does it work and does group.. case when Opzegreden like…
-
Calculating a final value from other selected values that exist in the same column
I have two columns—one column has revenue, the other column states which quarter the revenue was collected in. Is there a way that allows a user to select a quarter to calculate the difference in revenue between the selected quarter and another selected quarter. So, I am basically looking for a solution that would enable…
-
I want to create a column that contains the total sum of another column.
Hi everyone, looking to create a column that contains total revenue in order to find individual contributions. I have tried to do this using rank/window function within the magic ETL however all I get is a running total. Any help appreciated :) Thanks!
-
Error Message on Run when Using 'New' Data Selection
Hi all, I have an ETL with a View of a Dataflow as the input - data selection on input set to 'New' (Beta) then output is set to 'Append (Beta'). The input dataset is 250m rows going back 13 months, so I really only need the ETL to run on the latest transactions coming into the input, not on the whole thing. When I hit…
-
Calculating a final value from two selected values that exist in the same column?
I have two columns—one column has revenue, the other column states which quarter the revenue was collected in. Is there a way that allows a user to select a quarter to calculate the difference in revenue between the selected quarter and another selected quarter. So, I am basically looking for a solution that would enable…
-
Domo external Link to ADP
Hi , I am trying to create a link on associate id (Domo) when clicked on it would take to ADP (https://www.adp.com) and I have used this but it seems to be not working(just adding a link but its not opening up in a new window ) .Please if anyone can help ? CONCAT('<a…
-
Graph by Feature not visible
Does anyone know why the graph by feature appears in analyzer but not on full view of the card? I am noticing this is preventing the ability to change graph by at the dashboard level as well.
-
Azure Dev Ops Connection
Hi, I am trying to get data from azure dev ops. For work item type data. I have the azure dev ops connector but it does not provide me all the data I need. I have tried odata but that is not working due to auth errors. I have a case open to investigate. Has anyone used a different pattern beyond azure dev ops connector or…
-
Multi-tab input
Hello, I have a input data set that is a multi-tab spreadsheet. I used File upload option to import that to Domo. When I am using this in Magic-ETL, I am unable to specify the tab that I need.. What is the way to specify the exact tab I referring to in that spreadsheet. I need to use different tabs for different joins in…
-
SQL partition password reset
Hi - I put in a help ticket without success so far. We are using a SQL partitions connector to bring in accounting data. Following an apparent password reset on database access, some of the datasets continued to work while some larger datasets stopped working but continued to bring in blank lines of data. I reset my…
-
Aggregate counts over time that keep a running total
I have an area chart where time is the x axis, and count of instances are the y axis. I want the count to be a running sum over time, but I am not sure how to do that in domo. See my image for details. (I don't care about the trend line.)
-
I have two files as .xlsb in my shared google drive folder,
I wish to upload specific sheets of these two .xlsb files in DOMO, how to proceed?
-
Customising the Colour of Variable Selectors in the same way you can for filters.
I've recently been using Variables as a great way to control the content on a few of our dashboards. The functionality has led to some incredibly well-layered graphics allowing hierarchical drilling on all visuals simultaneously - GREAT! I have found only two drawbacks: Firstly, variable options are not easily dynamic.…
-
Allow for Min & Max in the Rank & Window Tile in Magic ETL
The minimum and maximum aggregation are standard calculations that should be included in the rank and window tile but currently are not. They should be added to avoid having to use a group by and then joining back to the dataset for simplicity and efficiency.
-
HTML image
How do we take an image and create a URL that is not protected? Originally I was storing the images we use in HTML code in a DOMO page that I created, called Image Library and I used the URL link from the image card. The problem is because this page has the permission on it that it can only be accessed by Admins, when I…
-
Email Notifications to Users
Has anyone ever had issues with users not getting emails from Domo? I have a handful of users, all from the same department, not getting scheduled reports. When I started looking into it I found they are not getting anything from Domo, no notification or reports. I checked their profile settings and notification settings…
-
How do I set up a connector for Lumar which uses GraphQL?
I'm trying to build a connector for Lumar(formerly Deepcrawl) but I am stuck. I've found my way to the custom connector in DOMO but from there I am lost. I have Lumar's API documentation( but I'm not a programmer by trade and no idea how to translate that into the custom connector. Any help would be greatly appreciated.
-
Dynamic Group governance data
Is there anyway to get the criteria that was used to create a Dynamic group as a governance dataset or somewhere in DOMO without having to open every group individually?
-
How to remove whitespace after a full name in ETL
I have a name column with a full name: example Bob Dylan and am joining to another dataset by name. I'm having issues and believe its due to extra white space after the last name. I tried using Replace text, regEx, \s, but that just removed all white space creating BobDylan. Any thoughts here?
-
Can I get the MIN date over a partition with a formula tile?
I need to walk a date column partitioned by the value of another column (UID) to find the earliest date for that group. I do not want to collapse the rows. I've tried a number of approaches to this with a SQL perspective, but I'm starting to think Magic ETL wants me to use a Group by. Here are a couple of examples of my…
-
I want to fetch count of data for a specific time frame (mon-fri)-(9-17)
I have data for all hours in a day, but I want to filter out data from only business hours mon-fri (9-17)
-
Defaults for Card Types
To keep consistency with how data is presented across multiple dashboards, you'll either need to have a template of each card you want to use with the customization you want to use by default, or be sure to manually recall what you want each one to look like. Would be great if by card type, we could customize some of the…
-
I am using this beast mode but it wont let me save the card
count(ID) over(partition by Clinic,Product)
-
GET private aws s3 json obj in the 'JSON No Code OAuth' or 'JSON No Code' Connector
Hi everyone. I am looking to get a private aws s3 json file in the 'JSON No Code OAuth' or 'JSON No Code' Connector but haven't been able to figure out the authentication to aws. Has anyone successfully done this? Any ideas on how to do this?
-
I want to add the Min, Max and average lines to a stacked graph ...how do I do that?
At the moment Min/Max/Avg is only available when you don't add series. Once you have series on a stacked bar for example you automatically lose your Min/Max/Avgs. Is it possible to add it?
-
Can I add users to a group without them getting an email notification?
I'm not entirely sure if I'm doing this the correct way, but in preparing for the launch of a dashboard, I was adding users to the Default group via Admin > Groups > Default > Add People then check mark next to their name, and Save. This is automatically sending out an email notification to the added users, which I don't…
-
Card Lineage
A previous question asked how to find the dashboards that use a given card. The answer pointed at using Domo Governance reporting. Surely there's an easier way to connect the dots. If I open a dataset, there's a "cards" link that shows me the cards that use the dataset. When I click on one of the cards…is there no way in…
-
Customer's Company email is changing what needs to be checked to ensure no issues after the change?
I have the steps to make the change using Bulk Import. But I want to see if there are other areas of Domo that will be affected that I need to check in association with this change to ensure no issues with the transition. Will SSO be affected?