-
Adding Calculated Total Rows in a Pivot Table?
My sample dataset: Pivot table using Region Code Name & Account as Rows, MTD as Value will show just like the picture above. However, I want to add calculated total rows, so that my pivot table would show like this: individual Region Code then the Total for each Account as each row. Is there away to do that with Beastmode,…
-
Previous Month with Lag Window Function?
I have a sample dataset like this: MonthEndDate Amount Aug, 2025 80 July, 2025 70 June, 2025 60 And I'd like to have another column called "Previous Month", but I'm not sure how to set that column up with Rank & Window tile in magic ETL? MonthEndDate Amount PreviousMonth Aug, 2025 80 70 July, 2025 70 60 June, 2025 60
-
Change Value Over 100% in Multi Column Card?
I have 2 column: YTD vs YTD Budget I used a multi value card with Gauge Value = YTD & Comparison Value = YTD Budget: For example if my YTD = 11.75 & YTD Budget = 12.76 The % change you see in this card = (YTD Budget - YTD)/ YTD *100 = 8.68% But what I want to show instead = (YTD Budget/YTD) * 100 = 108.68% Anyway to show…
-
Attributes to create dynamic group?
I want to create a dynamic group in DOMO (More → Admin → Group). Example: I want to create a Sales Rep group where I would like to use 2 attributes: Title = 'Sales Rep' Status = 'Active' But I cannot see those 2 attributes when setting up the Membership Criteria. They are both Managed Attribute
-
Get the most current run batch using Magic ETL, filter by batch?
I have a sample dataset where everytime this dataset runs, it append to the original dataset. For example, this dataset has ran 2 times in the past, one on Aug 17 and one on Aug 24 (so every Sunday) batch_id batch_last_run 1 17-Aug-25 1 17-Aug-25 1 17-Aug-25 2 24-Aug-25 2 24-Aug-25 I would like to use this dataset as an…
-
Is it possible to create case when for ALL?
I have a column 'channel_id' with 5 id from 1 to 5. I want to create a case when: CASE WHEN channel_id = 1 THEN 'Facebook' WHEN channel_id = 2 THEN 'Instagram' WHEN channel_id = 3 THEN 'Tiktok' WHEN channel_id NOT IN (1, 2, 3) THEN 'Others' WHEN channel_id IN (1, 2, 3, 4, 5) THEN 'All' END So that I can have this column as…
-
How to set up alert properly. Which cards to use?
Say I have a table card or a summary number comparing Sales MTD vs Sales MTD Last Year, and the % change. I want to set up an alert so when the % change is less then -5% then send me an alert with message like this: "Your sales decreased -5.88% comparing to MTD Last Year" I could not figure out how to set this alert up.
-
New feature: Advance Date Filter Control. Is it a car, variable, or the controls in App?
Current Release Notes Domo has a new feature. But I am not sure whether it is filter card, variable, or a control in App? I thought in analyzer, you already have the "Date Range" feature? Are they the same thing?
-
Difference in dataset granularity and filters
I have 2 datasets that power 2 table cards: In-stock by Product Branch - this dataset will power a card call "Inventory Inquiry by Product Branch" which has columns: product, branch, available qty, allocated qty, in po qty (= aggreagated sum of all open po transaction) Open Purchase Order Transaction - this will have Order…
-
Promoting App, ERROR creating variable control
I have an App made in Development Instance, some of the cards in the App have beastmode calculations that use variable in it. When I promote this App from Development to Production Instance, I have this error but I'm not sure what's the problem is or how to fix it.
-
View & use all the ETLs and datasets created by different users
Say my team has 3 people, each of us has an individual DOMO account. We import/cloud amp datasets and use those dataset in ETLs on our own account. But if my teammate needs to use a dataset or an ETL that I have already created, I have to manually shared with them as co-owner. Is there a way that all of us can see and use…
-
1 customer assigned to 2 sales person, how to show the total correctly?
Customer Sales Rep Customer Current Points Balance Bob a 75 Bob b 25 Tina b 125 Jimmy a 65 Above is an example dataset. I have an APP that has 2 filter cards (Customer & Sales Rep) and a single value card showing 'Customer Current Points Balance'. So that when I select: Customer = Bob → then Customer Current Points Balance…
-
SUM(DISTINCT) based on another column
Customer Sales Rep Sales Manager TOTAL Customer PTS Bob a Rudy 100 Bob b Rudy 100 Tina b Rudy 125 Jimmy a Rudy 65 I have a sample dataset above. As you can see, Customer Bob is assigned to 2 Sales Reps & the Total Customer PTS = 100 no matter which Sales Rep it is. Since I'm the manager Rudy, I want to see the Total…
-
Multiple progress tracking bars
I want to track KPIs against set targets. Is there a way to create a chart in DOMO where: Y-Axis: Represents KPI metrics. X-Axis: Shows actual vs. target values. Even if the upper target limits differ for each metric, the bar lengths should remain consistent. Additionally, can the bar colors be dynamically set based on…
-
Date filter card: default select last month dynamically?
So I have a dropdown filter card called 'Date' in my App, user wants to default that 'Date' in the App to be last month - with the option to multi select other months, currently I'm have to manually update the Filter View. For example: Today is Jun 20, 2025, Filter View: Month End Date <= '2025-05-31' → 'Date'' show…
-
Send email to people who I have shared the App with
I made some changes to an App, I want to send email about those changes to people whom I have shared the App with. I haven't used workflow before and it seems very confusing. So I couple of question: How do I get a list of people whom I've shared the App with?
-
Multi Levels Sankey
I'd like to make a revenue sankey chart like this, is it possible in DOMO?
-
Find Max rank from a ranking column and fixed it so it doesn't change when filter applied.
Say I have dataset ranking all the sales rep by their Margin FYTD: SALES REP CURRENT MARGIN RANK A 0.5 1 B 0.4 2 C 0.3 3 D 0.2 4 E 0.1 5 I'd like to add a text column so instead of rank 1 it's '1 of 5', etc. To do so I need: CONCAT(`RANK`, ' of ', MAX(`RANK`) FIXED()) which is easy but the hard part is if I'm interested in…
-
Color rule a column based of another column? Color rule for text?
I have a table card with these columns: Account Name, MTD, MTD Budget I want to apply color rule to MTD column so that when MTD is below 10% of the budget, color that MTD number red, else green. So in this example, 100 would be red, and 500 would be green. Account Name MTD MTD Budget Sales 1000 2000 Expenses 500 400 Is it…
-
Editable Table Card with pro-code editor, can other people edit the table card as well?
Following this tutorial, I used pro-code editor to make a table card that allow you to type in whatever you want in the "note" column. It was working for me, I can type and submit. But I would like to share this table card to other people so they can type whatever they want in the Note column and submit it as well, it I…
-
Scrollable bullet chart?
So I have a lot of categories that that I would like to see their actual numbers vs target numbers, but the card looks like this on an App. Is there anyway i could increase the bar width and make the chart scrollable?
-
Individual column filtering for table card
I have a table card with multiple columns that I would like to have ability to filter each column within that table card instead of having to create multiple filter cards for each of the column. Is there a domo brick that could do this or similar? Thank you P/S: I know you can sort of filter column with table card by hover…
-
Compare gauge value with more than 1 target/comparison values
With Multi Value or Multi Value Column I can compare 1 gauge value with 1 target value. But is it possible to compare 1 gauge value with 2 target values like this: Gauge Value = Income Target Value 1 = vs LY Target Value 2 = vs Budget
-
2 lines & 1 bar chart
There's a group bar chart that allow you to have 2 bars and 1 line for each x value: But is it possible to show 2 bars as lines and the 1 line as bar instead?
-
Combine charts for scorecard
Is there any way to combine a multi-value chart with a filled gauge to show on 1 single scorecard like this?
-
Can you create a virtual dataset from a dataset view?
I have a Dataset View from a production instance and I would like to bring that dataset to the Dev instance by creating a virtual dataset of that view. In Production, I was able to create a job for that dataset view, ran successfully, Run Status: Idle. But when I go to the Dev instance, I do not see the virtual dataset…
-
Is it possible to apply a column as quick filter for multiple cards?
In analyzer, we can drag a column in the Filter and toggle on the 'Apply as quick Filter', that will apply the quick filter to that specific card. However, I have multiple cards that I want to apply the same column as quick filter, is there a quicker way to it all at once instead of individually going into a card and add…
-
MTD and MTD Last Year, leap year problem
I want to show sales MTD and MTD Last Year as of Feb 28, 2025 so I created Beast Mode: MTD = CASE WHEN CURRENT_DATE >= SHIP_DATE and CURRENT_DATE <= LASTDAY(SHIP_DATE) THEN 'sales_amount' ELSE 0 END MTD Last Year = CASE WHEN DATE_ADD(CURRENT_DATE, INTERVAL -1 YEAR) >= SHIP_DATE AND DATE_ADD(CURRENT_DATE, INTERVAL -1 YEAR)…
-
Share an App & send email notifications but also getting a text message?
When I share an App and click "Send email notifications", DOMO sent both email and text messages. Is there any to stop DOMO from texting and just send the email?
-
Recreating DOMO Marketing Ops Dashboard Sample
I saw DOMO sample Market Operation dashboard which has : Tabs within a specific chart (Highlights & Engagement) & distribution plot for each day of the week 2 custom charts at the bottom Which I would like to recreate, does anyone know how to achieve this? I haven't seen these function (tab within a card) or these custom…
