-
JSON Connector that allows for entire dynamically constructed url?
I am trying to use the JSON No Code connector to dynamically pull data from another website. I've used this for other purposes successfully, but am running into an issue with the way the Domo connector inserts a "/" or "?=" in the url under the dynamic url and dynamic parameters settings. If I use the static url option, it…
-
Very Little Data from Google SDK Connector
I have managed to get the Google SDK Admin connector to connect to my good instance but I'm getting very little data. I have about 1000 users and for 'Customer Usage' I get 1 line per day with a parameter value of (for instance ) "105" or "209", and lots of empty Columns. I believe the delegations are correct, is there…
-
Installing R Packages in Jupyter in Domo
I don't seem to be able to install new packages in R in Jupyter in Domo anymore. In Domo the documentation, it shows an example of installing 'SentimentAnalysis' using install.packages(). When I try that, or any other package, I get this warning: Warning message:“unable to access index for repository…
-
Data in Email Subject Line
I get emails that the Subject contains the data I want. Is there any way as certain emails come in to have the subject line and date and time of email to be captured into a dataset? The email connector cannot do this.
-
Adding a prefix to all values in a column
I have a column named Division with integers ( numbers), I want to add a prefix 'Division' to to all values in the column to align it with all the values in the appended columns. What tile in Magic ETL would let me do this? I converted my integer column to text using 'Alter Columns' and now am waiting to replace the values…
-
How do I correct a data flow that has a "String" error?
I am getting the below error on a data flow that has been working well for months. How can I fix this?
-
Domo IDEAs Conference - Beast Modes - Number Formatting
Greetings! This is another post highlighting a beast mode from my Domo IDEAs conference session. This one covers how to format numbers a number when concatenating with a string. Problem: When concatenating a string with a number the resulting value is a string and unable to utilize Domo's built in formatting. Solution:…
-
HTML Card for Account Product Matrix
Hello, Back in March 24' I attended Domopalooza where a html card was utilized as matrix to measure domo account activity (picture attached). I would love to utilize a similar idea, but I am running into some issues. I have my ETL set where I have distinguished my levels to measure an account product matrix. I have been…
-
How do you change the value format of an Alert?
How do you change the value format of an Alert? Below is my Alert message preview. The actual format on the card chart is in "Percentage" format. By default, the "Current Alert Value" returns as decimal in the Alert Message. How do I make the "Current Alert Value" in "Percentage" format? Message Preview: Alert Trigger:…
-
Page filter add contains + allows "ORs"
When using a filter on card on a text field, you can use a contains "blah" as a condition. Great.. But then when you go to a Page filter, you can only select literal values (I know you can search and click "all" to get a similar result but it's not the same thing). I would like to be able to do this in a page filter too..…
-
Does domo allow a dataflow to run for more than 24 hours
I have dataflow that gets failed when it tries to completely run a dataflow that runs more than a day. Is there any solution. can the dataflow can run more than a day. Can anyone help me with this problem?
-
MS Office PowerPoint Variable Integration
Hey Community, We are looking to get some better integration with variables in the office plugins. Specifically, we are looking at the Powerpoint plugin, and we want to be able to bring in cards and dashboards that have Beast Modes utilizing Variables in the calculations. Perhaps something like you do for Filters, the…
-
Domo Sandbox Instances
I'm using a shared account to log into Dev environment (https://company-dev.domo.com/). In there, I've imported some datatsets to create 5 dataflows and eventually an APP in the Dev Instance. Then in Sandbox, I created 2 repo: Dataflows (5 ETLs) App It got pushed successfully. But my question is how can I see those…
-
Drilling from Table Card
One of the most common questions I answer from Domo users is why a drill doesn't work as expected on a table card depending on where the user clicks. For example, a user would look at the table below and click "200" to drill to transaction detail for Customer B. Instead, they receive an error message saying "An issue has…
-
Income Statement: How do I join 'Chart of Account' table & 'GL Records' correctly
I have 2 tables: Chart of Account - Right Table: notice that there are Addon Repairs, Restocking Charges, Contractor Discount in 'Cost of Sales Others' 2. GL Records (for all branches from Feb 2024 - Sep 2024) - Left Table Problem: I've tried both Full Join, Left Join (key: gl_account_id) then make a pivot table (filter a…
-
Data type of column changing from text to integer after import
I have a dataset column that has number and alphabets and is a text column while uploading. However after the dataset import it changes to integer and the text values become null in the dataset. Even if I change it in magic etl, it converts to text , but the null values still remain the same.
-
Can I move a variable to one column from another?
I want my Credit Type 1 to have just Position Owner or none, and Credit Type 2 to have Candidate Owner or none. Can this be done? I was trying the below SQL statement, but it is not working. SET Credit Type 2 = Credit Type 1WHERE Credit Type 1= 'Candidate Owner' AND Credit Type 2='none" I am just learning SQL, so still not…
-
Alerts in SPC charts
Good morning, Not so long ago, for the SPC charts there were alerts that trigger when the control chart rules were met I am not able to find that feature anymore when setting up the alert
-
Convert time to decimal
Good Afternoon, I want to convert my wrapup voice time to a decimal because I want to be able to use that number with interactions to be able to get my Calls Answered, is there a way to do that?
-
How can I change a cell that has not data to say "none?"
Hello, I have data set that I used the split column in magic ETL. If the column has a blank cell, I want it to say none. Is this possible in ETL or a beast mode? Below is the example, where there is yellow (credit type 2), I want it to say none.
-
Variables with Python Forecasting
Is there a way to use variables with a Python forecast model like ARIMA or Random Forest? I have a linear regression working, and I'm able to extract the coefficients, create variables, and use a Beast Mode calculation to generate a forecast. However, I'm unsure if this can be done with models that aren’t linear. Ideally,…
-
How can I mark a duplicate row instead of deleting it in magic ETL?
I use domo to handle metadata transformations for music tracks, and for publishing purposes it's important that I don't have any duplicate track titles. It can mess with the royalty payouts. So basically I want to mark a row as a duplicate based on specific values in columns/rows instead of deleting it. Ideally I'd love to…
-
How to Count the same record again with Multi-Selection Attributes
I have a multi-selection attribute with 19 selection options within it. I am trying to group these 19 selection options into 5 slices on a pie chart with this code: case when Impacted Business Division_p LIKE '%Biologics%' then 'Biologics' when Impacted Business Division_p LIKE '%CGT%' then 'CGT' when Impacted Business…
-
Filters not displaying all data present in the dataset used.
I have a dataset which is used for cards, when filtered by dropdown cards, even though the value exists in the dataset under same column, the filter is not working on all rows, even though the data seem to be existing in the dataset and working for other columns in the same row. What could be wrong here? The below have…
-
Multi-Select Variable
The ability to toggle a variable to be multi-select (in string type only) that will create a comma delimited string of all the values selected from the variable.
-
Add on option to Save Filter for Cards added in Favorites
I can save filters in the card added in my Favorites Can we have saving filters as well for cards in Favorites please
-
Is it possible to duplicate an entire dashboard and all cards on it?
Hoping there's an easy way to do this with just a few clicks, rather than doing a Save As on each individual card, then rebuilding the dashboard layout. Thanks!
-
Treemap colours
Hi, is there a way to colour the items one colour based on the group ? It does not seem to work.
-
Removing Duplicates and making sure only the one with the most recent move in stays
I am working on an ETL where I am transforming some unit rental records. I am trying to only include the most recent rental for the unit not historical data but the input dataset includes historical data. When using the remove duplicates tile I do not have control over which ones are removed or added as they arent…
-
What's the best way to pivot this table
The table on left is what I currently have, what's the best way to pivot in ETL, I also want to calculate the growth rate, for example the growth rate for A would be (110-100)/100 and second month would be (120-110)/110 How can I use pivot component in Magic ETL to get there and what's the fastest way to calculate the…