-
Need Help: Subtract CurrentRowDateTime - PreviousRowDateTime from same column
Hello, please help me create this in DOMO. Thank you. Here are the columns needed: Alarm ID = (given) TechName = (given) Alarm Handled Store Time = (given) Average Handling Time (AHT) = see detailed formula and condition below Sorting: TechName - A to Z Alarm Handled Store Time - Oldest to Newest Condition: If TechName is…
-
How to show Top % and Other in a stacked Bar Chart?
Hi All, I am trying to come up with a calculated field, that I could use to show the Top 5 and Other in a stacked bar chart. That is how it should look like ( created a sketch in Excel): That is how my bar chart currently looks like in Domo (sample data): Any help is really appreciated. Thank you so much, Sabine
-
Is there a way to bucket columns similar to excel in DOMO?
I am trying to have a pivot table that shows weekly plans vs actuals. Is there a way to add a top layer of that to group the value columns into the top three pillars? Supply, demand, revenue. Thanks
-
best way to replace a subset of data
I have a large historical dataset to which I append records at the end of each day. I have been asked to correct the distribution of values for a small subset of the data over the past nine months. I can use the data repair tool feature to remove all of the data imports for that time, but this would force me to destroy and…
-
Single Value Card Division
I have two single value cards. Card 1 is a overall total of all possible values and card 2 is a filtered subset of card 1. Is there a way I can divide the two cards? I know that you can just make a new beast mode with both calculations (Ex. Card 2/Card 1). However that does not work in my case due to Card 2 being a…
-
How to filter cards by a name dimension
A user recently ran into trouble while creating a dashboard. According to them, the dashboard had about 10 cards in it. One card was powered from one dataset, another card was powered from another dataset, and then 8 cards were powered from a third dataset. Their question: Is there a way to filter all cards by a name…
-
Variables in Smart Text
I have two variables Items Description Is there a way I can add "Description" to a card using Smart Text so that it shows the description of the "Item" selected in the title? Example: User selects Sku: 123456 Title reads "Total Soup Spend"
-
Display additional related values under a graph
Hi all, I have a graph of opportunities that graphed by value, but I also want to display a count in the flex table underneath. I can add a count as a series, but that adds a bar to the graph that I don't want. If I deselect the series in the flex table, the bar goes away, but the text also turns much lighter. Is there a…
-
Percent to Goal in Overlay Bar Charts for each product/brand/client
Utilizing an Overlay Bar allows us to show the actual goal, but only display the percent to goal for each unique client in a hover as opposed to a displayed value by default. The Chart only supports one goal. When trying this on a bullet chart the same issue occurs, no way to display a 3rd unique value without it applying…
-
Add Colors to Multi Radial Progress Gauges
Currently we can't add custom colors to Multi Radial Progress Gauges. I thought it might be a bug since you can change colors on just about everything else, but the option doesn't appear on the documentation. https://domohelp.domo.com/hc/en-us/articles/4546378883863-Multi-Radial-Progress-Gauge Suggestion: Add the option to…
-
regexp_like for pulling specific value out of text string
Hello I need some help pulling out T#### and some T####.### from text string. REGEXP_LIKE('text','/T[0-9]+.?[0-9]+/g', 'n') I am trying to pull the T# out of the following text string and place them in a different column. Data Exfiltration via DNS|T1048.003|T1071.004|T1572 I have multiple rows with different T#'s…
-
Subtotals for Time on a Card
How do I get subtotals for time calculated by beast mode?
-
DDX Bricks - Creating a linkable <iframe>
Hi - Looking for some assistance on editing a ddx brick html table card i downloaded from the appstore. I turned to ddx bricks because i could not get iframes to show up using ordinary html table cards. Now that i have an ddx html table correctly showing my embed iframes in one of the columns, i'd like to add additional…
-
Drill down based on the line or bar being clicked
When I click in a graph to drill down, it only filters on the data in the x-axis (date, basically), but I also want to (optionally) include the line/bar being clicked so that drilling down can be even more fun.
-
Publication Group People Administration - Reorder People and Search by Filters and Values
We use publication groups (pub groups) to display our field rep data. We have several different types of users (basic technicians, territory managers, customer support, etc.) with similar, but different filters. People appear in order of creation and this order cannot be changed. This gets frustrating because I have set up…
-
File contains a virus, please contact Domo support. ref:4153
All of a sudden, all our DataSet via Email Connectors starting showing this error? Multiple sources and multiple file types. Anyone one else seeing this?
-
add group owner (and related fields) to the governance dataset groups
see case
-
Option to delay sending new user invitation email to allow admin to finish user setup
When we set up a new Domo user, it immediately sends them an email invite to set their password and login. At the same time, after creating the user we have to add them to the appropriate group(s) for page access, and configure their PDP rules and run the custom script to apply PDP to their account. This process takes 5-10…
-
HELP! Can not get this ETL Formula to Validate
Can not get this ETL Formula to Validate CASE WHEN HdrParentItemCode IN ('ZROUGHIN', 'ZWATER', 'ZSEWER', 'ZROCK', 'ZVANGUARD') THEN 'Rough-IN' ELSE CASE WHEN HdrParentItemCode IN ('ZTOPOUT', 'ZGAS') THEN 'Topout' ELSE CASE WHEN HdrParentItemCode IN ('ZTRIM','ZDROPIN') THEN 'Trim' ELSE CASE WHEN HdrParentItemCode IN…
-
Fill in Blanks based on existing column
Hi All, Financial Analyst trying to tackle ETLs. Vaguely familiar and can work my way through MagicETL but am stumped on this one. Hoping for some help. I have a data set replicated below. I want to fill the the [BLANK] using an ETL so on the data set where the store numbers are the same and the ticketIDs are the same, the…
-
Allow export to PowerPoint on drill down cards.
Currently that's only available at the top card level. Refer to case 05853246 : Thanks. Hai
-
Restricting Dataflows
I am admin for my instance.. I have shared input datasets to a specific group with a role. But I notice that they automatically get all my dataflows access that include those above shared datasets and they are able to edit the dataflow as well. Is there a option to restrict the access of dataflows (ETLs) though those…
-
Update Date Selector "Chart Type" to Match Global Date Range Selector
<Please direct me to an existing feature request if exists, the closest I could fine was a 'need help' linked below> We are currently using Domo Everyone embed and are limited with our date filter options. The current date selector is clunky and limited. I have to use a ton of dashboard space to get it to look just OK. The…
-
Disabling In-App Dark Mode for iOS
I would like to put through a proposal for the Domo mobile app team to enable Turn Off Dark Mode in the app itself. This allows iOS users to continue to use the phone in dark mode and have the Domo app itself excluded. This is a very basic feature for many other applications in the app store so I hope this can be looked at…
-
Kill/revert Workbench Job
Hi , Can you please let me know if I can kill any existing jobs running .I made changes to query and I am not able to revert back or kill the existing running session .
-
Domo Custom Connector: 3 Design Tips for Building an Effective Product
If you are struggling to build a viable and effective custom connector, a team of Domo users just published an amazing article on Graphable that will help you solve your problem! 💥CODE SAMPLES INCLUDED💥 The Graphable team is a strategic partner for Domo Implementations and Custom Solutions.
-
Customize Color Theme / Reverse Order
I recently built a heatmap table where I want the lowest numbers up top. These start around -25 and end at -10 currently, but the numbers will change each time the chart is updated. I also only want to show 10 rows of data, so the table has been limited to the 10 top results. I want the heatmap to display negative numbers…
-
Join vs Append
I have one dataset date/dept/machine/product/defect/no of def. Second dataset is date/dept/machine/vol. There will be multiple defects on the same date from the same dept and same machine (defect and product may differ). When I join this causes the vol to duplicate for each product / defect entry. How do I create a beast…
-
Congratulate our newest Community Coach, Rob!
Huge shoutout to @RobSomers who just hit the highest rank on the Community Forums! This is an amazing achievement — it takes a lot of work and time spent in the Forums to climb to the top. Thanks @RobSomers for helping so many users in the Domo community. Send @RobSomers some excitement in the comments below 👇
-
Is Domo treating 0 as NULL? Card filtering 0 value as NULL
Hi everyone, is this a legitimate expected functionality or a bug? In my card, I have a filter on NPS Score IS NOT NULL. However, it seems to be filtering out my records/rows with NPS Score = 0. Is Domo treating 0 as NULL?