-
Image Not Displaying on Mobile App
Hello, We've connected images out of our private (Salesforce) instance to an HTML table and we're able to see the images (headshots) within our Desktop instance of App Studio and Domo - as well as in the mobile view on desktop in App Studio. However, the images are not populating within the actual mobile version of Domo /…
-
Random Number
What is the best way to try and generate a random number in a Beast Mode? I am doing a presentation and want to remove names from my column and just make a beast mode to assign a random number. I tried doing rand() but that was not unique. I also tried doing length of name * rand() but that was also somehow not unique.
-
Is it possible to upload many google sheets at the same time?
I have 30 sheets under a google sheet workbook. Can I upload them(30 sheets) in one time? Now via Google Sheets Connector, I can select only 1 sheet each time. I have the whole year data waiting to be uploaded, It is really too many manual workload. Is it possible to upload many google sheets at the same time?
-
What's the best practice way to remove data from a partitioned dataset?
We have an ETL set up to a partitioned output. Now that we are far enough into 2024 I'm being told that we can reduce the size of this dataset by removing all 2022 data from it. What would be the best way to go about doing this?
-
How to create DoD variance formula
My data set has 'Total Actions' by advertiser, by goal name, by day. I would like to be able to create an alert when 'Total Actions' drop to 0 on a particular day (where it previously had >= 1). Of if there is a variance of 90% or more. As I understand it, we can create alerts on a card but only based on the Summary…
-
How to aggregate a case statement that uses a fixed function
Hello, I was hoping somebody could help me understand how to sum the following case statement. case when `Date` = max(max(`Date`)) fixed () then `On Hand by Day - DO NOT SUM` else 0 end I need the calculation to be dynamic and reference the date selected on the card. All attempts to aggregate the case statement fail and…
-
Stream API - DataSet stack in Storing....
Hello All, I'm very new to DOMO. I took over the project written in C# using Streams API. I'm trying to add extra column to the existing dataset. I have done necessary changes on in the code part and my payload (csv) contains extra column, I also updated the Schema of the dataSet so when I look in DOMO the column is there.…
-
Approvals in-progress tracking
I love that each approval flow spins up its own dataset to track completions, but approvals only seem to show up after they've been completed with an approved, canceled, or denied status. It would be lovely if the dataset included any submission even if it's still in progress to better identify at which stage an approval…
-
Creating Sub folders
I am new in domo and want to know if it's possible to create sub folders to organize dimensions or measures fields as done in Power BI
-
Building User-Generated Card
I've had a request from a stakeholder to build a dynamic card that updates a chart based on their selection of metrics. For example, the dimension may always be DATE but the user wants to be able to select from Digital Impressions, Link Clicks, and Web Visits as the metrics. And the user wants to be able to toggle between…
-
Capture filters on a page
I have a use case in which I need to Capture filters on a dashboard using a ddx brick, that ddx brick can be a invisible one at the bottom of page. What it will do is to capture any filters applied on the page by applying filters at the top or by choosing any card section to filter the dashboard and other cards. I will…
-
Number format in Indian numbering system
Hello, How can I have the numbers presented in Indian numbering system like Crores, Lakhs, Thousands? I understand we can do the formatting using the custom format and comma separator, but I would like to print Crores, Lakhs instead of K (thousand), M (mill) on a card (graph chart, single value) TIA.
-
Target line
Hi I would like to show a target line for fy 24 (April 2023 to March 2024) and then start a new line starting for fy 25 (April 2024 then onwards) Can I use one target line which moves from target - 20 up until March 2024 the target 11 - from April 2024 onwards.
-
Duplicate a card
Hi I would like to duplicate a card and not have it linked to the original. How do I do this.
-
concat() integers
Is there a way in beastmode to CONCAT() a number with anything and not lose its thousands separator? In my beastmode, accounts_sending_campaigns_distinct and sum(`reach`) are both integers that I wanted to be displayed with thousand separators CONCAT(' <div style="font-size:15px; color:#EDEDDA;"> <div> <span…
-
Question re: Connecting to GoHighLevel using JSON Oauth
Thanks in advance! I'm trying to connect to GoHighLevel using their OAuth 2.0 since 1.0 will be deprecated shortly. I have all the bits and pieces (clientid, client secret, auth code, all that good stuff) but when trying to use the JSON OAuth connector with the authorization code workflow, I keep getting a "there was a…
-
Ability to share pages (not just cards) without Manage All grant for Domo Everywhere
My company whitelabels Domo as an offering within our software to allow our customers to report on their data from our product. Each customer has their own subscriber instance that we push a pre-defined set of data sets and dashboards to. I have a Customer Editor role, which grants the "Edit Cards" and "Edit Pages"…
-
Add REGEX functions to Beast Mode
REGEX functions are currently supported in the MagicETL formula tiles, but not in beast mode. It would be helpful to have these added to Beast Mode.
-
Getting Calculated Line to appear on dashboard bar graph card
I have a horizontal bar graph showing percentages. On the graph I have selected to show the average as a calculated line: When I view the graph full-size, not as part of a dashboard, the line is visible, and it has a label underneath it showing the average value; in this case, it's the red line: The black line is a goal…
-
API Authentication Security Improvement
As per API authentication guide here - The first step to get access to Domo APIs is to generate ClientId/Secret and then make a request to get access token. This request is of type "Basic Auth" where client credentials (ClientId/Secret) are passed as base64 encoded string. Since these creds act like username/password…
-
Data Science - Outliers
Hi, New to using the data science tiles in ETL. I have a dataset with sales by category by day. I can run this through the outliers tile for one category and it will correctly mark the outliers. What is the best way to do this per category? Thanks
-
Dashboard Editing
When I create a new dashboard it allows me to edit the format, add text, etc. initially, but once I save it, it does not allow me to edit it again. When I click the wrench, it gives me two options: Add to Favorites or Open Conversation. From other guides/screenshots it seems like there should be many more options to choose…
-
Rolling 12 Month Average in Magic ETL
Hi there! Was hoping someone would have a solution for what I am trying to do. I want a 12 month historical average in line with the current month in my dataset. (Sample datasets will only show 3 month) This is a sample dataset of what I am working with: *"Desired Column" would be the field that holds the historical…
-
is there anyway to change default time in Domo?
Seems like date/time format always defaults to 12:00am. Is there anyway I can change this universally so that it always just defaults to 11:59pm when no time is specified in date/time format?
-
How to extract a substring from an URL
I'm trying to extract the substring from an URL. Input: www.abcd.com/level1/level2 The output I'm looking for is essentially taking from the first character to the position of the second '/' minus 1. I wonder how to write the formula in beast mode. Desired output: www.abcd.com/level
-
BeastMode: New Field with Multiple Column Criteria
Pretty sure doing in ETL would be preferrable however looking for a short term approach as our dev resources are tied up. I have a data set something like the picture below. Its a data set that displays ALL USERS that have access to Application 1 (App 1). It Also shows when a user is a manager and the client they are a…
-
WorkFlow Code Engine Help
Good morning, I am following along with the below Workflow Onboarding video from Dan. He mentions having a separate video for making a new code engine package, this one titled Page Manipulation, I was wondering if anyone had the link to that video, if it…
-
Unable to get the value of a canvas
Hello Gurus, I am trying to get a value of canvas which is coming as a aria-label using JS after the iframe is fully loaded. I have highligted the value which I need to get after iframe is fully loaded. For that I am using the following code snippet, in this code I am able to get the document part of the iframe, but when I…
-
Release Notes - What Changed
Many times new releases add additional things which aren't documented and can silently break dataflows and metadata which we rely on to properly administer our instance. Can we get a list of things that have changed in the release to see what issues we might be running into when monitoring our instance? Could we also get…
-
Option to Remove Participant Filter
In DOMO, there is an option to remove "Allow adding of new filters" for a Dashboard, but this removal only removes the ability for the Participant to save filters for all who access the card. I was interested in not allowing the Participant to save a filter at all and that is currently not an option. I am proposing to have…