-
Google sheet date format
Hi, I have a Google sheet with a date column where I am using the googlefinance function. When I import the data into Domo using the Google sheet connector, the date changes from "4/20/2024 23:58:00" to "45,402.99861111111" in Domo. Please do you know how to fix this date problem? Thanks
-
Returning the number of days in the selected date range
It would be great to be able to call for the specific date range (and number of days) selected in a beast mode so that my visualization would dynamically update the calculated field as the date range was modified. My recent use case was a turnover rate calculation where I ultimately had to divide by the number of days in…
-
can you include "rescind" policy status as well for the above risk classes?
can you help me add a column for rescind policy based on this table?
-
Parameter passing to a URL
Enabling of passing the filter parameters into the URL, to access the parameters with URL to filter the dashboards called withing the URL
-
$ Amount
I am using a Sales Funnel chart. When I have a dollar amount such as $12,363.12, the amount is omitted from the total. If I load it with just $12,363 it will show up. How can I still get a total with having the cents included? I have tried floating and fixed decimal both.
-
Branching/Hierarchy in Pivot Table, Mega Table
Hello, Is there a more elegant solution to create Branching/Hierarchy in a Pivot Table (or any other table)? Something to look similar to this: This was created using the Formula Editor in ETL, but I don't like the solution and was hoping for something more elegant and flexible:
-
Forward Filling using ETL/ Without Python tile
Hello, I am trying to work out a logic to forward fill values. Below is an example of what I want to achieve: I want to forward fill the Calculation column values and the grouping will be based on platform and code. So, I want to populate last non null value instead of zero in the calculation column. So, the output then…
-
Create a field for status update date
i need help creating a field for status update date and not update at. this is for insurance policy claims. im not sure what more information to provide .
-
Initial Sandbox Setup
My company is purchasing a second domo instance to implement a dev and prod environment. We want to keep our current instance as the dev instance (sandbox) and make the new instance prod. What are the best practices to prepare and get started for this transition? I think our team is comfortable with the idea of promoting…
-
Run rate beastmode calculation
Hi all, trying to formulate a beastmode calculation to give me weekly run rate so I can do a WoW chart. No matter how I modify the query, I keep getting a "Calculation Error : All fields must be aggregated or in the group by clause". This is the first time I am seeing this error. Any insights and advice would be…
-
domo.onFiltersUpdate to include Variables with DDX Brick
Please add the ability to update bricks on variable updates just as the bricks update with page filters changes.
-
Total Rows not Calculating
We have a drill path that ends with a table card. The table card has a total row but it doesn't display totals except for counts.
-
In the Activity Log - What is a Container View?
I have someone in an instance with thousands of action every day at the same times. Action = CREATED Object_Type = CONTAINER_VIEW I checked the object names and found that they are cards. It appears that this has something to do with the page's scheduled report, but It's only got a few of the cards reporting this behavior.…
-
Remove milliseconds from date
I am building a connector which requires the date in the API call, however it needs to be format YYYY-MM-DDTHH:MM:SSZ. today = new Date(); provides the date however it also includes milliseconds. How can I get the date without milliseconds or remove them after getting the date? I will then also need to remove 30 days as I…
-
Starting Day of the Week - Monday
Hello, can anyone help me find a solution on how I could start with Monday for the weekly data? My data is dynamic, so it has to update on a weekly basis - I used Last 4 weeks. I have a table with weekly data showing like the one below, and when I created a bar chart in DOMO, originally, when graphed weekly, it will start…
-
Domo blocked by cloudflare
I am trying to build a new connector but keep getting error code 1010 when trying to authenticate. I have found that it appears to be the service I am trying to connect into are using cloudflare which is blocking DOMO. I have tried a few work arounds (adding things to the headers eg) and get different messages but no…
-
Restore "Hamburger" Menu on Card Details Page
I recently noticed that "Hamburger" dashboard menu is no longer visible from the Card Details page. So now to navigate to a different dashboard I need to click either the Dashboard name in the breadcrumb trail or the "Dashboard" header to be able to see the full dashboard list.
-
PRODUCT RELEASE SNEAK: Column Masking Beta
As an active Community member perk, we will be providing insider sneak peeks for the features we will be releasing on Wednesday May 22nd 🥳 Previously, Data Administrators had to create and manage multiple versions of the same datasets to accommodate different audiences to protect sensitive data. In some cases, even just…
-
PRODUCT RELEASE SNEAK: DomoStats
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 DomoStats: DomoStats allow users to explore insights into how their team is using Domo. DomoStats is powered by a live Domo Dataset (no configuration required!).…
-
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…