-
App Studio Utilisation
It's surprising to discover that there is currently no method to track the utilization of apps created through App Studio. We need a mechanism to monitor this in order to determine whether the apps are truly adding value to the business and whether they are being used effectively. We need this asap as we see so far 290…
-
beast mode formula: Previous week compare to same week last year
Hi, I am struggle to get a beast mode formula to work for calculating the sum of same week last year, our business date start from Sun- Sat, i want to get the formula to only calculate previous week data e.g. today is 24th Wed but i want to calculate the week from 14th Sun -20th Sat DOMO says the formula for LY is…
-
YEARWEEK Function and Modes
Hello all - I am looking for some help with the YEARWEEK() function. I see that the function syntax is: YEARWEEK(`dateCol`, mode) where 'mode' defines the starting day of the week with '11' meaning Sun-Sat and '22' being Mon-Sun. I found this in the Beast Mode Functions Reference Guide but it doesn't expand whether other…
-
Duplicates
Hey guys, I'm experiencing duplicate fields on my data grid and trying to figure out how to remove them.
-
Filter on Job name in the workbench5
I have about 500 job in the workbench. Is there a way to activate the filter on he job name column so that I do not have to browse through every row? Thanks
-
beast mode question
Hello everyone, I'm having an issue trying to get this beast mode calculation validated. We have tickets that is suppose to be updated but we want to track tickets that are not updated within 4 hrs. And we want a color change when ticket is about to breach 4hrs with no update. I wrote this but getting syntex error. if…
-
Unable to Use SSO for Domo Mobile App in Intune MAM Environment
Domo Mobile App is not listed in "Microsoft Intune protected apps" and cannot perform Single-Sign-On with Microsoft Entra ID on mobile devices managed by Microsoft Intune MAM. Therefore, our employees are unable to use Domo Mobile App. We strongly hope that the Domo Mobile App will be supported by Intune MAM.
-
Mega Table Rank interactions with PDP
Hi all, I am trying to build out a dashboard that lets vendors compete with each other in a mostly anonymous way. One example would be a section that shows the logged in vendor their 7 Day Sales Rank, compared to their 28 and 91 Day Sales Rank. Key requirements: Vendors should be able to see their rank only; not any of the…
-
Why Is the Pivot Tile not Working as I Expected
I am trying to use the Pivot tile to accomplish the following (in my attached dataset), but am getting no results under the column I am creating (Weekend_Date_Pivot). Weekend Date should now be columns with Demand_Qty as the metric under each Weekend Date
-
Company Lookup on Different Columns
Hello, I am seeing if there is a way to write a beast mode that'll allow a user to input a company name that searches across multiple columns. For example, I want to look up Wells Fargo as the company name. I have three columns where Wells Fargo can appear under: Buyer, Seller, Lender. Is there a way to allow users to type…
-
Multiple dashboard filters
Hello, I have 4 dashboard filters on my dashboard.. Is there a way that once I select the first filter (for example account), that the other filter dropdowns are filtered? The issue is that the dropdowns are showing only the first 50 ish rows of data. So if I'm able to use the first filter, to filter down the data, that'd…
-
I am trying to delete a row from dataset
Filter rows in Magic ETL gives a new dataset with the filtered rows but doesn't delete it from the input dataset. I am trying to update the input dataset.
-
SMART or FORMULA BASED NAMING AND COLOR
2 ideas here… SMART TEXT OR FORMULA BASED (CONDITION BASED) NAMING This would be for columns or labels on charts. Instead of saying This year… it could say 2025 for example and change dynamically as the years change instead of having to manually change them in the system. FOR COLOR RULES: I would suggest having more…
-
Can I use a Beast Mode for Null/Blank Values?
I have two issues I am trying to solve. Company123 has a budget of 706.34, but there was no $ for this week. The cell is blank, so my formula is not calculating. The Budget GP-GP should equal -706.34, but it is blank. Can I do a Beast Mode, or even something in the ETL would be okay? Second issue is the 27,504.75 minus…
-
How can I set up a graph to show period over period data in a dynamic way?
I am looking for a way to show a bar graph with sales data by period and a growth rate line with period over period percent change. I have a detailed dataset with a large amount of sales data spanning over multiple years. I am having trouble with how to get the prior period data to be on the same line and to be dynamic so…
-
Optimizing a Domo Workflow for Sending Emails Based on Dataset Markers
I’m working on a project that involves sending emails to individuals based on specific markers in a dataset. Currently, I’ve set up a Domo workflow that iterates through the dataset row by row, checks certain conditions, and sends emails accordingly. While the workflow functions as intended, it is extremely slow. To…
-
Recent Editable Data Webinar question
@DanHendriksen Recently, I attended the Domo Hands-On Editable Data Webinar. Can anyone help me with the following question from the webinar? The second app was described as editable, allowing the approval status to be set and the priority to be changed. However, after submitting, the responses disappear and are no longer…
-
GA4 Connector append data
Hi I used the connector to bring 365 days of data into Domo from GA4 which took almost 14 hrs Now I don't want to use huge amount of credits on updating this daily. Was thinking may be instead I can append yesterday data only to these already pulled data. Any Idea how to do that? Appreciate your thoughts and solutions here!
-
Do Domo connectors work with MFA
I am hoping someone can answer this question. Do Domo connectors work with MFA? We have been using the FB connector to pull in reporting data but as of this morning it appears FB is requiring us to setup MFA for the FB account, we are using to access the data. My concern is will we still be able to pull in this data via…
-
How to re-subscribe a Domo emailed report recipient
We have scheduled reports that go via email to a number of recipients. One of them unsubscribed from the reports and now needs to start receiving them. The recipient does not have access to Domo; only to the reports emailed via the scheduled reports. As always, your assistance is greatly appreciated. Thank you!
-
Drill Down while maintaining breadth
I want to be able to interact with a card wherein the scope of the x-axis (time in this case) is sticky, but the series changes. Right now, if you drill down to a point on the x-axis, such as a year, it drills down to the year. Is it possible to drill "across" to a separate series? I understand that the Drill Down isn't…
-
Trying to delete row from dataset. Does Domo have an existing API or tool ?
-
Multiple results encountered for the same location in Pivot Table indicated by ****
Attached is a sample of my data. I am trying to create a pivot table with the following: Rows: location, week, date, shift Columns: count(unique identifier), count(unique identifier) * shift length In my ETL, I created a formula to handle empty values. It determines whether a shift was 8 hours or 10 hours, based on a…
-
Is there a way to set column widths for excel export of pivot table or prevent freezing panes?
When I export my pivot table as an excel file, it is generating an excel where my second column is like 245 characters wide, and it also freezes the pane after that column, making it impossible for user to see any of the corresponding data to the right of the second column. Ideally, I'd want to set a fixed column width for…
-
Using rank within a window function to filter results
I am trying to analyze the initial purchase behavior of 2 subsets of users, mobile app users and non mobile app users. I have client purchase history in a table where each row is a sale and contains whether the user is an app user or not and I've created a beast mode that uses variables "min sale date" and "max sale date"…
-
Support for second axis on horizontal grouped bar charts
Vertically-oriented grouped bar charts support a second axis, making it easy to include data from two series that have very different values. Horizontally-oriented grouped bar charts inexplicably do not support this functionality. This seems quite silly, since they're the exact same visualization, just turned the other way.
-
Customize pin
How can I replace the blue circle with my company’s logo as the pin on the map? Is using an API necessary for this, or is there another way to achieve it?
-
File connector to upload file by file name, not id?
Hi everyone, what file connector should be used to upload a file to DOMO on a schedule? For example, we have \upload\filea.xlsx that we want to upload every morning at 9 am. filea.xlsx is recreated daily and the original file is replaced with the updated one, creating a new file of the same name. Thanks for any input!
-
Is everyone experiencing latency with Domo?
The status site says everything is running, but I can't get into any datasets. I just get spinning. Wondering if this is a systemwide issue or just my instance.
-
slicer not working on the beast mode calculation
I have a beast mode calculation with a CASE statement , where it considers another beast mode calculation to indicate high, low and medium risks. However , when used it as a slicer, it only displays 'no risk'and does not indicate high, low and medium in the slicer options. I am using it to filter my HTML table based on a…