-
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…
-
Can a map chart have bubbles?
My dataset doesn't have longitude or latitude, just the Province Name and Province Code, but I would like to have a world map showing sales as the size of the bubble of each Province. How would I achieve this?
-
Variable & Control showing in a chart
In an App, to use a variable, you need to add a control → basically a filter card in an App or expand the card and see the control on the right side of the chart. However, it'll be easier if the control variable is showing in a specific chart like this, this way I don't need a separate card for to pick the variable control…
-
MTD & MTD Last Year Beastmode that calculate the ratio
so I have a beast mode that calculates the ratio of committed orders % committed count = SUM(CASE WHEN % complete > 0 THEN 1 ELSE 0 END) / COUNT(Order #) but I want to create a Beast Mode to calculate the same ratio but just for this MTD, so I tried this, but it return 0 CASE WHEN YEAR(CURDATE()) = YEAR(MONTH_END_DATE) AND…
-
Bullet chart color rule
I have a bullet chart showing Sales, COGS, GM and it's corresponding Budget Amount As you can see, Sales and Cogs are over the budget, and I want to show the bar color to green. Whereas GM is lower than the Budget, I want to show the GM bar to be grey. How do I achieve this with color rules?
-
Best practice for using the same dataset for different projects
So my team has a Sales dataset that is being used to make a Sales App, this dataset has variables, BeastMode calculated fields that use those variables, and these BeastMode were saved to the dataset when created. Now I'm making a new app that also using the same Dataset, however, I'll need to create different Beastmode…
-
Python Tile fillna on integer column keep return 0 unless I change the column to text
I have a column Bill-To (interger) I use Python Tile to run this script to fill the nulls cell with the previous cell value #Import the domomagic package into the script from domomagic import * #read data from inputs into a data frame input1 = read_dataframe('Select Columns') #write your script here input1['Bill-To'] =…
-
Sandbox Promote created a new App instead of updating the existed App
I have 2 instances: Production and Development I created an App in Dev, have a repository in Sandbox → Committed. Went to Production Instance to Promote it, and it promoted successfully. Then I made some changes to the App in DEV → Committed a new version. Went to Production to Promote it → it create a new App Studio…
-
Date Selector Filter Card: default selection?
I have a date selector filter card on an app (no calendar view, just preset view) & I would like to force a selection 'Last Month' on this card so when someone open up this App, this filter is already selected like this:
-
Add a calculated row in a Table?
I have a table with these 5 columns: Class 3, MTD, MTD %, MTD Budget, MTD Budget %. How can I add a Row below Cost of Sales called 'Gross Margin' = Sales - Cost of Sales?, and it work for both MTD & MTD Budget? Context: My have categorized Sales & Cost of Sales into a 'Gross Margin' Group → then use pivot table to have…
-
Showing negative number as positive but also making sure the Total Row is summing correctly
I have pivot table that looks something like this: Cost of Sales Others & Expenses are negative so that the Subtotal & Total are calculated correctly. I know you can show the negative either in red (with a minus sign in front) or in financial style. But is there anyway to get rid of the positive sign but still making sure…
-
Pivot Table Expansion
Can we have Pivot Table to expand categories in 1 column like this? instead of the expansion is in another column?
-
Don't want chart to show the aggregation (SUM), but also want to be able to filter in App
I have an App with a Branch filter (nothing is selected) & a bar charting showing Total Amount $ overtime I do not want the bar chart to show SUM(total amount) of all branches when no branch is selected. The default should display one branch, with the option to reselect using the Branch filter. Option 1: I set…
-
Month Name in Control is ordered alphabetically, how to get the Month in the right order?
I have a column 'Month Name' and set it as 'Display as Quick Filter' so that the end users can use the filter to pick the Month they want in a card. However, the Month is not in the right order (Jan, Feb, Mar, etc.). I'm not sure how to do it with Quick Filter/Control?
-
FIXED () in Magic ETL?
'MTD' / SUM(
CASE WHEN Class 3 = 'Sales' THEN Amount ELSE 0 END
) FIXED () I have this BeastMode called 'MTD %' that calculate the % of each GL Account based on Sales (so Sales = 100%)And it was working correctly with different branches. Just wondering if I can create this in ETL?
-
MTD Last Year, YTD, YTD Last Year with Rank & Window Tile
Say my dataset has these columns: branch_id, gl_id, amount, Month End Date, fiscal_year, Month Number I'm trying to recreate below SQL Window function with Magic ETL so that for every Month End Date*branch*glid combination has a corresponding MTD Last Year, YTD and YTD Last Year. SUM(amount) as 'MTD' SUM(SUM(amount) OVER…
