-
Why cannot I public embed a form built through App studio, It appears blank when embedded.
I tried building a form through app studio. Is the functionality to embed a form from Domo app studio not yet developed??
-
Date Functions
hi All, Good Morning We can see some different lists of date - functions throughout DOMO. Under Beast Mode, you can see more Date Functions Under ETL( dataflow) page we can see a limited Date Function. Example DAYNAME() function. The dayname function can be seen under the the BeastMode page but the Dataflow page is…
-
Calculating Time difference in Seconds Beast Mode
Hello, Is there any way to do the difference between 2 timestamps in seconds using a lead function in beast mode. For example in below table take the first 2 rows 9:51:47 seconds subtracting with first row that is 9:51:14 seconds and output should be 33 seconds. The column is in String datatype. Can I achieve this using…
-
Defining Custom Color Palettes
It would be nice to be able to define custom color palettes to choose from. I don't mean the ability to set color rules on datasets or cards, or the white label features in embedded analytics. I mean adding your own palettes to the color picker for internal dashboards. Right now, having to use hex codes for everything is a…
-
How can I achieve this line chart
Hi, My data looks like this. My board has a filter for Team. When the user selects a team , e.g. Team A, I want a line graph by month displaying the following for each month. A line for the values for Team A, 5, 5 A line for the values for the region Team A belongs to (so in this case East, = 5+6 Jan, 5+4 Feb. How can I…
-
Waterfall Chart - Dynamic colour for first bar
The colour of the first bar in the waterfall chart does not seem to respect dynamic colour change. In our case, all positive values show green bars, and all negative values show red bars. The colour of first bar of the waterfall card does not change dynamically. In Pic 01, you can see that the first bar is Blue. Pic 02…
-
Sharing Alerts without Inviting to Domo
Hi, Is there a way to share an alert (e.g., this card has reached the target of X amount) with an external client without requiring them to be invited to our Domo instance?
-
Issue with onUpdateFilter in Domo Brick Card Not Triggering with In-Card Filters
I am working on a Domo Brick card to calculate data based on provided filters using the onUpdateFilter function. The filter update works correctly when filters are applied from the dashboard's top filter bar. However, when filters are selected from within the cards on the dashboard, the onUpdateFilter function is not…
-
Add Additional Contacts / Watchers to Support Cases
I'd really like to have the ability to add a user as a Secondary Contact or Watcher on support cases submitted by our team. Supporting a very large user base, my team can get bogged down by forwarding communication from Domo Support to the end-user and then back again. Allowing the ability to add more contacts which are…
-
Can you use SQL or Magic ETL to change the color of cells based on decreasing values?
Hello, I have a sales pivot table that I want to highlight when sales are decreasing. Is there a way to highlight a cell if it is less than the previous cell (basically if cells are decreasing month to month?)
-
How to form aggregate-of-aggregate values that can be filtered by card date ranges?
I am trying to create a table in Visualizer that displays how many customers have made at least 1, 2, etc. purchases as below. The original dataset is raw transaction data, and I've tried creating columns that display the "total # of purchases" by the customer for each transaction (aka each row in the data). This does…
-
From Campaign App Created a Campaign Using Cards from Page in App Studio
Does anyone know if it is possible to created a campaign from the campaign app using cards from a page from an app in App Studio? I have read through threads in the community and see that scheduled reports is not an option in App Studio. I wondered if creating an email campaign in the campaign app using cards from a page…
-
Search bar in Chart Properties
It would be nice to have a search bar for all chart properties so we can quickly search a particular setting we want to edit for a chart
-
Update rows on ETL output
I have an ETL that produces an output where one of the columns is calculated using a formula. The output is generated using the "append" method and the input moved from being all time data to only L4D worth of data. The problem I have is that, due to some business circumstances, I have to re-calculate that column but I…
-
P&L Card - Pivot Table
Hello, I am trying to create a P&L via DOMO pivot table card with our GL accounts. Everything works except the ability to show NET INCOME & EBITDA at the bottom. How would I go about this? I can use filter functions to show one or the other but cant see both at once. Is there a dynamic filter function or grouping beast…
-
Prior YTD Beast Mode Date Filter - Date based on MAX(Billing Date)
I'm having issue trying to generate a Prior Year to Date calculation based on the max of our billing date 1 year prior . We cannot use Current Date function since my dataset is not truly 'LIVE'…here is what I have so far: IFNULL( CASE WHEN YEAR(CALDAYFORMAT) = YEAR(DATE_ADD(CALDAYFORMAT, INTERVAL -1 YEAR)) AND RIGHT(…
-
Beast Mode Calculation with Data from another Dashboard
I have two questions: High level - survey data from one Dashboard 1 includes email addresses and a calculated NPS Score from all respondents. Dashboard 2 survey data may include some of the same respondents, identified by the email address. I'd like a Beast Mode Calculation that recognizes all email addresses in Dashboard…
-
PyDomo - DS_Update to Append Data?
Hello all, I've written a script that ideally will create a datastream into Domo. At the moment though, I'm struggling to find a way to replace the update method of ds_update() from PyDomo. The default appears to be replacing the data, but I need to append the dataset. Does anyone have any experience with this? Any help…
-
New Calculated Field isn't saving. Uncertain of next steps to save.
I'm unsure of what I'm doing incorrectly. I've created a calculated field, verified it, and checked "save calculation to dataset" but when I click the X to exit out of the Beast Mode editor, there is a warning that says, "1 tab has unsaved changes". Can someone share what I've missed? Thanks. UPDATE: I realized checking…
-
Alter Column: file to convert type String to Date
My current dataset has these columns: Jan 2024 | Feb 2024 | Mar 2024 | Apr 2024 ………. and so on. And I'd want my table to just have 2 columns: Date and Point So I used Unpivot tile, but I am unsure how to label my the new Date columns (number 4), so it will turn into a date format using Alter Column tile afterward. Do I…
-
How to show series of dates not closely tied to your data point?
Is there a way to show a series of dates in sequential order (either daily, weekly, monthly, etc.) without the date being closely tied to a particular data point?
-
Column failed to convert from String to Floating Decimal
I have a column that show 2023 sales as "$3,432.12" kind of format which DOMO identified as Text. However, I think I need to get rid of the "$" at the front before using Alter Column Tile to change it into Floating Decimal. How can I do that?
-
Move output dataset from one ETL to another
I'm writing a new version of the ETL that generates our Employee Directory. The existing output dataset from the existing ETL feeds dozens of other ETLs, hundreds of cards, and quite a few external systems via either the SFTP connector or directly through API calls. When I've got my new version all set I'm going to have to…
-
Reading Contracts and answering questions with data and AI
I need a way to read my signed contracts and have the ability to ask questions using my data. Example: Sources: 10 pdf contracts loaded & my support ticket dataset & financial dataset Question: Average support tickets per contract with maintenance? What is the average cost per ticket. Note: these PDFs are not in an…
-
Name Error when using domojupyter.ai
--------------------------------------------------------------------------- NameError Traceback (most recent call last) Cell In[30], line 167, in getRaws(alchemer_ids) 163 question_answer_dict = dict(zip(trans_df['Code\nQuestion'], trans_df['Original_Answer'])) 166 prompt_str = 'translate the following dictionary…
-
Not max characters but what is the highest number allowed in a field
Hello, I know the text fields have a max of 1024 characters in a field but what about for a number and a fixed decimal? I have a value of ###,###,###,###,### that is just displaying blank in a fixed decimal field. Any input would be helpful.
-
How can I format my Alert so that it displays the information in vertical text?
Hi all, Currently my alert just has an attachment and link for the report. I have a customer who would like to be able to scroll and see all the order info. The first picture is what I'd like to have. The second photo is how it is currently configured. Thanks in advance!
-
Mega-Ultron-Super-Duper Connected Dataset to rule them all
BLUF: Should I join/append all of our data so we have one workable dataset? This isn't a technical question, but rather theoretical. We've got data in many places (I'm sure this is common): Budget in XYZ Financials in ABC Stats in DEF Stats Historical (just switch systems so have a different datamart) in LMN Everything…
-
Individual Default Filter View
It would be nice to allow individuals to set their own default filter views. Right now, the only way to set default filter views is to set it as a default for everyone. It would be nice to allow people to select their own, if there's a certain view that they always use, so they don't have to go through the dropdown every…
-
Issues with Bing Ads Connector
Hello All, Relatively new Domo user here, I just established a connection with Bing Ads to start pulling in all of our stats for our Bings Ads and straight out the gate I am seeing some significant inaccuracies with the data I am getting in Domo. Has anyone else had issues with Bing before? I know sometimes there can be…