-
can anyone point me to the solution on how to build the following year to date vs previous year?
I have a feed that collects daily sales and units, I need to create a report that generates a table showing the following information the previous day, week-to-date (WTD), month-to-date (MTD), quarterly-to-date (QTD), and year-to-date (YTD) vs. the previous year
-
May 2024 Domo Release
If you logged into Domo today, you should have seen a preview of the new features and enhancements and betas coming to Domo next week. As I started doing earlier in the year, posting a PDF here since those messages disappear once you read them. Enjoy.
-
Displaying How far ahead or behind goals as weeks progress
I have an etl that is joining a google sheet that has weekly goals, to a dataset that have the actual weekly sales. I am currently showing the week by week results in a grouped bar card… each week side by side, actuals to goals. (see image) Is there a way with the data I have, to show how far ahead or behind we are up to…
-
Scheduling Excel Reports
When I send this report as an Excel attachment, it comes as a CSV. Can scheduled reports be sent as an Excel format not CSV?
-
Need help with Date Range/ Period to Date
As you can see top right, Domo has a selection Date Range, Period to Date, and if I click on Week to Date, my 3 cards will update date dimension to current Week to Date, Month to Date, Quarter to Date. I'm trying to create a filter or a button to do same functions Period to Date: WTD, MTD, QTD, YTD without clicking on Date…
-
Drill Down Selector
Hello all I am new to using the drill down feature and I would like to know if there is a way to choose which drill down goes to if I click on a specific column. I have 2 drill downs made for this card and want to be able to click on the Ageing Group column that takes me to the drill down for Ageing Group and same for Note…
-
Lag() function for previous value over unpredictable rows counts of each partition
Hi Everyone, I have a dataset with a monthYear date field, a Quarter field with values 1-4 to represent quarters, and finally a quarterly_value column. Here's where it gets fun. Not all months and quarters are present in the dataset. There will never be a monthYear with more than one row (i.e. never two rows of DEC 2023).…
-
Instagram Business Connector Disabled?
Hi All, I am trying to set up the Instagram Business Connector and the assigned team member got the following error: So, we tried setting up the normal Instagram Connecter and got this error instead: Has anyone encountered either of this errors? If so, do you know of a workaround? Thank you!
-
I am using the email connector, but I am getting an error.
Domo is ready, but an email was received that did not pass the regex filters and was not processed. Invalid Body regex. I have used an email connector before with some automation, but I am trying to send to the email myself and get an error. Any ideas?
-
Adding custom font colors for a transposed row in a table
I want to label the positive numbers in green and negatives in red but only for the second row. How can this be achieved? Current chart settings is as shown below
-
Need different alignment types for columns
Below is a tranposed table, I need the 1st column to be left aligned while the rest of the numerics as center aligned, how can this be resolved?
-
Period over Period with Non-Time X Axis
First time poster!! Thanks for all the help you've contributed thus far Domo Community. I'm trying to create a year over year comparison graph with our locations on the X Axis, instead of the required time period on the x axis. The period over period comparisons are only available when Time is used on the x axis, so I…
-
IDP Router/ Identity Broker - Improvements to Instance list UI
Currently when we setup multiple instances under Embed → Mapping for a single Key Attribute value, we are shown "Your Accounts" page to select the instance we want to be redirected to. This page lists only the instance URLs, request to enhance the UI and show additional user friendly attributes like Instance Name/Alias.
-
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…
-
row count at each step
You should be able to see the # of rows output after each step of the etl flow.
-
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…