-
Improved messaging when deleting a page
I deleted a parent page, which deleted multiple child pages. I didn't remember or know there were sub-dashboards associated to it. So, when developing this, please add the same "Are you sure" logic you have when you have to delete a dataset and show you everything associated to the page.
-
How can I create an alert for when a new transaction of a certain amount enters the dataset?
I've only used alerts to notify when the total sum of a dataset field changes. Is there a way to setup an alert to send when a new record appears in the data that meets a criteria? For example, when a new order > $100K appears in the dataset.
-
Beast Mode Syntax
Hi, I am trying to create a column that shows the year that a financial instrument was created and then I need to add 3 to it. It is going on the bottom of the x-axis so it will show up like '2022-2025' , '2023-2026', '2024-2027', etc. The problem when I go to write the beast mode below is that it thinks it is a math…
-
Weekly Average Graphed by Month
I am looking to graph sales data of the weekly average of items sold per month, not sure of the best way to accomplish this. The current dataset that I am working with is essential a transaction detail dataset coming out of NetSuite Analytics Connect, my query references several different tables but I have joined them all…
-
What's the beast mode to show only the current month and next month?
Hi, need help to show only the current month and next month from my schedule data, but the current month should starts with the 1st day of the month. For example, my pivot table should show only May and June. I have the below beast mode that I put in filter and filter by 'SHOW' to get only May and June but the problem is…
-
Facebook Ads Advanced Connector - Updated?
Hello Everyone, Did anyone else happen to notice that the Facebook Ads Advanced Connector added a new dropdown of "Select Status Of Account To Retrieve"? I'm seeing it show up now, and it defaults to all accounts, if if you had one selected previously. This caused some issues on my end, but I can't find any documentation…
-
Google Sheets connector datasets failing due to auth token expired.
Hello, I am seeing that something today happened for all of our google sheet datasets via connector are failing or having long run times due to this error message. "Domo is ready, but the authentication token is expired. Please verify your account credentials and try again" Does anyone know the resolution for this? I tried…
-
Some content is too tall to export
I have only 1 html card on a dashboard displaying up to 1000 rows of data depending on menu item selected. can't export this dashboard as pdf and PowerPoint export options are greyed out with message " Some content is too tall to export" what is solution to this as user has to print or send pdf report to mass audience and…
-
Some content is too tall to export
I have only 1 html card on a dashboard displaying up to 1000 rows of data depending on menu item selected. can't export this dashboard as pdf and PowerPoint export options are greyed out with message " Some content is too tall to export" what is solution to this as user has to print or send pdf report to mass audience and…
-
FORM BUILDER ISSUE
Good Afternoon, We were doing some spring cleaning for our Datasets and a couple of our forms were deleted. We are trying to rebuild our dashboard with what we currently see in Form Builder, there we have a DEV and UAT forms, when we follow our steps to save the form in our dashboard we are getting a blank form. I am…
-
Dashboard Table using previous day values in calculation
Hi, I need to create a Dashboard that calculates oil usage for Engines. Below is the excel table with calculation I need to recreate in Domo. Basically need to take the tank level and oil added to day tank and engine from day before and subtract today's tank level to get daily usage. Also sometimes there wont always be a…
-
Getting syntax error to calculate MOM change
Can anyone help me what syntax error is there in this beast mode calculation? CASE WHEN LAG(Weighted Average, 1) OVER (ORDER BY Sort: Month Number) IS NOT NULL THEN (Weighted Average - LAG(Weighted Average, 1) OVER (ORDER BY Sort: Month Number)) / NULLIF(LAG(Weighted Average, 1) OVER (ORDER BY Sort: Month Number), 0) ELSE…
-
Compare MAX date with YOY: Month-to-Date (MTD) Comparison
Trying to create a sql statement in magic ETL to compare YOY: Month-to-Date (MTD) by MAX date. My current code from is: CASE WHEN (MONTH(MEMBERSHIP_INSTANCE_PURCHASE_DATE) = MONTH(CURDATE()) and YEAR(MEMBERSHIP_INSTANCE_PURCHASE_DATE) = YEAR(CURDATE()) and DAYOFMONTH(MEMBERSHIP_INSTANCE_PURCHASE_DATE)…
-
Help in Pivot
Hello, Requesting help on how to resolve this and appreciate your assistance. My data in the table has Year, Quarter and all the measures. But user is requesting the report to be in the below format. Measures/Metrics on he left side while Timeframe on the top as columns. I am unable to do this in Pivot table view in the…
-
Beast mode: SUM BY ORG NAME the AMOUNT if the state is granted or closed
Hi: Can anyone help with Beast Mode code: For each organizations_name, I want to get the sum of requests_amount_recommended if requests_state is granted or closed. organizations_name requests_state requests_amount_recommended org A pending_review 10,000.00 org A closed 10,000.00 org A closed 75,000.00 org A closed…
-
Data Structure Issue
Short version: how do I check if a field is a valid date? Long version: Using the NetSuite connector, our data has a field called Period. The connector does not allow me to define the data structure. I tried admin » toolkit » schema management. It doesn't hold. If I force the dataset field to a string, the next run it puts…
-
DomoXCanva Challenge Details
What: Get ready to unleash your creativity and technical prowess in the DomoXCanva Challenge! In this challenge, participants will create a visually stunning infographic in Canva that displays their most frequently viewed analytics from Domo. By leveraging a Domo App and integrating it with your Canva graphic, the metrics…
-
DomoStats - Workbench should include Schedule Groups and Job ID
Domostats - Workbench has almost all the information we would need for tracking purposes. Including Schedule Groups names and the Job ID would make it more effective.
-
Workbench Details Dataset
Is there a way to get a workbench dataset similar to the governance datasets available on DOMO? I understand workbench functions on a local server but there's got to be a way to export to excel or something workbench job details. Is this possible?
-
How to omit values from a field if it contains a letter inside it
I have a really quick simple question I am using the field "item Number" but I need to omit any Item Numbers that contain the characters "A, B, C, P" I tried using the filter tool on the analyzer and used the Match Values option set that to does not contain "A, B, C, P" but that doesn't seem to work Here is the screenshot…
-
Yesterday's Month - Date Range
There are many cases where the Date Range "This Month" fails to provide the current data during the first day of the month. Our reporting/data is normally up to "yesterday"; which means that during the first day of the month, the option "This Month" displays nulls due to the nature of the data. Having an option to display…
-
Certification Expiration Date
Under certification, there is an option to "Expire if Edited" any content. However, it would be great to have an option to include an expiration period to allow users to revise the version of the card/dataset and re-certify to ensure the best quality. For example, adding an expiration period in days. (i.e. Expire in ___…
-
Include Owner and Description fields in the Admin Group dataset
See title.
-
Compare a beast mode to an arbitrary date range
I've been asked to create a trend that shows the number of open projects (y-axis) for an arbitrary date range(x-axis). A sample of my data looks like this: Project_ID Date_Opened Date_Closed 1 1/1/2024 4/5/2024 2 1/18/2024 4/6/2024 3 2/2/2024 3/1/2024 4 2/9/2024 5 2/27/2024 6 3/14/2024 4/20/2024 7 4/3/2024 8 4/11/2024 9…
-
Select Default DOMO Font
Not a fan of the new font in DOMO. Make a setting to use different fonts in Admin so we can pick.
-
Embed dashboards available for student accounts?
Hello! I am trying to embed a DOMO dashboard in a website. I have a student account. Is this functionality available for student accounts? If so, how can I use it?
-
Set Alerts off Data Visualization Card (not from Summary Number)
Hello - does anyone know how I can set an alert (preferably multiple independent alerts) off a data visualization card, that isn't running off a summary number? Domo help articles say that there are certain chart types that allow this but I am unable to find which ones. I have a table card that shows display campaign…
-
Filter in magic ETL
Hi, I am trying to filter a dataset using magic ETL. The logic involves examining each id in the id column and then return the row with the highest rank. This will remove duplicate ids. I have attached images showing an example: before transformation and the desired output result (after). Can we achieve this using magic…
-
What is up with the default drilldown chart?
The default chart view when I drilldown a card is extremely hard to see. The chart is so short I can only see 3 to 4 lines at a time. Even if I zoom out a lot it only shows like 6 lines. I am using the latest Chrome if that helps. Can Domo please fix this? I know we can make a custom drillpath but we have many cards and we…
-
Set Default Email Notification Option to Disabled
Our organization uses Domo Everywhere platform embed into our clients' portal, being the only way for our clients to actually access their instances. Therefore there is no need for the client to receive any email notifications from their Domo instances for any activities such as page sharing, scheduled reports, alerts etc…