-
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…
-
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…
-
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…
-
Max Slice before 'Other' Pie Chart but applies to Line Chart?
So I have a field called 'title' and there's like 100 unique value in there. When using the pie chart I just want to see top 7 slices/title that has the highest Pie Value. Is it possible to do the same with line chart where X= date, Y = pie value, Series = title (but only showing top 7 titles that has most Pie Value?).
-
Is there a introduction navigating App Studio for end users?
I know that there are App Studio Overview/Walkthrough and Knowledge Base for DOMO developer. But is there anything similar for the end users who just need to get start on DOMO and navigating App Studio?
-
Can you add an 'Export' Button in App?
I have a Pivot Table Card that the end users would like to export to excel or pdf. In order to do that they would need to Expand the Card → Card Options → Export → Export Options. Is there any way that I can add a Button 'Export' in App and take the users to Export Options if they click on it?
-
Filter card always have a value selected?
I have a beastmode called 'Flagged' (value 1 and 0), and I use the BeastMode to create a filter card and then add that filter card to an App. Is there anyway to have 1 or the 2 value always selected? So it's kinda force the users to always select 1 of the 2 options
-
Variable fomat
I created a variable for year, I'm also using that variable as a dropdown selector filter as well in an App. But is there any way to get rid of the delimiter so that the variable show '2024' instead of '2,024'?
-
Create Month End Date column with Year & Month columns?
My dataset has a Year & Month columns, I would like to add a 'Month End Date' Date column into this dataset with magic ETL. But each month has different end date so I'm not sure how to go on about this
-
YTD BeastMode with Variables
I have 2 variables 'Year Selector' and 'Month Selector' that are being used as filters drop down selection in an App But also used within a YTD BeastMode: SUM(CASE WHEN Year Selector = Fiscal Year AND Month Number >= 2 AND Month Number <= CASE WHEN Month Selector = 'January' THEN 1 WHEN Month Selector = 'February' THEN 2…
-
Smart Text with many filters selected, best way to represent it for better users experience?
Almost every time I build an App, there are multiple filters to select up top (Name, Branch, Province, Branch type, etc.) I usually have a smart text to show the selected filters for approriate section. However, the smart text look very busy when you have more than 3 filters selected: Another option is to break 1 line to…
-
Can you change the Smart Text color in App?
I usually display a Smart Text filter in a Text Element in an App. But it would show in a red color which I would like to change Update: I found out how. So just change the setting of the Text Element
-
Smart Text card title show year with a comma. How do I get rid of it?
So instead of '2024 Sales', the title shows '2,024 Sales'. How do get rid of this comma? I used 'Display any filter' Sales as Card Title
-
Move multiple cards from 1 tab to another tab in the same App?
Is there any option to move multiple cards from 1 tab to another all at once? I don't want to create a duplicates of cards.
