-
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…
-
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?
-
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…
-
Best updating/appending method for sales records?
So I need to append new sales records every end of month. The sales records are stored as Excel Sheet with these columns: Order Date, Product ID, Customer ID, Sales Amount, Unit Price, Qty, Ship Date. So normally I would just go to the dataset → setting → upload new month dataset in → updating method: append Just wondering…
-
Filter does not work on all cards in an App
So I have Dataset A which contains 'Customer' and 'Account Number' columns, I created a Beast Mode 'id & customer name' = CONCAT('Account Number, ' ', 'Customer') then use that Beast Mode to create a selection drop down filter card called 'Customer'→ add that to an App I have a dataflow that is just an unpivot of the…
-
Unpivot
Say my raw dataset looks like this: And I would like to unpivot any column that has a month name is it, so in this example, it's 'Jan 2024 Total Pts Earned' and 'Jan 2024 Pts Redeemed', and the dataset would look like this (add a date column, total pts earned and total pts redeemed column): How can I do this with Magic…
-
How to change app width in App Studio?
It seems like you can only change app width with 2 options: Fixed width or Auto Width. But both are still too wide for my App. I'd like to make the width smaller by entering a specific px for the width. Is there a way a can do that in DOMO?
-
Any way I can add a column to a card table that I can write comment on it?
I have a simple table card with some columns and beastmode calculations. But I would like to add a blank column where I can write a comment on it. Is that something javascript/css/html can do?
-
Alter Column: file to convert type String to Date
My current dataset has these columns: Jan 2024 | Feb 2024 | Mar 2024 | Apr 2024 ………. and so on. And I'd want my table to just have 2 columns: Date and Point So I used Unpivot tile, but I am unsure how to label my the new Date columns (number 4), so it will turn into a date format using Alter Column tile afterward. Do I…
-
Column failed to convert from String to Floating Decimal
I have a column that show 2023 sales as "$3,432.12" kind of format which DOMO identified as Text. However, I think I need to get rid of the "$" at the front before using Alter Column Tile to change it into Floating Decimal. How can I do that?
-
Find missing records from 2 tables
Excuse me for not providing a screenshot as the data is sensitive but I have 2 sales order details datasets: - A (sales orders for the year 2024 - 1.7M rows) - B (all the historical sales order for all years - 14M rows) - I want to see which orders are in A but not in B. It's pretty straight forward to do a LEFT JOIN, A =…
-
Appending a dataset said "Data updated successfully" but no rows was added?
I was appending rows on my existing dataset by going to Data → pick that Dataset → Settings tab → Details (drag my other dataset in), update mode: Append) → but in the History Tab I saw no rows was added: P/S: I was appending just fine yesterday, so not sure what happened
-
Month filter not working on all cards in an App?
I have 2 card visuals for my app right now. Card #1use dataset 1 (have a month and a year column). Card #2 use dataset 2 (which has a date column, formatted as 'yyyy-mm-dd' And so my goal is to select a Month (say August), and both card #1 and #2 would show the data only for August. But if I create a "Dropdown Selector"…
