-
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…
-
Force a filter selection on filter card
I need (and have often needed) a way to force a selection on a filter card for a dashboard. I know I can set default values, but I need a way to ensure at least one selection is always made. Anyone found a workaround here?
-
Optimizing Google BigQuery Service Connector
We are currently funneling our Google Analytics 4 (GA4) data into BigQuery, and then connecting to BigQuery with 'Google BigQuery Service Connector' in Domo. We are partitioning using date keys and bringing in the past 3 days of data (to account for attribution in GA4) with an append. However, our daily updated rows ranges…
-
Comparing a Running Sum to Same Time Last Year with nulls
Hi, I am having a hard time comparing a running sum to the same time last year if there is a no value. The beastmode I am using to get the running sum for each year is as followed. SUM(Count(ReportNumber)) OVER (PARTITION BY Year ORDER BY AccidentDate) However, not all accidents occur on the same day of the year, so my…
-
Is it possible to "Save As" a Text box from one dashboard to another?
There is no "wrench" icon on a text box. I have a somewhat complicated logo box and wish to replicate it on other dashboards, what am I missing?
-
How to shift first week of year from December to January?
The card pictured below is filtered to 2025 - however, Domo's default week starts the prior Sunday which still lands in the month of December. I would like it to show a January date instead for the first week of 2025. I would ideally not like to use week numbers over actual dates on the x-axis. Has anyone else experienced…
-
Cloud Amplifier dataset views can't be remapped to use datasets from other CA connections
We use separate users and databases for our DEV and PROD environments. When we use traditional Snowflake connectors and build dataset views, we can remap the dataset views between datasets from our DEV and PROD accounts with no problem. However, Cloud Amplifier does not support this capability. So, if we build a dataset…
-
Dashboard Filters breaking the card drill downs
Hello, My card drilldowns are not working once my dashboard filters were added. How to fix this?
-
No knowledge base article on Instance Management screen? What is Service Account and Key Attribute?
This page seems to not have any documentation around it, and no explanation of what it means by service account email and key attribute. I have made instances through AEs before but I don't believe these were asked for.
-
Pro-code Editor Submission
Hi All, I have a table that I created using pro-code to capture certain data fields + approval status, but once I hit submit to capture the updates to the data, the submit field stays as "submitting" and it never refreshes. If I manually refresh the updates are not captured. Below is screenshot of what it look like after…
-
Page and card filters
I have three cards on one dashboard. I want to create a page and card filters and make them accessible to users. I can have the page filters done correctly but I am having issues with the card filters. Is there a simple way to create card filters and page filters on cards and make both accessible on the dashboard view?…
-
New Excel Files as Data Sets Creating Extra Columns
I am currently attempting to set up new Data Sets in Domo by loading Excel files containing daily budget data for multiple departments. However, once the file is loaded into Domo it shows two extra columns as follows: These extra columns are breaking the dataflow where the file is needed. Your assistance is very much…
-
Is there an ETL tile to change a row into a column header?
I am not sure of the best way, but is there a way for me to take the raw data below and make a table and/or chart?