-
Aggregation Issues with Beast Mode Calculation
Hello, I'm new to Domo/formula writing and I'm running into issues on multiple fronts with a formula I've created. Original objective: calculate a forecasted value based on stage, weight, and commit. Something like this: If I include commit as a row, then it will sum correctly: However, if I exclude commit as a row, then I…
-
MongoDB connector not working with added field
We are using the query below to filter for displayTime $gte "$fourteenDaysAgo", which is the added field. It doesn't work in Domo, but returns expected results in db explorer. Does anybody have any ideas? [ { $addField: { fourteenDaysAgo: { $trunc: {$toInt: {$divide:[{$subtract: [{$toLong: "$$NOW"} , 1209600000]},1000]}}}…
-
Beastmode to display Unique Values of a Dimension
In a mega-table in Domo I have a table like in the attached picture, and I want to add another value After "Inquiries", "Core Leads" and "MVA Inquiries". That value is a Dimension called "Creative Name". All of the Creative Names within a given week will be the same. So I'd just like the table to display that unique value,…
-
Data on multiple lines
My data is showing on multiple lines even though the parameters are the same. For example, as shown below the area (Boca Del Ray) and the discipline (COTA) are the same, but it's showing separate lines with different data for the measures. I want each area and discipline to show only once. This happens throughout the full…
-
Password Securing PDF/.PPT Export
Hi all, is it possible to safeguard domo scheduled reports? meaning can we have password-secured to protect PII data?
-
Error Publishing Dashboard to Subscriber
Hi all. We have several publications that publish our dashboards, cards, etc… over to our other Domo environments. Yesterday, however, we started having trouble with 1 of our publications and now we're seeing this this warning that says "Please attempt another refresh. If error persists, please contact Support." And on the…
-
Is it possible to use an Excel macro to execute the Domo plugin?
I have a Domo plugin in Excel to connect to our Domo instance and pull data to refresh an Excel document that generates a Pivot table since there are limitations in Domo that prevent us from displaying the data in that particular format. I can use the plugin without any problems, but I cannot automate it using an Excel…
-
Median Date
Hello, I have 2 columns- One has different markets like A, B and C. Each market has some dates. The scenario is if I pick A- there is a range of dates with a minimum date, maximum date. I want to create a new date column which will populate median of the above date range for A in it. Obviously, the median will be one date…
-
Custom App Brick with JavaScript, HTML, CSS
When I download a brick out of the App Store and edit it, it opens with the ability to map the dataset and customize the JavaScript, HTML, and CSS. If I create a custom app and publish it to my instance, when I edit the custom app brick, I can only map the dataset. The JavaScript, HTML, and CSS windows are not present.…
-
How to show a month position as at 12 months ago
Hi all, I'm working on a set of data and for one of my cards I would like to show a pie chart of the total position for the current month and a separate pie chart for the position as at 12 months ago. I'm not sure how best to show this as the date options only seem to allow for the cumulative last 12 months - I could…
-
GA4 Landing page versus Full page URL
Hello everyone, I'm encountering an issue with our GA4 API metrics where the landing page and full page URL show different pages. For context, here's what we have set up: Metrics: views, average session duration, session, engaged session Dimensions: landing page, full page URL, page title, file name, video URL This…
-
LinkedIn Ads API Connector only bringing in 60% of the data?
I am having trouble with the LinkedIn Ads API connector. In January/February of 2024 it was bringing in data at 100% and stable. In March the amount of data dropped to 77% of expected. Now in April its only brining in 60% of the expected data. I haven't made any changes. In March the connector did go down for about a week…
-
It is possible to use DOMO workflows to change the schedules of the datasets of a DOMO instance?
It is possible to use DOMO workflows to change the schedules of the datasets of a DOMO instance?, this being admin. And using some list of dataset ids.
-
Target a specific card value using ID or something.
On my embedded domo dashboard, I have a card which is showing unique participants calculated on domo. But on my platform, I need to apply a check on this specific count, if the count becomes less then 10 then I need some event to occur. How can I target this value, is there a way I can pass any data-value in canvas with…
-
Connecting Monthly Goals to Incoming Cumulative Daily Data
I'm trying to create a card that shows cumulative daily sales against a monthly goal. The data is coming from 2 different sources - the daily info from our raw data, and the goals I was going to input as a webform to then connect with daily data. How do I get the "month" from my webform to match the cumulative raw daily…
-
Python Requests Library in Codeengine
Hello, I have started using the codeengine to create API calls to automate some of our tasks with systems outside of Domo. Python is my primary language and I have noticed that I have not been able to find documentation on making the calls with python. I know there is support for calls using JavaScript and I have been…
-
Toggle between PDP policies
On a normal dashboard there is a way to toggle between PDP policies (see screenshot). Can we have the same functionality in an app? As an admin, it's useful when reviewing dashboards live with employees to automatically apply the filters they have access to.
-
PDP Policies
On a normal dashboard there is a way to toggle between PDP policies (see screenshot). Does anyone know if there is a way to do the same thing in an app?
-
Total + Average columns on a table
Hello, I'm trying to have both a TOTAL column and an AVERAGE column on a table. I haven't seen this done on any card within our company so wondering if it's possible. I'll attach a screenshot of an excel table that shows what I'm trying to accomplish. Columns must be Dates until the final 2 cols… where 1 col will show the…
-
Expanding Beast Mode to formula
With the new nested beast mode feature, we can use an existing beast mode in another beast mode. But sometimes it is helpful to see the formula of the old beast mode, and not just the name. Adding an option to expand a beast mode field back to the formula by double-clicking the name could be useful in some cases, and can…
-
Percentage of values in a column
Hello I have a data set with a column name Sale_Type. I want to create a beast mode to use in a table chart that shows the percentage of each sale type in the column. Example of what I am looking for below.
-
Using DateDiff and Current_date Functions with Syntax error
I am new to Domo and want to know where am getting it wrong with this. DATEDIFF(CURRENT_DATE(),'ShipDate') AS DaysTillDue I am trying to calculate number days until shippment is due
-
Indexing Help
Hi Still new to Domo and I recently linked two datasets together using Magic ETL however, when using this new dataset on a dashboard I see that filtering the data takes a long time. I wanted to see if indexing the new dataset would help improve the speed of the filtering. Does anyone know the best way I should go about…
-
No knowledge base article on Instance Management screen? What is Service Account and Key Attribute?
This page seems to not have any documentation around it, and no explanation of what it means by service account email and key attribute. I have made instances through AEs before but I don't believe these were asked for.
-
Multiple instance support for PDP Automation toolkit
When we need to apply PDP rules for some dataset across N instances we need to create N configuration datasets and N jobs for each instance. Configuration dataset may contain additional Instance column and then we could add only 1 job and connect to 1 configuration dataset. All this information could be produced from…
-
Standard / Fiscal Calendar Variable Switch
For instances where fiscal calendar has been enabled, having the ability to switch between standard and fiscal calendars as a variable control would provide another great level of flexibility. Currently customers who want to do this either need to have two seperate sets of cards - one with standard, and the other with…
-
Find Employees Manager Manager
Good Afternoon, I have a dataset that has EE#, lastname, firstname, Manager, ManagerEE#, ect…, and my question is I need to find the employees Manager- Mananger; all of the employees are listed but there is no column for Manager's Manager. How can I do that in an ETL to create a new column. Here is an example of how I want…
-
How to apply filter to card that is always showing the most recent dataset update?
I have a dataset that is aggregated by a calendar week number. How could I ensure that when a user goes to view a respective card, that they see the most recent week (even if the dataset hasn't updated in 2 or 3 weeks?) i.e. the user views the card in week 15 but the dataset hasn't updated since week 13. So I would want…
-
Auto Data Replace in Drill Down Cards
We build of a lot of drill down cards however when the cards are duplicated, we would update the dataset of the parent card however this does not automatically update the child / drill down cards, it still maintained the original dataset it was duplicated from. There should be an option to replace all the child and drill…
-
Can you turn off the hover value on a radial gauge?
I'd like for this not to show the $11.64. Seems like it's not possible. Can anyone confirm?