-
ETL - adding a field based off a Case Statement Help
Currently we have an Access Query that has an expression created to add a field with a value to our data. Below is the expression written in MS Access N/P: IIf(([DWQRYDATA_DCINVAUD]![NEW_QTY]-[DWQRYDATA_DCINVAUD]![OLD_QTY])*[DWMIRROR_IMASTER]![ICOSTP]>0,"P","N") I need to add the same function to the ETL for my report I am…
-
Point New Dataflow to Existing Dataset
Is it possble to point a new Dataflow to an exsiitng Dataset? I have an exsiting dataflow and an exsising dataset, I have created a new Dataflow and want to point it to the exsising Dataset.
-
Magic ETL - Lower Case to Upper Case Join
I've got some extral data coming in via FTP that contains a key field that sometimes has lower case charcters. Attemping a join in Magic ETL and some appear to be failing based on case difference (lower case in one and upper case in the other). How best to fix? * Is there a way to format a field as UPPER CASE in Magic ETL?…
-
Replacement Variables in Amazon Athena Connector Queries
Hi, I am new to Domo and struggling with Append mode updates in the Amazon Athena JDBC 2.0 Connector. I have managed to get a base query running to pull data out of Athena correctly. Now, I am trying to parameterise the query to Athena to only append a subset of rows which have been added since the last time the query ran.…
-
Alert on status of dataset (SUCCESS or FAIL)
Hi, Is there a way, I can setup a alert to send mail if the dataset run schedule is FAIL or SUCCESS? I could only see batch_run_id and batch_run_date columns added in my dataset? There is no columns called status to check and add alert on it? How is this possible? Could anyone please help. Thanks, Neeti
-
Leap Year Fix
I noticed that our DOMO was pulling different trend %'s as compared to our regular route accounting software and in digging, I found it to be due to this year being a leap year. When we first launched DOMO, the developer put in a beastmode to use as a slicer so that it would look at sales through the last full business day…
-
Help with recursive dataflow
Hello, Experts, I am looking at creating a data flow that will constantly update data from a dataset while keeping a historical dataset in play. For this scenario lets call: * Historical Dataset (MySQL connector) - Dataset A * Update Dataset (MySQL connector) - Dataset B If you could, please let me know if I am on the…
-
How to set up a Future Date Filter
I'm trying to figure out how to set up a beast mode that will allow me to filter out historical dates while keeping the Date Range open to Current FY. I feel like I almost had it with the below calculation, but it's cutting off anything that is scheduled after this current week time period in future months: case when…
-
Conditional formatting of Columns in a table view card
We need more options to format columns in a card table view. In particular the ability to colorize a group of columns that are in the same category, ex. Admitted 2016, Admitted 2015 Admitted 2014, Inquiry 2016 Inquiry 2015 Inquiry 2014
-
How to calculate usage %
This is what I have: Content ID and Product are meta data for a full list of documents. When an user used a document, such as download, viewed etc, there is a record for Library ID, user role, and user region etc. When there is no Library ID, it means the document has not been used. Now the stake holder wants to see the…
-
BeastMode: Field contains lower case
Working on a exception report where item descriptions in our item file contain a lower case character. Logic would work like this: case when `Description` LIKE '%[lower_case]%' then 'Yes' else 'No' end Thanks!
-
Filtering beast modes using Card Start and End Date parameters
Hey Dojo! Long time, no talk. I'm back with an issue that's giving me one of those awesome tension headaches. Maybe y'all can help me out. I'm building an opportunity progression dashboard for our sales team. What the data looks like at the basal level is this: (Coming out of salesforce) Opportunity Name Record Insert date…
-
Sum and Avg calculations don't do anything
Hi all, I've been using Domo for a while now and consider myself a decent-to-good user. With that said, I have never been able to make anything useful with the sum and avg functions in beast modes. To the best of my knowledge, they are completely useless, or broken. Anybody else feels the same way? I would definitely…
-
Calculate average age till Last month, Last week, last year.
Hi Team, I am need to compare the average age for the current month and previous month . Now, the card that I am using to show this is comparative gauge which will display if the metric is trending up or down. So, I tried to calculate the average age for previous month in beast mode but did not work. Can anyone please help…
-
Extract 1 row / few rows from big dataset (>100M rows)
When I try to extract the _BATCH_LAST_RUN_ from a MySQL dataset with 106M rows, the ETL takes 3h20min. Is there a way to extract only one row from the dataset. For the moment, I have to wait until the full 106M rows dataset is load in both Magic ETL and SQL.
-
Finding the latest date with specific criteria
I work in the training area at my organization. We are trying to determine "What is the latest date they have completed all of their required training?" For example, a new agent comes in, and they are assigned Program A, Program B, and Program C. We want to know what the latest completion date is when they have completed…
-
MySQL query for YTD Running Total
Hi all, I'm having trouble creating a mySQL query that does a running total by a certain Group By dimensions. Here is a sample structure of the data: datestoreChannelVisitsYTD…
-
Role Permission needed for PDP Use
What permission is needed for a user to use PDP on a data flow? Our users do not have Can Manage Data Set or Data Flow because we update and manage them on their behalf. Is that what is needed to use PDP?
-
Surveys in specific Date Range
Good morning, I currently have a dataset being created from our Qualtrics connector that counts the number of surveys and averages scores from specifi questions in a given time period. The time period we go off of would be between the Last Day of the Quarter (Period End) and 180 days before the Last Day of the Quarter…
-
Magic ETL Efficiency
Hello, I have a simple Magic ETL that I use to filter a dataset from our company's source system to only show the latest version of each record. The dataflow finds the latest timestamp for each record, then uses an inner join on the record ID and timestamp to only include the most recent row. I've attached a screenshot of…
-
Floating integers / Floating decimals, rounding
How does DOMO's version of MySQL handle floating integers when rounding? I went to round a field in my Dataflow. So that I could avoid changing 50 cards and removing the decimals in this feild. Round(`Trans`,0) When aggregated in the card I am showing my total trans is far lower than it should be. opposed to a bit higher…
-
Beast Mode Manager Tab
Hi, I was reading an article about the Beast Manager tab (https://knowledge.domo.com/Welcome/Domo_User_Interface/Data_Center_Layout_(with_Beast_Mode_Manager)#Beast_Mode_Manager_tab). But when I am looking in my Data Center I cannot see it. Do you have any idea how to access it? Thanks!
-
FB Ad Creatives - Images in cards
Hey all, We are trying to make a table card and display the ad creatives for our FB ads, images in the table card. I have brought images into DOMO before however we are trying to find a configuration of the FB ads advanced connector that can do this. Is there any way to bring in the URL with the existing connectors?…
-
Beast Mode in Pivot Table beta
Hi All! I created a card using one of the new pivot table options. When I use a beast mode in the table it does not seem to be able to calculate the sub-total correctly. My beast mode is a simply divide field A by field B. Does anyone have a work around/solution for this issue that can be resolved in the card itself? Thanks
-
Actual Data to Budget Data
We have created a data fusion where we have actual metrics. Example count of registered donors in fiscal week 14. In the data fusion we added budget data to say we budgeted to see x donors in fiscal week 14. We are now looking for a solution to be able to display the two together in a grouped bar chart. Any help is…
-
Change Column Name in a Dataset
Hi Guys, Is there a way to change the column name in a dataset? I'm using Informatica to load in my datasets into Domo. I know you can create an ETL flow but the dilemma I'm facing is: I have a dataset (Dataset_A1) which had 4 columns, account | record | id | amount_given I created a dataflow to edit the column names &…
-
Use ETL to make calculated column a measure
Hi there I had a measure of DELAY expressed in words in my input file. This cannot be changed by me. I used beast mode to create a new column with the word changed to a number and I called this column DELAY2 However, this column is still be treated as a dimension And if i open workflow to change this in ETL, the calculated…
-
Rounding Decimals in ETL, not in Beast Mode
Hi there, I'm working on ETL right now, I want to rounding a column which is in decimal. Our a goal is create a new Data Flow from few files, then from that Data Flow make some cards. So, is there any help us to rounding in ETL Transform ? Thanks.
-
ETL Transform - Free Trail Version
Hello Experts, I am new to DOMO and trying to explore ETL Transformation. I am using a simple replace transformation and getting the error
-
Converting a beastmode text field into a number field
Hello, I am struggling to get the values my beastmode returns to display in the correct format. To summarize, I'm looking at blood draw times for donors. The data comes into Domo as phlebotomy start time, and phlebotomy end time (which are both date fields). So, I made the…