-
How do I use data in one column to replace data in a different column in Beast Mode?
I need to create a new column that pulls data in from one column but changes only certain cells to another value based on a value in the same row from a different column. This is what I have tried: CASE WHEN 'column A' = "xyz" THEN 'column B' 'abc' ELSE 'column B' END CASE WHEN 'column A' = "xyz" THEN 'column B'='abc' ELSE…
-
Allow formatting for "Grid Lines" Properties
Regarding the Calculated Line specifically that can appear in bar charts () - please allow formatting or auto default to an abbreviated scale so we don't see 16,000,0000,000.00 taking up real estate on a chart.
-
Support for having reusable ETL Logic
We are trying to redesign our existing ETLs (Magic ETL) whereby we want to have two identical sets of ETLs one for Full Load and another for incremental Load. Since the ETL is complex and there are number of ETLS that will adapt same pattern, we would like a functionality in Magic ETL where we can store entire Business…
-
Understanding Gantt Chart Dates, and Date Filters
I'm struggling with this more than I think I should be, but as always, I probably need an ELI5 version :) I have a Gantt chart where my Start/End Date is my Project Start/End Date. My first question is simple; how do I have my Gantt chart start at today, regardless of what the Start date is? I want today to the last end…
-
How to use Triggered reports with Alerts?
I have tried using the dataset option and it works fine. When I try to do the same using Alerts the Enable button on top does not work. Has anyone faced the same issue? Also, are we supposed to disable the alert?
-
Application upgrade tracking
I am tracking an application update on devices. I have a dataset that looks something like this. I would like to: 1. Count # of devices that upgraded to the latest app (Column App1). Ex. is 1002 and 1004 that has 2 versions, I only need the latest which is in column App1. 2. Count # of devices with app1 and app2 3. Count…
-
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 do I restart automated report emails after an unsubscribe?
I was sending a report to a company Google group until someone in the group unsubscribed from the report. Apparently, that individual action unsubscribed the entire group from the report. Now, I am no longer able to send the report to the group. After I reset the report for sending, nothing happens. I now have to manually…
-
How do you remove some column data?
I have a column with true and false values for emails. I want to remove all the false values, but when I do, I lose the other columns (meetings and calls) in the table chart. How do I remove just the false values, but have it not apply or filter out all the other data columns?
-
Rename Filters? Persistent Filter Selections?
Hi all, Two questions today: It it possible to rename filters as they appear at the top of a dashboard? Some of the attributes I'm using for filters have ugly names, and then Domo also adds on the "_p" to the end, so the filters area doesn't look very good visually. Is there some way to have the selection options within…
-
Is there a way to pass in a body to an HTTPS GET request within the Domo Connector IDE?
In Domo's Custom Connector documentation, they talk about the 'httprequest.get(url)' funtion (see here: ). Unlike PUT and POST, there is no argument available to supply a body to the GET request. Is this a missing functionality, or am I supposed to pass in the body a different way? Without this, there are several API…
-
Failure to parse date/time
Any help on this would be appreciated, I can't seem to get rid of this error and I'm not sure what I'm doing wrong or what I need to check. I'm duplicating an ETL we currently use for a similar dataset, but this dataset is separated by day, rather than month.
-
Is possible to made a "not in" condition in PDPs?
Usually I use PDP giving access to some areas, but for exceptions I can not just give access to everything, like Employees of Area A but not access to a specific employee out of 300 is posible to use a not in for a PDP?
-
Distinct Count of Donations and Distinct Count of Donors with those Distinct Count of Donations
Essentially we would want the distinct count of donations to by the buckets and the distinct count of donors to by the Y axis. But we want to be able to do it dynamically so that we can adjust date ranges on the card level to whatever we want. So I don't know that I could do this in ETL without pushing it through each…
-
PDP: Using Not Equal To a Value
I have a column that needs to be used in PDP. There are 26 values in the column (that may get renamed or added to a few times a year). I have a group that needs all the Values except for 1. I am wary of adding the permission and selecting the other 25 currently available given there may be a change in the column values…
-
Switch Dataset Dynamically
Can we switch dataset (not database) dynamically while running report in Domo ?
-
Is it possible to schedule a report in less than 15 mins interval?
-
Issues with Hovering for Plots Once It is Embedded
Hello, I created a hovering feature for one of the plots with linebreaks via a beastmode. The hovering works fine within the Analyzer feature but once I try to embed the card, the linebreaks are removed and I see the '\n' that indicates where I placed the linebreaks. Is this a common embed problem and if so, how can I move…
-
What are all the reserved words in creating a new dataset?
We are using the Stream API to create datasets. This is all dynamic so we have no idea what the data is going to be or what the columns in the source data are called. What we found is that if the source data has a column named 'row_number' the call to create a new stream dataset will fail but with no message or…
-
DDX: Getting Data in DDX form
Hi, I'm trying to bring in data in a DDX form, from a Domo dataset column using domo.get api using the following code. But I keep getting [object Promise] as a response. All I'm trying to do is getting the distinct value of column "Version" and populate in one of the DDX form input. The value in this column is same for all…
-
Building Data Mart inside Domo
Hi, Can we build Data mart inside Domo? Are there any challenges or limitations we need to consider?
-
Charting
I am new to Domo and busy learning Analyzer. I'd like to know how to convert a bar chart (with two variables) into a line chart with percentages, so if you have a column with 75 Male General Managers and 50 Female General Managers, another column with 100 Male Executives and 50 Female Executives, and a final column with 65…
-
Beast Mode
Hello All, I want to build a card comparing cy with py grouped by location. My plan is to use bar chart side by side comparing cy to py. My beast mode calculations seem correct when I create a table with them. When not comparing to PY, I just built a filter to include the dates i need, and it works fine but when comparing…
-
ARR Between Two Date Columns (Sub Start and End Dates)
I have three columns… Subscription Start Date Subscription End Date Subscription ARR Subscriptions are typically one year but not always. I want to chart ARR by month which is defined as the sum of all of the ARR for subscriptions active for each month. X-Axis = Months ←- Not sure how to do this because if I pick Sub Start…
-
In-Dashboard Navigation Options.
We have developed a pretty long dashboard that encompasses a large number of different components. As a result, our dashboard length is exhausting from a UX lens - especially if your area is closer to the bottom of the page. A card interaction or contents style card would be a fantastic addition to enable page navigation…
-
Set the default value of date type Variable to current date or today's date
A date type variable needs to have a functionality where the default value can be set to today's date
-
How do I get percent of total on pie chart?
How do I get the percent of total on a pie chart? I added pie name and pie value, then change the pie value format to a percent. Rather than giving me a percent of a total, it is giving me the percent. For example, one of my numbers is 799. When I change the format to a percent, I get 79,900%. What am I doing wrong?
-
Calculating MoM, YoY, YTD in table
Hi Domo users, I have been trying to figure out how to represent some values in a revenue table and hoping you can help. Here is what I have so far: As you can see above, I have something like this cable that I want to replicate in Domo. For the most part I can do this in a pivot table in Domo, however I am not sure how to…
-
Enable pfilters for Variables
While it's possible to use pfilters to pass parameters to cards and pages via URL, this does not seem to work with the Variables recently introduced, although visually they appear in the filter var when you apply them at the page level. This would allow a higher degree of control when creating links to navigate between…
-
Comparing YOY trend lines
I'm struggling with building a chart to show YOY trends. I was able to use a combination of the following beastmodes to create the following chart from a dataset containing a small amount of data. But when I attempt to do this with a large dataset, it doesn't work (I'm wondering if it just requires too much processing).…