-
Can you filter data from input dataset in a MySQL Flow
Hello, I have a dataset that has data for the past 20 fiscal years. I use it in a flow that only looks at the last two fiscal years and when the flow runs it takes a good 10-20 minutes just to read the data in the dataset and then start transforming it. I was thinking of expediting the loading process by pre-filtering the…
-
When are Beast Modes calculated and when to place in an ETL or leave as Beast Mode?
I have read several varying degrees of opinions on when a Beast Mode is actually calculated. I thought a Beast Mode, attached to a card or assigned to a dataset, is calculated at the objects rendering, regardless of if the Beast Mode is actually being displayed on said card. So if I have 20 total Beast Modes, some only…
-
Beast Mode for "Views in the first 30 days"
Hi there, My team wants to create a beast mode that looks at total views in the first 30 days per asset since the video was published. For example, a video was published on March 1, 2024 and we want to know how many total views did it generate through March 30, 2024. We created a couple of sample beast modes that are…
-
Sharing A Dashboard
Is it possible to share someone's dashboard to myself as an Admin?
-
Forms in App studio ( public embed and private embed) needed
Currently there are no public embed options for forms in form viewer and for forms in App studio ( both private and public). The public embed feature would be really helpful.
-
Form Viewer
The instructions for this app are so brief, I still can't figure out how to delete the sample and connect to my Form Builder data. Anyone have some clearer direction then what's in Knowledge. I am so lost.
-
Calculated Field loses Percentage Format
CASE WHEN SUM(Total Weight/Units Received) > SUM(Weight (MIN)) AND SUM(Total Weight/Units Received) < (Weight (MAX)) THEN '1' WHEN SUM(Total Weight/Units Received) <= SUM(Weight (MIN)) THEN SUM(Total Weight/Units Received / Weight (MIN)) WHEN SUM(Total Weight/Units Received) >= SUM(Weight (MAX)) THEN SUM(Total Weight/Units…
-
Period over Period Multi Value Chart Number Formatting
Hello All, Brand new user to Domo. Have experience with Tableau/Power BI but Domo is a fresh software for me. I am struggling with something that seems very simple but cannot figure it out. We are creating PoP comparison charts. We look at EXACT numbers with everything so this PoP Multi Value Chart is pairing down our…
-
Toggle Auto Preview on/off at the instance level (Company Settings)
As Domo admins, we should be able to control whether Auto Preview is automatically enabled when users launch Analyzer in our Domo instances. This is especially important as Cloud Amplifier is implemented because of the potential cost implications of, for example, querying Snowflake each time a user modifies almost anything…
-
Complex Pivot
How can I use Magic ETL to convert a table from to without using scripting? I have to remove all scripting tiles from my ETLs. I'm assuming some combination of RANK & WINDOW, PIVOT and GROUP BY, but am running out of talent.
-
Beast Mode Question
I have three column, first one is how many we gained this year, second one is how many we lost this year, and last column is total. I applied a filter, filter through this year the problem is I want total column go beyond this year, in another word, the filter won't affect it. Can I do this in beast mode, I try create a…
-
How can I get my icons back?
All of my icons in Domo are missing, replaced with placeholder boxes. I've tried deleting cookies, reviewing site settings, and changing profiles in Chrome. When I changed profiles yesterday the icons returned, but now they're gone again. No one else on my team is having trouble. Apologies, this is likely the wrong…
-
How can we exclude the latest date which is available in date column
I was trying this beastmode formula, and it is giving NULL value for the latest date but when i am putting this formula as filter and selecting this option "Not in" the data shows like "No Data in Filtered Range" CASE WHEN Date = MAX(Date) OVER () THEN 'NULL' ELSE Date END
-
Instagram connector
I'd like to import my Instagram data from FB biz manager, but the built-in connector says there is a known issue and the owner is working on it. It's been several weeks. Any ideas on how to bring Instagram post data in?
-
"Colors" shows limited options based on Beast Mode
I used Rank & Window ETL to Rank Districts 1-46 based on a performance value. I need to use the "Colors" feature in Analyzer to color code rows based on a "Tier" I created in a Beast Mode, which is calculated based on percentile. The Beast Mode is as follows: In the preview, this works. Ranks 1-11 are D, 12-23 are C, etc.…
-
How to pull Google Reviews data from various locations on Google Maps into Domo?
Hello! We are attempting to pull Google Reviews data from our various business locations on Google Maps into Domo. I don't see a connector for this; is there anyone who has experienced this and solved it? Thank you!
-
Starting Major Domo Certification - Tips for Success?
Hi Domo Friends, I got approval to start the training course for the Major Domo certification. I'm excited to standardize my learning process, and to have a fun new line on my resume. Have any of you taken it? Any thoughts, recommendations, ideas, tips?
-
Blank Brick Dataset Schema
I created a blank brick to track office locations in the path of hurricane Beryl. My ETL produces a dataset with latitude and longitude in decimal. Now my blank brick is showing these values as integers. They are not integer. How do I force the blank brick to re-evaluate the schema. I tried reloading and reassigning. I…
-
Support portal error?
I've been getting this error on the support portal for the past few weeks: Is this my account?
-
New Grant to Manage All Connectors for Admins
It would be nice for admins to be able to view and manage all connector accounts. Currently, admins cannot see which accounts are in the environment without creating a card or having the account shared with them. Even then, they are not able to manage who has access to them without being the owner. Our current work around…
-
Notification when dataset or dataflow runs
Hello, Have some clients asking about an alert when a dataset or dataflow has completed. Currently we just have failed notification but clients would like to get a confirmation on vital dataflows/datasets completed, during immediate need moments. Helps when we are using the DOMO cloud to pull data from DOMO into other…
-
Merged: Dynamic Date Variable
This discussion has been merged.
-
ETL question
I want to implement a function that every time the dataset is updated, it will show me which row is new. What's the best solution, I am thinking about recursive dataflow but not sure how to create one.
-
Beast mode question
Hi all, I have a beast mode calculation created which I'm trying to find out the monthly average of open tickets between 5 boards for the past 15 months and this is what I have- SUM(COUNT(TicketNbr)) OVER (PARTITION BY Board_Name ORDER BY last_update)/ DAYOFMONTH( last_update ) But I think the calculations are off. Is…
-
Unable to Schedule Jobs
Hi everyone, I can manually run a job which works, however when I schedule a job, it says that it executes however the job does not run and I don't see it in the UI. When I look at the viewer, I see the following error: 'Could not fix consecutive blocks of CRON schedule' Does anyone know how to resolve?
-
form brick not available on app studio.
Hi, I have custom coded a form brick and saved it. the form brick had a default form. I have made the changes in HTML and customized it. However when trying to upload it to App studio it displays the default form instead of the customized form.
-
Dashboard Page Filter: Automatically set a default value based on the available values in the filter
When a PDP policy is implemented to a dashboard, I noticed that we cannot set the page filters (i.e. single select filter) to a default value for each PDP policy or have the page filter automatically set to a default value. This is because when there are mandatory dashboard filters in order for the dashboard to work…
-
Grouping Values into Ranges
Hello, I am trying to group values into ranges in DOMO, but can't seem to get my beast mode to work. Am I doing something wrong? I am trying 2 different methods: 1. case WHEN `Sale Liability` >= 50000000 AND <= 100000000 then '$50M-$100M' WHEN `Sale Liability` >= 100000000 AND <= 250000000 then '$100M-$250M' when `Sale…
-
Is it possible to make the multi-value guage dynamic?
I have the multi-value PoP gauge on my dashboard showing a comparison to the previous year. The default date period is set to previous month. But, altering the global date on the dashboard removes the previous year comparison. Is there a way to keep the previous year comparison while also allowing the user to change the…
-
LinkedIn Ads Connector - Upcoming update to the 'Ads Creative (versioned)' report
On Monday, July 29th 2024, Domo will update the version the API endpoint that is used to generate the 'Ads Creative (versioned)' report in the LinkedIn Ads connector. Datasets that are powered by this report at the time of the update will be affected as follows: (1) Columns that are populated by the older version of the…