-
No undefined variables have been added to Variable list
Hi All, How do we dynamically add people to a group using variables returned from a query? This error comes up often, it's not super clear what it means but I've gathered it's when an action requires a fixed input. Same for "Email a Person" or "Shard a Card"
-
Database Management View Instead of Datasets/ETLs view
Currently users view their assets in a list in the Data tab. They have to use naming conventions, or tags to group these assets and the same goes for ETLs. The list can be filtered and includes shared assets by default but regardless it quickly becomes a mess that only encourages redundant asset creation due to low…
-
Custom Formula Default Selections for Slicer/Filter Cards
Currently, Domo’s slicer/filter cards require manual selection of default values, which can be limiting for use cases where the default selection should change dynamically based on the current date or other conditions. I propose the ability to set dynamic default values for slicers using conditional logic. For example,…
-
Smoother / Quicker method of entering 'Editing' mode reports
As I develop reports it gets very tedious having to continue to go through all the steps needed to enter the edit mode. It would be amazing if I could simply right click on the dashboard / app canvas to initiate the editing mode.
-
How can I scale a line graph to actually show the trend?
Hello I have a line graph of actual # and the full year tracker of our target/stretch goal. This is a sum of all 3 areas and can filter to only show an areas progress. How can I use the scaling to actually show the tend line? Currently it is just a thin narrow straight line that does not show any progress? Thanks, Garrett
-
Notes Tile in ETL
I know that we can make notes on every tile, but what I would love to see is a note tile where all it is, is a note. Sometimes I want to make generic notes in the ETL that relate to a few steps, or an overall process, or something relating to the business question not the tile specifically. So a notes tile would be great.…
-
Display Row count at every step in Magic ETL
Currently if you want to know your row count in Magic ETL at any stage other than the out put, you have to place a few temporary tiles to get there. I.E. add a rank and window tile to establish a Row Number column then aggregate with a group by to get the max row. Would really love if each tile could show the rows…
-
Need help with specific code that is not working in either beast mode or magic etl formula tile
Hi the following code I am using as a filter on my card and have it set to "on list" its called skus to be purged "CASE WHEN On Order = 0 AND (Future Demand = '' OR Future Demand IS NULL) AND (Future Books = '' OR Future Books IS NULL) AND (Reserved + WMAVAIL <= 10 AND WMAVAIL > 0) AND WAREHOUSE_CODE = 11 THEN 'On List'…
-
Image not working in text card in app/dashboard?
I build in app(dashboard), having 4 text cards where i added image and some texts. It is working fine with me, but when i shared it with audience, they can't see image in 1st three cards, while they can see on 4th one.
-
Pivot Table Date Range
Here's my pivot table setup: Rows= Project Name, Financial Category Name Columns = Financial Month Values = Actual Cost Works well so far, but what I'm now looking for is to only show the date range of the projects included in the pivot, so Financial Month would be the way to go. However, in the Date Range Selector, the…
-
Replicate Spreadsheet P&L in Domo
I am hoping for help in recreating a simple P&L generated by my finance team in Domo. Attached is the concept in excel format. I'm looking for help on the following: What is the best way to structure this data? I have the data for the revenues and costs in a table where each row has the Period amount (i.e. Jan 2024), and…
-
Join in ETL
Question: I have two separate databases where there is only one common column, which is the "salesperson." The first database contains sales values for each salesperson. The second database contains the area of operation and products associated with each salesperson. I plan to create a new column to calculate the…
-
Period Over Period Charts
Period over Period cards are pretty limited; there's no Period Over Period Table and the graphs don't allow for a series. This forces users to have to either solve for it in their ETL's or write complicated beast modes. Often times going this route forces you to have to not allow date filtering on cards which further…
-
How to get Prior Year Values on the same table row
I’m trying to create a row which shows the “Prior Year” value against a field for comparison, simply a 12 month offset of the data as shown below with the "Value" field. This would later enable me to create YoY differences. I will also note that I'm looking for a solution that should be able to transcend filters i.e. you…
-
How do I add a timestamp to the new rows that are coming in through my recursive magic etl?
I currently have a recursive magic etl set up to 'screenshot' data that is different from the source data. This information has been helpful because we can see the historical data any time a row in a column is changed. Like keeping a data log of all changes. However, I need to add a timestamp each time the recursive magic…
-
How to show a grouped Column with a CASE logic
Hi, could smb help me on the issue below please: the below CASE model for 'Royalty add on' is splitting my ORGANIZER 'Live Nation Italia' into 3 columns creating splits also for Autorization and Shipping exp. The idea is to have a sum of all these values and see only 1 column for Live Nation Italia. I know for sure that…
-
Is it possible to use PDP to send a card only to people that are part of the card dataset?
For example, if I have a card that is designed to show past due sales opportunities, I want that card to be sent to any sales person on that list. If it runs today, it would be sent to people 1,2, and 3. If it ran tomorrow after data is updated, it would then send to people 1, 2, and 6 because they now appear in the…
-
Create a concatenated field as part of SQL query and use it in Salesforce Adv connector merge key
I am working on setting up a Salesforce Advanced Connector, and use the query mode to select my data. In this selection, I created a custom field called merge key as below, CONCAT(CaseNumber, '_', LastModifiedDate) AS Merge_Key # also tried below, but same result CONCAT(CaseNumber, '_', FORMAT(LastModifiedDate, 'yyyy-MM-dd…
-
How set default values for variables in workflow?
-
Getting data from Current Month backwards as Past Due and Future
I am trying this code but still cannot get data from previous month from last year 2024. All I got in "Past Due" is data from current month (January) and in "Future" I get all the data from future month plus from last year CASE WHEN MONTH(`SSD`)<=MONTH(CURRENT_DATE())AND YEAR(`SSD`)<=YEAR(CURRENT_DATE()) THEN 'Past Due'…
-
Recycle Bin
A "Recycle Bin" feature in DOMO: any object that is deleted (card, page, dataset, dataflow, etc.) would be placed in a Recycle Bin. After 30 days from the deletion date, DOMO would permanently delete it from the instance.
-
How to delete inactive user in DOMO by using the workflow
Can someone help me on How to delete inactive users in DOMO by using workflow automatically
-
Remove Inherited Color Rules from Drill
Currently any color rules applied to a card are also applied to its drill views. This can be helpful when the drill view uses a similar chart type to the original card, but can be confusing to data consumers if the same field is used in a different way in the drill. It would be nice to be able to remove inherited color…
-
Salesforce Marketing Cloud Rest Connector/ExactTarget Connector
We are trying to extract email data at the subscriber level with sends, opens, clicks and timestamps by campaign from Salesforce Marketing Cloud (SFMC). We used to be able to extract the data through ExactTarget Connector but the connector no longer works even with Admin right. We were able to connect through the…
-
Custom Chart from Image
I have an image of a machine that I would like to add into a Domo App. My goal is to allow end users to click on labels or specific components of the machine to see various stats and data for that area. These unique clickable components would act as a filter so that when clicked, the cards in the app would show the data…
-
How do I change a grand total from Sum to Average?
I have the below pivot table. I want the grand total to be an average, not a total. When I changed the aggregation to average, the grand total line disappeared; see second screenshot. The column Sales Difference is a formula calculated in ETL, so I am not sure if that is the problem.
-
Grand Total to Show as Average instead of Sum
I'm trying to get my Grand Total for Revenue as an example to show as an average instead of a sum in a Mega Table. My Revenue calc is below. SUM (CASE WHEN (`Source` = 'Order Items' AND `OrderItems.Type` = 'SpaceOrder' AND `Rank_DateRunOrderItems` = 1) AND `Reservation.State` != 'Canceled' AND `Enterprise.Name` IS NOT NULL…
-
In Domo Workbench select column, * not returning data
I'm new to Domo and Oracle SQL having worked in MS SQL Server until recently. In Domo workbench 'Select column, T.* from Table T' doesn't return any rows of data in the preview window. 'But Select column from Table T' and 'Select T.* from Table T' both do return rows for the preview. I thought my issue might be PL/SQL…
-
Shopify Products and Product Variants report moving from REST API to GraphQL API
Note: this announcement pertains only to the Shopify Connector (com.domo.connector.shopify). At this time, the Shopify Custom App connector (com.domo.connector.shopifycustom) is not affected. Shopify has released a new GraphQL and is slowly phasing out its REST API. As a result, Domo is adding new reports to the Shopify…
-
Locked and Unlocked Cards and Pages
Can we have any domostats that will give me which cards or page is lock or unlock in domo