-
HTML Card | Background Color Style
I have an HTML Card that breaks down products by level. In my beast modes I have each level (0-6) set to a particular color as long as the number of accounts is > 0 otherwise it's set to a white background. My code seems to work for every level except for the first, 0, and I can't seem to figure out why. CASE WHEN…
-
Regex formula works in ETL preview but doesn't show up in dataset output?
I'm using the Dataset from Email connector to push a weekly email into Domo. The body of the email contains an account balance, which I'm trying to extract into a new field. The body of the email will always contain "Amount: USD 123,456.00" I created a regex to match what comes after the "USD " and before the next…
-
Workato - Pulling data into Domo
Has anyone successfully connected to Workato and pulled in admin report and data for system monitoring? Looking to connect from Domo into Workato. Assuming this is thru a Json connector, but need guidance and code if you have an example to work from.
-
Select multiple cards at once in design view to change background colors
Right now, I have to select one card at a time to change background colors to edit the design of them. I'd love the ability to select a bunch at once to do a mass edit.
-
Card Title font color & background color
How to color code the card title both font and background like we can do it in Power BI
-
Dashboard & Card Date Range Filter Reflecting Local Time
I would like the option to configure the Date Filter on dashboards and cards to reflect local time without having to change the company time zone setting. The goal is for options like 'Today' in the dashboard or card filter to reflect the device's local time without all of the additional effects of changing the company…
-
Unable to apply 'Next 10 days' filter
I was using this 'Next-10 days' in date filter yesterday and I can see the data, when I open today, I am unable to see the data. Showing an error message ' No data in filtered data range'. I have data for that date range but unable to see that in card(table).
-
Hi All, I'm new to domo and I've a question on Table joins.
I have two tables table A and table B. Table A is my fact table and Table B is a dimension table. I should do left join since Table A is my fact table. The issue when I do it the total bookings and capacity value in Table B is getting duplicated. I know this is due to many to 1 relationship. when I calculate Total bookings…
-
How can I remove duplicates with a beast mode?
I want to remove duplicates from 1 or 2 columns, whichever is the easiest. I prefer the match ID column, or it also could be the Candidate column. I want to count each match ID once per the PPED (period end date.) I want to get a active count of matches on billing each week. If i can't do with a beast mode, I can also try…
-
Treemap hover
When I hover over disclosures in the first treemap all the related items do not highlight correctly in the second treemap, both service Now Automation Platform and Policy Process Evolution should be highlighted. Both are using the same data source with no filters applied
-
Start and End Date Filter Card
Right now, there's is no Filter card available for Start and End (Between) dates. You can only have this particular option as a Quick Filter within a card but not an actual Filter card. This makes date range selection hard to implement for a dashboard view when you operate the filters using cards (there are specific…
-
Select all/exclude selection on filter cards
Ability to choose if you want to exclude a selection, or a select all feature on filter cards. Currently, with the multi-select feature, if you want to exclude one selection you must individually select every single line item one by one except the one to exclude. If you could 'select all' then deselect the one(s) to…
-
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:…
-
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,…