-
Convert datatype in a BeastMode
I have data coming in from a sql table, and I cannot change the datatype of it at the source. I'm trying to join on the columns but it won't join on certain rows of data b/c One column is varchar25 and the other is nchar10 from the SQL Server side it comes from. They are already string, so when I use the Magic Tile to…
-
Trying to create visuals like PBI in DOMO
Hello, I am in the process of exploring Domo visuals and charting. I am familiar with other visualization tools but want to see how I can do the same on Domo. Can someone guide me in achieving the visual I have created earlier on other tool. Motto is to see, How I can achieve it. What are the major differences I benefit…
-
Coalesce for a missing month?
I can't seem to get a magic to work, nor can I seem to get a beast mode to work. I am sorting data by month. If though, my data does not have data for May (5) then I want there to be a row for May, even if there isn't data. Somewhat obviously, a case statement wont work because again, when there is no data, then no row.…
-
trx_week not calculating correctly when the week crosses years
I am having an issue where the days in the 12/31/2023 week cross into 2024. I am summing hours worked for the week, but it only returns half of the hours. I have tried creating a new column to concatenate the year-month using various formulas noted below, but I still get the 'The calculation contained a syntax error'. Is…
-
Avg Time Formulas
I am having lots of trouble trying to figure this conversion out.. I have an excel file that I am bringing into domo.. within the card (table format) I am trying to get the average (as the average column already existing cannot be properly summed within domo). I am trying to take the 'talk time' divided by 'call id count'…
-
Can the trade desk connector be used with MFA?
I am trying to set up the trade desk connector. Right now we are using an email connector to get the data into Domo but we have found accuracy issues in this method. I am running into issues with MFA in the connector. Has anyone successfully gotten this connector working with MFA enabled on the trade desk?
-
Installing R Packages in Jupyter rstatix
I am able to install some R packages in my Jupyter Workspace (tidyverse, ggplot2), but others I hit a wall, getting an error like: “installation of package ‘rstatix’ had non-zero exit status” Updating HTML index of packages in '.Library' The current one I'm struggling with is rstatix, which is a pretty popular library and…
-
Connecting to a large dataset available for download
Hi All. I am working with try and connect to a few HMDA data sets that are available and am not sure how to do so. I remember a consultant we had connecting to data from a federated data source but also, not sure if that is what we are needing to do. More specifically, we are trying to connect the Loan/Application Records…
-
Group By "Concat Distinct" Now Live!
I wanted to make a quick post to let you know about an update we made to the Group By tile in Magic. In your instances, you should now see the ability to choose a new options when defining how a column should be aggregated in the Group By tile: Combine distinct strings separated by , This allows you to create an aggregate…
-
Gauge Formating
Hi, I have this gauge that I am trying to add a target value to. The gauge I am using is Radical, however, it doesnt have an option for target value. I have tried to switch it to filled but I cant get it to look the same. Are there any settings or charts I am missing? Thank you in advance,
-
Regexp Match not validating
I have a magic etl with a Formula using REGEXP. It doesn't validate but I am wondering if I can even do what I'm doing. I want to extract all values between 2 string characters. Field Value (snip) DECODE(TRUE, IN(LTRIM(RTRIM(deposit_account_type__)),'410'),'Brokered', IN(LTRIM(RTRIM(deposit_account_type__)),'411'),'CDS…
-
Issue with the Microsoft PowerPoint Add-In // PPT changes file size when cards are refreshed
Hi everyone, Our team is facing a weird issue and we do not know why. We have three members in the team and one of us has the issue. Most of the times, when our member with the issue refreshes all cards in the PowerPoint, the size of the PowerPoint increases from 11 MB to 23 MB. Due to this, the exported PDF is 23 MB big.…
-
Map Pin Sign and Auto Zoomout Option for the map
There are two issues that I would like to raise here with the Product Team. I have checked with the technical team, and I have been told to direct my idea here (refer to case # 05867714), as the current asking is not available in DOMO. In a map locating different cities by coordinate (Latitude and Longitude), I want to use…
-
Array Function in Beast Mode
Hello, I created a card where users can filter multiple IDs at once. This is useful to quickly filter the card based on the account IDs that we got from another card. Users can simply highlight all the Account IDs, copy and paste them in the Input Text Box The variable is called enter_account_ids. Is there a better…
-
beast mode
Hi community, I'm new to domo and need some help. I have a simple data set (see below). I want to only view rows that have an order date. if it's blank, i don't to see it. I was hoping to use the filter but I can't figure out how to exclude blank dates, i only get options to filter by various date ranges. Or, what would be…
-
Data transformation Question
I am working on a report where the data looks like below (sample data): Services : JAS, GAF and YAG fall under the profit center "ABC" and HIG and OPD falls under "XYZ" Date Profit Center Service 1/1/24 ABC 1/1/24 JAS 1/1/24 GAF 1/1/24 YAG 1/1/24 XYZ 1/1/24 HIG 1/1/24 OPD I want my final output to look like below, there…
-
Returning all the same value.
I got this code to work, well kind of. Its only returning 110 CASE When Actual bid 2 >2700 THEN 120 When (model LIKE '%250%' OR '%2500%' OR '%350%' OR '%3500%') THEN 110 ELSE 110 END Tried this CASE When Actual bid 2 >2700 AND model LIKE '%250%' OR '%2500%' OR '%350%' OR '%3500%' THEN 110 when 'actual bid 2' <=2700 then…
-
Change chart sort order based on variable value.
Hi, I have created a variable that I am using on the y-axis of a bar chart. With the toggle letting switch between categorical and date values. I would like to be able to alternate how the y-axis is sorted based on which variable value is currently on the chart: Date values: The date values are calculated by year and I…
-
Is there a way to "freeze" data in domo to compare net new information to previous information?
For example: I have Promo X that has been running from Jan – Dec 2023 and I can see the impressions for that time frame with no problem by filtering to that date range and looking at the data for that date range. | I’m now running Promo X in March 2024, and want to look at net new impressions to this promo in March 2024…
-
I need syntax help. Bit of a newbie trying to teach themselves IF/LIKE/OR
The specific task is to identify if a truck is a F-250,350, 2500, or 3500. The Column is "model" that I'm looking for the partial match in the model column. I keep getting syntax errors. CASE WHEN `model`LIKE ‘%F 250%’ OR `model` LIKE ‘%F-250%’ OR `model` LIKE ‘%F250%’ OR `model` LIKE ‘%E-350%’ OR `model` LIKE ‘%E-250%’ OR…
-
Expanded Options for Dataset Alerts
Datasets often require monitoring that is complex. My idea is to make the dataset Alerts more dynamic, so that an Alert could be sent in case the dataset row count did not change, or if another undesirable outcome occurs. We occasionally experience an issue where the dataset updates successfully, but the row count does not…
-
Planful Connection?
Hi All, Asking here as well as on the Planful forums. We use Planful for our FP&A planning process and monthly financial reporting. Insert lots of data dumps and visualizations in excel here. Has anyone successfully integrated Planful into Domo for visualizations? Did you use a custom connector or did you find a work…
-
January 2024 Community Forum Highlights
2024 is starting strong with an amazing first month for the Domo Community! It’s time to recognize the amazing contributions you all made and celebrate some outstanding individuals. Over 120 questions received answers, and the average response time was 25 minutes. Thank you all for continuing to solidify the legacy of this…
-
Trying to understand why a line Bar behaves the way it does
Hi, I am trying to understand why a line bar is behaving the way it does. I have a bar chart that is correct the field is summed. However, as soon as I add a line bar it seems to sum each column before it. The aggregation for the bar is the same (sum) and for the line ive tried every aggregation to try and get it to look…
-
Clear all fields option in Analyser
Could we have an option to clear all fields in Analyser? Whenever a new card is created Domo 'guesses' which fields to include, this is never what we want so a quick way to remove all measures and dimensions would be a big help. Alternatively an option to diable the automatic population of data into the worspace would…
-
Lock size of cards in a dashboard when using autowidth layout.
Currently the size of cards dynamically change based on the viewer's screen settings, and when a user has zoomed in quite a lot, the cards reduce or can sometimes not show at all. It would be great if there is a way to lock the size of cards in a dashboard when using auto-width layout.
-
Calculating Differences based on the Value of a Column
I'm trying to solve a problem where I want to compare the average of two columns based on the value of another column. A simplified version of my data table looks something like this: Score A | Score B | Score C | Survey Type 10 | 20 |19 | pre 14 | 26 |23 | post 7 | 6 |8 | pre 10 | 10 |12 | post I want to calculate the…
-
Outlook Calendar
I know that Microsoft 365 has DOMO capabilities for all platforms but looking for additional data coming from Outlook. I am aware you are able to add cards from DOMO into Outlook but looking for adding a shared calendar from Outlook into DOMO. I don't believe there is a way currently where we can feed data from Outlook…
-
Download Line chart forecast values as an excel or csv
Currently, when I create a line chart forecasting values into the future, I am able to see these values okay on a chart. However, when I try to export the chart in excel/ csv format, the future dates disappear and I can only see the actual values corresponding to historical dates. Will it be possible to download this as an…
-
Unable to Save Card
I've never seen this error before. Anyone know what would cause this to happen to the save button when building a card? It won't even let me click on the save button.