-
Rolling Averages Feature
I was looking for a more flexible way to create rolling averages. Of course possible in a Domo Dataflow/Magic ETL → but then you need to fix it on the periods you want to "roll over". Is it possible in a beast mode or is there maybe a card type/feature that makes it even easier?
-
Deleted the parent Page and the child dashboard got deleted. Is there a way to reverse/restore it?
-
Webform in App Studio
Anyone successfully embed a editable webform into an App Studio app? I'm totally lost and feel like I'm going in circles.
-
Filtering inside a DDX Brick
Hi, I am currently trying to filter on the date inside my DDX brick to only give me the current month data. The date Column I am using to filter is called Fiscal Months. How would I do that? Im assuming it has to do with the way im querying the dataset. I attached my JS below. One thing to Note is that date column is…
-
Card rendering problems in Chrome
Hi, Is anyone experiencing rendering problems in domo when returning to a domo tab in Google Chrome latest version after leaving it idle for a while? We are having issues where the cards are empty and only render when you hover the mouse over them, Some still don't show correctly even after that.
-
access page embed applied filters in brick to pre-select filters
Hi, We have an invisible brick inside a page embed. It's only job so far is to notify the host through a postMessage when a filter has been applied ( using domo.onFiltersUpdate() ). The host then listens for this postMessage and stores the chosen filters in session storage. This is all working well. When the modal is…
-
Beast mode referencing
Hello, I wonder why this won't work. I get that the CASE WHEN can't have MAX() within it, but I thought by referencing the beast mode that uses the MAX() would process it as a subquery that references the output value instead of the formula MAX(). If this wouldn't work, is there an alternative to this? I needed the…
-
How can I add a new date column to an existing data set?
I bring a sales data set weekly, and started this about 6 weeks ago. This week my file had a new date column, but the new date column is not visible when I want to add to a card on my dashboard. I am assuming it is due to the past files not having this column. Anything I can do besides re-adding all the past files with the…
-
FIXED BY referenced in another beast mode
Hello everyone, I am trying to reference a beast mode (streak) to another (streak_breaker) that's using a FIXED (BY) function, but it keeps on returning an error. Is this not feasible? Here's my example data and calculations: streak_breaker = MAX(MAX(CASE WHEN status = 'draft' THEN campaign_idEND) FIXED (BY account_id)) »…
-
Emailed DataSet date conversion
Hi I have a DataSet that get updated via the email connected. The data includes a date column, I am having issues with the automatic date conversion on the DataSet. See below an example for the data in the CSV file, both dates are on March 2024 2577,Benjamin,12/03/2026 date gets converted automatically and incorrectly to 3…
-
Using variable on Workflow assignment
Hi, I'm working in a workflow that must assign a Form to different users over a loop (more than 30) and my question is if there is a way to make an dinamic assignment for example using a variable instead of have to select a specific user as a Custom Value every time:
-
Runtime selection of dataset, not through manifest file
Currently testing using either vanilla javascript or React as a target framework. Not looking to deploy this on App Studio yet. We are not on consumption yet, so no workflows currently for this, but workflows still might not solve this particular item. I've created a test application to allow users to approve exceptions.…
-
Flexible SUM Aggregates With Duplicate Values in Dataset
Hello everyone. I have a data set that looks like this: This data set shows product purchases at the customer level. Thus, product IDs are duplicated in the data set. Here's the challenge. I want to show the total value of products, counting each product value only once in a SUM. I've added a Product Rank column as a…
-
Nested fixed functions
Hi All - We are using fixed functions to calculate the average LTV per year for certain audiences. In the end, we want to be able to sum up the averages into a total 4-year LTV for the audience, which requires another fixed function. However, we're hitting errors when we wrap our calc in the new fixed function to sum up…
-
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…