-
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…
-
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…
-
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…
-
JSON No Code Connector Pagination with Sam.gov
The sam.gov API supports JSON pagination, but it's not clear if their API is supported with Domo's pagination options. Sam.gov does include a next link, but it includes a placeholder for the api key, which needs to be replaced. Domo adds the configured api key as another parameter, but don't see how to configure Domo to…
-
How to Flag/Color Duplicate values?
Hi, I have a list of contact information; one column is the Contact's Full Name. I am trying to set a rule where both rows are highlighted when two names are identical. Similar to how in Excel conditional formatting will color identical values.
-
Delete the most recent update on an existing dataset?
I loaded in a dataset A → Settings → bring in dataset B, Update method: replace (it's supposed to be append). So now I need to delete the most recent update, but I don't have that option since I'm not the Admin. I remember someone answered in a community post saying that in you can add some text into the Dataset History…
-
On card details pages, under the viewcount where users are listed as circles, how are they chosen?
I'm trying to prune unused cards. I'm an admin but don't think I have access to the activity log, I've seen it mentioned but the option doesn't exist anywhere. Some cards have hundreds of views, but the only avatar I see is my own. On other cards I see other people. Does this mean no one else has viewed it recently? Is…