-
Line Break in Beastmode
Is there a way to write a beastmode that puts strings on the next line? For example if I have 3 fields (First Name, Middle Name, Last Name), I want it to show up like this… First Name Middle Name Last Name and not like this First Name Middle Name Last Name.
-
Sprinklr Infrastructure Update notification
Customers using our Sprinklr connectors might have received a notice from Sprinklr announcing an update to their infrastructure. The notice effectively says the domain for the API is moving from api2.sprinklr.com to api3.sprinklr.com, and asks customers to update their integrations to use the new domain. Domo will make the…
-
Modify the filter column values while drill down
Team, I have created the drill down using 2 different datasets and 2 table cards. While drill down, drill path filter should always consider the default column and pass the value of it to next level. thanks M. Vijay Antony
-
I want to set up an alert that counts the number of rows coming in from a connector
I want to set up an alert that counts the number of rows coming in from a connector such that if it is less than say 15k, then my team is sent an alert.
-
Sage Intacct: Customer Charge Card report retirement
On Feb 7th 2025, Sage Intacct will retire the endpoint in its API that powers the ‘Customer Charge Card’ report in the Sage Intacct Connector. As Sage Intacct will no longer store customer credit card information, it has not provided an alternate endpoint to use. On Feb 5th 2025, Domo will disable the Customer Charge Card…
-
Refresh Button Card to Refresh Domo Page in Embed
Hello, I am trying to write a Brick with a button to refresh the Domo Page back to the default load. I cannot use page filters to return to the Default Page Filters as my embed will not showcase these page filters. I saw that there is a button to refresh the Dataset on the click of the button (linked in this question) but…
-
Recommendation Needed - Import NetSuite Transaction Data By Last Import
I am looking for the most effecient approach to import NetSuite sales orders into a Dataset. I was able to get data imported with a SQL query with no issues. However, the dataset refresh is reloading all order data every time it runs. Is there a method where I can filter on createddate on the NetSuite transaction to be >…
-
Please show App content in user Profile
Admin > People shows me these options: However, App content doesn't show up in the list of Pages. I know there are now datasets to help understand App usage, but at a person level I would like some visibility into what they have permissions to see.
-
Tool Download - Google Slides
Do we have Tool download for Google Slides just like google sheets?
-
Year over Year Cards
Question regarding year over year cards. Currently I have a card that shows YTD vs Prior year and its working as expected however if I change the dashboard filter to be last 12 months, the card seems to stop working Since my "compare to" field in the card is set to "1 year ago" I was expecting that this card would be…
-
New Formula Functions in Magic ETL
Hi friends, Just a quick post here to let you know about a couple new formula functions that have been added to the Magic formula editor. Not a big enough thing to warrant its own product release, but just a little note here to let you know about them: ROW_NUMBER(), which would normally be used with an OVER clause, can now…
-
Month Name in Control is ordered alphabetically, how to get the Month in the right order?
I have a column 'Month Name' and set it as 'Display as Quick Filter' so that the end users can use the filter to pick the Month they want in a card. However, the Month is not in the right order (Jan, Feb, Mar, etc.). I'm not sure how to do it with Quick Filter/Control?
-
ACE Hands-On Webinar: Building Actionable Data Products in Domo
Hey everyone! I’m excited to invite you to a webinar I’ll be hosting on Friday, January 17th at 2 PM MST. In this session, we’ll be building an actionable data product from start to finish using App Studio, Workflows, Task Center, and Domo's AI Service Layer. Save Your Spot! [Register Here] I’d love to see you there and…
-
Are You Sure? Beastmode Safe Exit
After writing a Beastmode, I shouldn't be able to click outside of the dialog and have the beastmode completely scrapped. There should be a 'draft' option or a 'Are you sure you want to leave?' come on! This is basic UI stuff.
-
Allow users to rearrange cards in the appendix
Currently, you have to remove all cards from the appendix and then add them to the appendix in the order that you would like. It's extremely inconvenient when you have more than 2 or 3 cards in an appendix. It would be incredible if we could just drag and drop them in the order that we need them in while editing a…
-
Why are multiple "Send Email" blocks forcing all input fields to be required?
Hello! I am working on a workflow that has 3 parallel loops that will send emails. I added the first "Send Email" function to the first loop and was able to enter only the fields that I needed to (Recipient Emails, Body, and Subject), but when I tried adding the second "Send Email" function in the second loop, and all the…
-
Format Numbers at the ETL Level
Does anyone know if it is possible to change the formatting of a number at the ETL level instead of on each inidivual card? For example, changing a number that is currency so it shows up with the $ instead of just a number…
-
Provider Prior to Upgrade
I am trying to determine who provided the evaluation prior to an upgraded premium procedure. I have all the data I could ever need, but I'm not sure of the logic to make it happen. The task is made more difficult because there could be multiple evaluations prior to a procedure, and evaluations on different dates than the…
-
Make 1st letter of a field value uppercase in ETL
Is there a way to make the first letter of a value in a field uppercase? Not the entire word, just the first letter…
-
how do we know if our domo plan supports writeback?
and if it does not, what plan(s) do, and is there extra cost and how much? We were looking to use this: https://domo-support.domo.com/s/article/360043437093?language=en_US Brian
-
How to view the SQL query on the jobname
There are a few Jobs on the workbench that uses the sql queries to filter out some columns. I was able to identify the job name but where can i find that window for SQL? Thanks
-
FIXED () in Magic ETL?
'MTD' / SUM(
CASE WHEN Class 3 = 'Sales' THEN Amount ELSE 0 END
) FIXED () I have this BeastMode called 'MTD %' that calculate the % of each GL Account based on Sales (so Sales = 100%)And it was working correctly with different branches. Just wondering if I can create this in ETL?
-
How to remove all grid lines except for X & Y zero lines
The subject pretty much lays it out. I want to remove all gridlines on the visual except for X & Y zero lines. I use grid lines sparingly, especially on scatter plots, but sometimes I want to include the specified lines for esthetics or whatever but can't seem to figure out how to accomplish that. The closest I can get is…
-
Slack Data Connector
Has anyone created a dashboard from the Slack data connector that could share their experience?
-
Alert for Field Name Change (within a column)
The current set up involves a dataset that is updated once a day and this is then uploaded to DOMO for further use. If a field within a column is changed and there would've been cards that are filtered on this very specific field within a column, the cards will go blank. Has anyone counteracted this? Please bear in mind…
-
Convert a time to a number
I have a user that has his own dataset and I am converting it so that it is all done through an ETL but the issue is that he has a Average Handling time of 06:32 but he wants to see it as 6.32. I am have had to convert the times to decimal to work and then covert it back to time doing the following: SEC_TO_TIME(…
-
Variable connected to a Filter Card
Part 1: I created a variable that allows me to select a different field. I then use this variable in a control on the dashboard. Part 2: I am trying to use the control I created in part 1 to change one filter card that is connected to this variable. The goal is to have one filter card that changes based on the variable…
-
Datasets Running Twice with a Small First Run
For some reason datasets are running twice with an initial small run of <5 seconds that is considered an "API update". This affects ETLs which have their trigger set on "when datasets update" as well as alerts. What happens is that the ETL starts running off of the 2s dataset run above, after which it will run again when…
-
MTD Last Year, YTD, YTD Last Year with Rank & Window Tile
Say my dataset has these columns: branch_id, gl_id, amount, Month End Date, fiscal_year, Month Number I'm trying to recreate below SQL Window function with Magic ETL so that for every Month End Date*branch*glid combination has a corresponding MTD Last Year, YTD and YTD Last Year. SUM(amount) as 'MTD' SUM(SUM(amount) OVER…
-
Uploading Excel - Data Type Issues
When uploading an Excel document, where all of the data in the columns are formatted as "text", DOMO will change the data type to number, every time I upload it. I know there is an option to change the data type using MAGIC ETL, but here is my problem. In our data we have account numbers with preceeding zeros, for example…