-
Store max transaction number
I have a general ledger transaction dataset that is almost 90Mil rows. It takes three hours to do a full replace daily. The dataset has a unique sequential transaction number that grows as transactions are posted. Most of the time, letting the general ledger just run overnight is sufficient. But several times a month there…
-
Dynamic Goal line on a bar chart
I need to create a goal line dynamically on a bar chart. I have used scale marker in properties, but it is giving a static line. Can someone please suggest how can we achieve dynamic goal line. Thanks
-
Alerts using PDP
I have a dataset which adds column(s) when certain criterias meet. Currently this dataset has no data. Is it possible to add PDP on this based on a certain column? I tried but it wasnt working. I dont want to create another alert for this specific PDP condition! Thanks !
-
PRODUCT RELEASE SNEAK: Workflows
As an active Community member perk, we will be providing insider sneak peeks for the features we will be releasing on Wednesday May 22nd 🥳 A little bit about Workflows: Workflows allow users to design and implement executable workflow processes using low code capabilities. This feature automates business logic to provide…
-
Webforms
Is there a way to copy or "save as" an existing webform or does it need to be recreated?
-
PRODUCT RELEASE SNEAK: Sandbox and Publish Community Post
As an active Community member perk, we will be providing insider sneak peeks for the features we will be releasing on Wednesday May 22nd 🥳 A little bit about App Studio: App Studio is a no code, drag-and-drop interface that enables anyone to create their own customized app experience with all the data, power, and…
-
WE WANT TO HEAR FROM YOU: Where do you go for information for and help with Domo?
Hello Domo Community! We'd like to hear answers to the below from as many users as possible: Where do you go for help, news, updates, or solutions about Domo? Are there any other Domo resources or external locations that you frequent for information? Even with our bias towards the Community Forums, we know there are other…
-
How to go about this question?
Parameters would be: Policy status = death claim Termination date has to be less than 2 yrs from Effective Date Sure Term and Evolution policies RC4 (Express or Silver) RC5 (Essence or Bronze) i am still learning domo so this is quite confusing. im not sure if i need to manipulate filters or add new calculated fields.…
-
DOMO SSL error
While trying to read dataset through Domo API , I am getting the following error: HTTPSConnectionPool(host='api.domo.com', port=443): Max retries exceeded with url: /oauth/token?grant_type=client_credentials (Caused by SSLError(SSLError("bad handshake: Error([('SSL routines', 'ssl3_get_server_certificate', 'certificate…
-
*.xlsx issue after Workbench update
Following the Domo Workbench update to the latest version (5.2.8606.30751), I've encountered a problem where all my configured jobs are no longer functioning, displaying the same error message. The error happens when the Transport Type is ‘Domo SharePoint Data Provider’. All jobs are affected. All files are *.xlsx and I…
-
Make Exporting, User Comments, and Real Time Collaboration Possible within App Studio
There are two main concerns my team has which is preventing us from utilizing App Studo more: 1) the inability to export cards or outputs to Excel/PPT and 2) the inability for users to communicate or point out key findings with each other in the platform. A majority of dashboards we create typically require and/or…
-
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…
-
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…