-
Is there a beast mode I can use to add two columns and then get the average?
-
Domo API to import files to domo
domo = Domo(client_id, client_secret,api_host=api_host) I want to add an additional argument here that is updatemethod=Append. I am not sure what the correct syntax for this would be. For extra context, I am currently reading files into python and essentially once I read these files in, I want to combine them and then…
-
Reading dataset into a custom app with Javascript
Hello. I created this customer app but no matter what I do I cannot get anything to display. I have a dataset with a few columns and I want to display those column values in the custom app. I know javascript, html, and css, but having a hard time getting anything from the dataset to display. I have included the files I…
-
NEW COMMUNITY COACH: @david_cunningham 🔥🥳
Huge shoutout and congratulations to @david_cunningham for hitting Coach status on the Community Forums! David joined the Community Forums just ONE month ago! He ranked up from Member ➡️ Coach faster than any user in the history of the Community! Go David! In the month of May alone, he has answered 62 questions — this is…
-
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?