-
Keep data in column as constant regardless of date
I have an ETL that includes a weekly upload of new information (employee name, quota, current sales) that is batched on Mondays. The quota is typically the same from week to week. When I use the information in a dashboard looking at last week, it doesn't recognize the quota since it's from the current week. Is there an ETL…
-
How to remove words from a drop down choice in Beast mode
Hi Team, I was hoping to have some assistance on this request on creating a beast mode. There is a custom field that we have and want to remove characters from the drop down choices and then also remove all the other choices as well. We have drop down choices: Access Carrier- Circuit Not working, Access- Carrier-…
-
formatting in a table
I have a table like this: Category | Actual | Budget Revenue | 4.50 | 5.50 Sales | 4,250.00 | 5,550.00 For this table, I have in a pivot table, and I want the revenue to be formatted with the ($), and the sales, I want to not have decimals. How can I do this in a beast mode? If I format this for the column on the card it…
-
Why is my data not being refreshed?
I have my app data flowing to a App DB data set where sync is enabled. The data is not getting updated and showing the last run as few hours ago. How do I make sure that my data set is updated?
-
MTD, MTD Last Year Beastmodes do not work properly with Date filter
I created 2 Beastmodes that I can drag into the 'Values' in the Pivot Table card: MTD = SUM(CASE WHEN Month = MONTH(CURRENT_DATE()) AND Year = YEAR(CURRENT_DATE()) THEN IFNULL(Amount * -1, 0) ELSE 0 END) MTD Last Year = SUM(CASE WHEN Month = MONTH(CURRENT_DATE()) AND Year = YEAR(CURRENT_DATE()) - 1 THEN IFNULL(Amount * -1,…
-
Changing Column Names for App Studio Forms
First time user of App Studio Forms. After submitting tests to see how the data would be captured I noticed that several columns were named Untitled_Field_x or had names that I'd like to change but can't. My first thought was that if I copied the final, finished form with all questions properly named and created a new…
-
How do I fix a string error with a date?
I am getting the below error and now sure how to fix. I run this data weekly, so I am assuming I have bad data somewhere.
-
Ability to schedule data refresh in Domo Google Sheet Extension
The Domo extension for Google Sheet is very helpful in cases where the users want the data from Domo in Google sheet. However, the only way to get new data is to manually refresh the sheet. If Domo could add a scheduling feature, it'll be very very helpful.
-
Bucketing different text fields if there is a match
I'm trying to count different text fields from a column called Reason and there are different reasons in that column. One row might have single or multiple reasons separated by a comma. Below are examples. 1) Reason 1 2) Reason 1, Reason 2, Reason 3 3) Reason 3, Reason 2 Beast mode using currently: CASE WHEN Reason LIKE…
-
Can we use Query Params for an embedded app ( brick converted to an app) ?
Can we use Query Params for an embedded app ( brick converted to an app)? I would need to collect the data ( Query Params) to my collection when embedded publicly using Query parameters.
-
Three Virtual Events This Week!
Good Monday, Community! 🚀 Get ready for an action-packed week of virtual events designed to ignite your curiosity and supercharge your Domo skills! Whether you’re diving into AI-powered insights or building apps that streamline your workflows, we’ve got something for everyone. You can explore all our events on the EVENTS…
-
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:…