-
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.
-
Validating datasets that has different formats
I need to validate 2 finance datasets to ensure the numbers match for all GL accounts. Dataset A: Columns: Account_name, Branch_id, MTD, MTD Budget, MTD Last Year, YTD, YTD Budget, YTD Last Year. This dataset is generated monthly from the ERP system, with pre-calculated values. I need to append it each month after adding…
-
Star Schema and Snowflake Schema? Why is it not a thing in DOMO?
It's a very common and even a recommended practice to do data warehousing design when you're analyzing/visualizing data but why is it not a thing in DOMO? It seems like you have to create 1 whole big and gigantic FACT Table every time you want to analyze something when you're working with an enterprise data level. And what…
-
Get rid of Warning message in Pie Chart
Is there any way to get rid of this Warning? I am intended to show the numbers as negative though.
-
Inline Editing and Dataset refresh problem
Context: I have a Dataflow that has 2 Input Dataset (Product Sales 1, Product Sales 2) and an Output Dataset (to find rows that are in Product Sales 1 but not in Product Sales 2). And this Dataflow triggers monthly when Product Sales 1 and 2 get appended. I want to add a commentary column in the Output Dataset using Inline…
-
Legend right next to its Lines?
Is it possible to have the legends next to its representative lines?
-
Using FIXED () and Variable?
I'd like to create a BeastMode 'MTD %' that can: Calculate the % of each GL account based of Total Sales Can be dynamically filtered by Month and Year variables Here's my MTD % Beast Mode: SUM(`Amount`)/ (SUM(CASE WHEN `Class 3` = 'Sales' THEN `Amount` ELSE 0 END) FIXED ()) And my MTD Beast Mode: SUM(CASE WHEN Fiscal Year=…
-
Pivot Table Expansion
Is it possible for Pivot Table to expand in 1 column like this? instead of the expansion is in another column?
-
Income Statement % Column
Is it possible to create a Beastmode (or Magic ETLs) to show a column like % of Net Sales?
-
MTD, MTD Last Year Beastmodes do not work properly with Date filter
I created 2 Beastmodes that I can drag into the 'Values' in the Pivot Table card: MTD = SUM(CASE WHEN Month = MONTH(CURRENT_DATE()) AND Year = YEAR(CURRENT_DATE()) THEN IFNULL(Amount * -1, 0) ELSE 0 END) MTD Last Year = SUM(CASE WHEN Month = MONTH(CURRENT_DATE()) AND Year = YEAR(CURRENT_DATE()) - 1 THEN IFNULL(Amount * -1,…
-
Domo Sandbox Instances
I'm using a shared account to log into Dev environment (https://company-dev.domo.com/). In there, I've imported some datatsets to create 5 dataflows and eventually an APP in the Dev Instance. Then in Sandbox, I created 2 repo: Dataflows (5 ETLs) App It got pushed successfully. But my question is how can I see those…
-
Income Statement: How do I join 'Chart of Account' table & 'GL Records' correctly
I have 2 tables: Chart of Account - Right Table: notice that there are Addon Repairs, Restocking Charges, Contractor Discount in 'Cost of Sales Others' 2. GL Records (for all branches from Feb 2024 - Sep 2024) - Left Table Problem: I've tried both Full Join, Left Join (key: gl_account_id) then make a pivot table (filter a…
-
Delete the most recent update on an existing dataset?
I loaded in a dataset A → Settings → bring in dataset B, Update method: replace (it's supposed to be append). So now I need to delete the most recent update, but I don't have that option since I'm not the Admin. I remember someone answered in a community post saying that in you can add some text into the Dataset History…
