-
IN vs Not IN two different cards
Is there a way to create a filter in a dashboard includes only the selected value in a card and includes everything else but this filtered value in another card? for example, if I have 10 ids, one card should have the sales amount for the specific ID I'm filtering on and another card should have average sales of the 9…
-
Hidden Beast Mode Functions
Hello, I was wondering if anyone created a list of hidden beast mode functions like Partition By which is not shown in the function list, but it works when we actually use it.
-
What is the error in my beastmode?
I am trying to make an outlier flag that flags values 50% above of 50% below the budgeted, or daily goal mount. I made two threshold calculations(dailygoal / 2) & (dailygoal * 1.5). I keep getting an error message, but I am not sure what I am doing wrong. Any suggestions? Thanks, and my sql command is attached below. CASE…
-
Storage cost questions
Hello all, Just curious about something. When a dataset is created with lets just say 1 mil rows, but then later in the day it increases to 2 mil, and then finally before the day is done it is decreased back down to 1 mil, would I be charged on the 1mil or the 2mil? Does the calculation happen at a specific time of day and…
-
Percentage of values in a column
Hello, In the beast mode how should I get the percentage of column totals like below, 50 hours worked is the 12 percent of the total hours (410). I need to create a column like % Hours so that I can make further calculated fields based upon that. Provider Hours worked Total Tickets % Hours % Tickets John 50 20 0.12 0.10…
-
Domo Governance Datasets Connector - App Studio integration
This most likely is already on the roadmap, but would love for App Studio content to appear on the Domo Governance Datasets Connector.
-
SQL for calc fields that sum (data is flattened) are dynamic -- based on current year
Hi there: I need help creating these calculated fields (in Beast Model) where they change based on current year. I created this in EXCEL but am still learning SQL - any help would be much appreciated! calculated fields cy Sum `rtfs_amount` for each DISTINCT `Base Request ID`where `fsa_spending_year` is current year cy+1…
-
XLM data stream via URL
Any tips on utilizing an XML stream via URL? I can't seem to get any of the XML connectors to work.
-
Beast Mode Details
Beast Modes tend to be created to test an idea then abandoned. We have several cards with multiple Beast Modes that are not actually used on the card. We would like to see some level of Beast Mode tracking where we can identify those that have been created but are unused either on the card or embedded into another Beast…
-
Dataset Direct Impact Reporting
In Data under the Overview tab, there is a section called Direct Impact. This data is very useful when doing Dataset maintenance as it will give you an idea of how that data is used. We would like to see this data reported in Domostats | Datasets so it could easily be pulled into any reporting that might be highlighting…
-
Custom Date & Timestamp Formatting in Analyzer View of Cards
Hello Domo users! As a relative newcomer to this fantastic platform, I am thrilled to share my first discussion post with the greater Domo Community. I've been working with Domo for nearly a year at this point, and it has been a wonderful experience and I truly admire the insightful analytics and operational abilities this…
-
Search Bar
Add a Search Tool in App Studio so users can search for dashboards that they have access.
-
Pivot/unpivot help Magic ETL
I have a dataset which looks like this before i pivot it: But I would like for it to look like this. Please ignore the fact there are duplicates, for example 2 IHS rows, I can fix that in the etl. I just want to pivot it and I'm struggling on something which seems to be easy. Thank you
-
How can I have the data (text type) distinct counted in Analyzer?
I want distinct count for Y axis rather than count, How can I do it ? Thanks in advance.
-
How can I limit the data based on user?
Hi, I have two Executives who work for two difference regions (Asia, Europe). I have dashboards with all of the data. But I want to limit the data visibility for the executive based on the region. Person 1 should see only Asia data on that dashboard. Person 2 should see only Europe data on the same dashboard.
-
More query params for ListDatasets
Endpoint: https://api.domo.com/v1/datasets (GET) As a data engineer, I am trying to programmatically list multiple datasets using specific parameters. When I use the UI, I have multiple filters such as Last Run, Type, Owned by, etc. However, the datasets API only supports 'namelike.' It would be awesome if we can use the…
-
Concatenating amount and number fields WHILE also formatting them?
I am trying to create this as output in a cell: $50,000/ 2.0 year(s) This is my code: CONCAT(request_amount_recommended,'/',' ',Duration in Years,' ','year(s)') However, when I concatenate, I'd like for amount to be in US currency format and the number to be with 1 decimal. I get this "50000/2.014646 year(s)" Any help will…
-
Table formatting
I have a table with a header that is made of up 2-3 rows and some of the cells are merged (see sample screenshot). Is this custom header possible to create in DOMO?
-
Help with editing code that uses Filter allow
Hi there: BACKGROUND: I have data is a list of grants with organization name, grant amount, status of grant. I have Beast Mode code: SUM(SUM(requests_amount_recommended) FIXED (BY organizations_id FILTER ALLOW requests_granted)) I think it works - the issue is that it is summing TOO much. Ideally, I want to edit this code…
-
sec_to_time() Is adding an unnecessary period to durations
I'm using sec_to_time(`SessionTime`) to convert an integer of seconds into a duration however when a SessionTime should end in a single digit amount of seconds say, 5 seconds "12:45:05" the beastmode field is displayed as "12:45:5." This creates an unnecessary period and shows an inconsistent format. The result should show…
-
Drill within same card
Hello Folks, I understand the feature of Drill path. As of now, Drill path opens a new pop up window and displays the drill cards. But doing this, assume I have 10 cards on my dashboard, when I drill through, I lost the visibility of other cards. Is there any option to drill within the same card without opening a new…
-
Custom Filters - YoY, MoM, Last Year
Hello Folks, I understand we can do comparison in terms of YoY, MoM, Last year etc on a graph chart. But can I have those calc as Filters on the dashboard? Please guide me, Also can we add any other customer filters specific to scenario? TIA.
-
CSV separator but not
Ok so I have a string of data that has approximately 60 digits in it. There is no obvious delimiter - we just have to know the spot where to seperate. I am working in ETL and am essentially trying to do the SQL function where I start at a certain digit and end at another. I need to do this 7 times over so just using the…
-
Datediff in Redshift vs Magic ETL
Hi there! Im trying to recreate a calculation from Redshift to Magic ETL. Im running into some trouble with a specific formula. In Redshift: DATEDIFF('week',"start_date__c","end_date__c") In Magic: v1 - DATEDIFF(`end_date__c`,`start_date__c`)/7 In Magic: v2 - WEEKOFYEAR(`end_date__c`) - WEEKOFYEAR(`start_date__c`) Showing…
-
Workflows
Can some provide a sample workflow i can try to build ?
-
🛎️ UPDATE YOUR NOTIFICATION PREFERENCES
Notification are key to engaging with users in the Community. Some of you have missed important conversations, idea updates, or answered questions because of your default notifications. Please read through this article and update your preferences how you would like so you never miss a beat 😄 At the bottom of this page, I…
-
Image Not Displaying on Mobile App
Hello, We've connected images out of our private (Salesforce) instance to an HTML table and we're able to see the images (headshots) within our Desktop instance of App Studio and Domo - as well as in the mobile view on desktop in App Studio. However, the images are not populating within the actual mobile version of Domo /…
-
Random Number
What is the best way to try and generate a random number in a Beast Mode? I am doing a presentation and want to remove names from my column and just make a beast mode to assign a random number. I tried doing rand() but that was not unique. I also tried doing length of name * rand() but that was also somehow not unique.
-
Is it possible to upload many google sheets at the same time?
I have 30 sheets under a google sheet workbook. Can I upload them(30 sheets) in one time? Now via Google Sheets Connector, I can select only 1 sheet each time. I have the whole year data waiting to be uploaded, It is really too many manual workload. Is it possible to upload many google sheets at the same time?
-
What's the best practice way to remove data from a partitioned dataset?
We have an ETL set up to a partitioned output. Now that we are far enough into 2024 I'm being told that we can reduce the size of this dataset by removing all 2022 data from it. What would be the best way to go about doing this?