-
Beastmode | All seperate rows instead of one summed row
I've the following beastmode: case when DATEDIFF(Select Columns.Date,Date) >0 then sum(Select Columns.Totaalprijs)/COUNT(DISTINCT Email) else 0 end But instead of one row I get multiple rows. I tried adding 'sum' to other places in the beastmode but I'm receiving either an error or the same result. Can someone shed a light…
-
All cards using federated data sets and using filters are broken
I woke up this morning and all of my embedded dashboards were broken. After some analysis it looks like any card on a federated dataset that is also using a filter is not rendering. These are embedded cards using programmatic filters below and none of them are currently rendering. They were all rendering properly…
-
Adding a new dataset after creating a Custom App
Hi all, I created a custom app in Domo and originally when it was created, it only had one dataset in the manifest.json file "Cars." I wanted to add another dataset to the app and so I modified the manifest file to include "users" - Screenshot 1. I confirmed the new dataset is reflected in the brick - Screenshot 2. In my…
-
How to Setup UKG Connector?
Hello, We are trying to use the UKG connector, but it is not clear what all the fields are. Username: I assume this is a service account name? Password: I assume this is the service account password? Client Access Key: Not sure where to find this. User Access Key: Is this generated by the user account in UKG? Service Host…
-
ETL to Track Weekly Contracts
I'm trying to connect two datasets to track contract fills per week. The screenshot is from one of the two datasets and it includes the contracted amounts of each commodity and the Start/End dates of the contract. The second dataset has data pertaining to the amount of cases actually received per day (which I have…
-
Ability to see exported files/chart/images
Today, we cannot see which files are exported from Domo. We can only see the name of the file/chart/image but have no idea which cards they correspond to. This is a MAJOR security flaw that puts companies at risk
-
Export pivot table as shown on the card.
Currently exporting the pivot table to CSV/Excel does not generate a Pivot table but exports the rows of data. Users have to manually generate pivot table again with the exported data, which Domo should have done as a reporting tool.
-
How to join the Community Forums: Step by Step
Have you been a content consumer instead of creator on the Community Forums? Creating an account is really simple and allows you to engage by asking questions, starting discussions, and collaborating with other users. The Community greatly benefits from each contributing user. Follow this guide to sign up and get started…
-
MTD and YTD TOGGLE
HI Team, I have a date field and what I'm trying to do is write a beastmode that looks at YTD and MTD without years. I have successfully done that in 2 separate beastmodes to give my a 'Y' or 'N' toggle. However when I try to combine them into one where the user can toggle 'YTD' or 'MTD' the 'MTD' isn't the issue.. it's my…
-
Pivot/Group By - Make Multiple rows into one row and add columns
Hi Community - thanks as always for the consistent great help. I'm attempting to Group/Pivot/Join/Append (not sure exactly what the methodology will be) multiple rows of Patients into single rows with additional columns. Right now, each patient event is on it's own row. So, a patient seen on Monday and then also on Tuesday…
-
Help create ETL
Hello. I have 3 cards in my dashboard. Can anyone help me create an ETL for the 3rd column only, please? Here are the details and filters for each card: Card 1: Company Name not in 'MR' Destination contains 'MR', 'TC', 'L', 'NP', 'PP' show count of ID ——————Card 2: Company Name in `MR' show count of ID ——————Card 3 (here's…
-
Auto-re-run stuck Dataflows (A cap time-duration to identify faliures )
A customer via product feedback, would like to request that Domo add the capability to detect and auto-restart dataflows that stuck in the update process. So I thought I should post it here on behalf of them. "If a dataflow is taking 10x longer to update than normal, something is wrong. This type of silent failure is…
-
June Community Recap
Hello Domo Community! Happy July! It's time to recap the Community Forums top moments in June. Follow the discussion, ideas, and user links to contribute to June's hot content 🔥 Forum Frenzy Day The first of its kind, we launched a Forum Frenzy — one full day where we recruited some Domo's internal experts (support,…
-
Multiple contact points on Domo Support tickets
Hi, I'm a Domo Operations Manager at P&G. It would be very, very useful to have option to add multiple e-mail addresses to Domo Support Tickets. Right now the communication flow is hard as we have to pass all the time e-mails between supports and users. It would make our support way more effective if you allow to add more…
-
How to remove duplicate records from the drill down view
Hi Community We have 6 months data in which we have some duplicate emails available, however we have created a beast mode to show the unique count in the chart but when we go to the drill down we are getting all the records with duplicate records too. So is ther any way we can create a beast mode where in drill down we can…
-
Indian Currency & Abbreviation
In India, lot of clients working in Domo but we don't have the Indian currency(Rupees) in any of the cards. Also we don't have Indian abbreviation like L and Cr. Kindly add those features in Domo.
-
Not able to assign value to a custom field of type LOCALDATETIME
I have created a custom field of type LOCALDATETIME. I am not able to assign value to this in UI. Can anyone please help me with this. Below is the attached image in which "custom 2" is the custom field.
-
Removing "Back to Home" header white space on subscriber instance
Hi all, I would like to request the removal or redesign of the "Back to Home" position for App Studio in subscriber instance. Currently, it is located at the top header with thick white strip across the page. This is a huge wasted space that do not exist in a normal instance. As part of our solution architecture, we use…
-
Fixed Functions... fixed
I would like the ability to pass the date grain from the card or page into a fixed function as a variable. Currently, I have a fixed function that is fixed by month for example. This works perfectly when the card or the dashboard it is used in is set to look at the data at a monthly level. However, I would like to be able…
-
New to Data Analytics - Loving Visualizations, Problem Solving, and Data Empowerment
I've been with my current firm now for about 9 months and have loved being a part of a data-driven culture. As a recent graduate, this is my first "career" and I'm thankful to have been found by a wonderful company in a stimulating and exciting field. Outside of problem solving at work, I love to do anything outside -…
-
Limitations of SQL API
I wanted to confirm a few limitations on the SQL API: Documentation states that joins aren't allowed, seems this extends to subqueries and CTE's as well? UPDATE and ALTER statements are not supported through the SQL API
-
How to exclude incomplete week in calculated formulas (BM) while using fiscal calendar
Currently am using this formula to exclude current week: CASE WHEN WEEK(Snapshot Date) >= WEEK(maxSnapshotDate) AND YEAR(Snapshot Date) >= YEAR(maxSnapshotDate) THEN 0 ELSE 1 END however, it is excluding Sundays data. (I want to look at Fiscal calendar and it is selected under date settings)
-
Text Input Color - Search
The text input color within our search in app studio is displaying in black on the mobile interface, it would be beneficial to be able to adjust text color.
-
Send an email to a dynamic group using workflows
Is there a way to send an email to a domo group using workflows? I see there's sendDomoEmail which allows you to create a list of email addresses, sendDomoEmailToPeople which allows you to create a list of domo users, sendEmail which allows you to send to a single email address, and sendDomoEmailToPerson which allows you…
-
Option to Toggle List Drop Down in Search
We've included a "fuzzy filter" control/variable within our app, and upon selecting the input box, a list appears that worsens the UX (Mobile specific). The intention is to have, upon clicking into the input box, the user search up a name from the keyboard rather than through a list function, and then have this search…
-
Calculating Attach Rate - when product B is on a transaction that also has product A
Hi experts. I have a set of sales data where each product has a row for the number of units sold on each Sales Order. I want to calculate the Attach Rate - where Product Type B was sold in a transaction that also had Product Type A. So in the example below there were 4 transactions where Product A was sold, and in 2 of…
-
How do I change a field that is a text to a number?
I am trying to change a field that shows up as a text field to a number, but I am getting the below error in magic ETL. Any ideas on how to change this field to a number?
-
How can I show the number in percentage in domo alerts email
I've set up alerts on the card where numbers are displayed as percentages in the visuals, but they appear as floating decimals in the alerts. is there a way to shown number in percentage use beast mode?
-
when I set up Trellis/tiered date, i am not able to select part of the data to zoom in?
when I set up Trellis/tiered date, i am not able to select part of the data to zoom in. this function disappears anybody who knows why? thank you.
-
Users navigating to and from Apps
Can you iframe an App into a Dashboard? Maybe we are doing something wrong, but when we plug the App's generated iframe info and place it into a card on a dashboard the connection is refused. Our users tend towards the very casual side and a lot seem to struggle with even the dashboard menu. As we begin to build Apps we…