-
Have a row displayed with 0/NULL when filtering by date when there's no data
Tried my best to summarize in the question... I have a data set of Google Adwords Data. I'm putting the data into a Pivot table and have campaigns as a Row. I'd like to have every campaign show in the table even when it has no data to report for the selected time frame. It essentially would the the row for the campaign and…
-
💯 Another New Coach Climbs the Ranks — Congratulations ArborRose!
We're impressed, to say the least. @ArborRose is our third coach of the month and is more than deserving of this prestigious title. This achievement marks him as one of the community's top users and shows just how knowledgeable he is in all things Domo. He's been a member of the community for a couple years but this month…
-
Caps and not caps in Beast Mode
Hi! I'm trying to pull data into a card where the data varies, but what I want always has the text 'thd' in it. I was fine until my stakeholder wanted us to change the data that is getting sent to a capitalized version, so now I have to account for both caps and not caps. Because all of the Event Labels contain a code, I…
-
Static Rank beast mode
When creating multiple ranking tiles in ETL, the performance is significantly slowed and the dataflow takes hours to run, in comparison with less than 1 hour without ranking tiles. Therefore, I would like to be able to use beast modes to create static rankings. Currently, if you use the rank function in a beast mode, the…
-
Renaming Columns and NOT breaking cards
I am barely getting started with the vast DOMO world so forgive me if this is an obvious thing. I was recently creating a dataflow and some cards from that dataflow and decided to test something out. I created the card using a column from that dataflow and then proceeded to change the name of that column in the dataflow.…
-
Failed to Execute - Domo Workbench
Hi All, I'm getting this error when trying to execute workbench job. "Position is not in format ColumnNameRowName." Any help appreciated. Thanks!
-
ETL calculation to work out hours taken from a start and finish timestamp
Hi all and happy Monday I have some data i am pulling in via a SQL workbench that gives us a time clocked onto a job and another column for clocked off the job. The data is in a the format 2022-12-23T14:27:20. So i am trying to generate a calculated column that gives me the hours taken per job, for example: Clock on =…
-
Custom Padding for Embedded Dashboards
Currently, the desktop version of Domo Everywhere has default padding on the left and right side of the dashbaords making the cards all centered. Sometimes when embedding into external websites this default padding is no longer included, making the cards off kiltered or even too close or far away from one another.…
-
CSV Advanced Connector Error (SFTP) - Failed to execute import successfully.
I am trying to connect to a file from a sftp location in Domo but getting the error: Failed to execute import successfully. Does anyone have encountered this issue before? I do not have access to the file myself as it's on the client side so I cannot view it to validate. Any help is appreciated. Thankyou!
-
Apps Issue
In the domo app studio, I have created an app. But I am unable to change the landing page of the App, earlier i created a page and it was set as a default landing page in domo appp but then i created a new page and I have to change it. How i can do that, I am not finding any options in app, everything is greayed when it…
-
Domo workbench - "attempting to open data source"
When a workbench job is executing, does anyone know what is happening when the preview window execution step says "attempting to open data source"? We will have a job that gets stuck on this step for several hours and it is unable to get past this step, then the query times out. The workbench job is executing a stored…
-
Trying to use SSMS to connect to Domo Server via Domo ODBC Driver
I have configured the Domo ODBC driver and setup a DSN. I'm trying to establish a connection to the Domo Server so I can query multiple tables via SSMS. My understanding is that this needs to be done through a linked server. However, I have not been successful getting the linked server to work. Has anybody been able to…
-
More Grants
Lately I've been running into limitations on custom roles due to the lack of some grants. Mainly around a "view only" user experience. Many actions are tied to development activities. For example, to be able to share pages, you also have to be able to edit pages. To be able to share cards, you have to be able to edit…
-
Lag a pre-existing column?
Hi there, I'm wondering if it's possible (with Magic ETL or beast mode) to creation functions (like rank and window) that can lag value from Column 1 to Column 2, where both columns already exist. Full context: We have 3 columns. Monthly total, Last month, Year to date. I'm trying to generate a new YTD total every month by…
-
How do i fill in rows of data with previous row info?
This… into this via magic etl
-
Bring data from Comscore through API connection
Hello, I have a request to bring Comscore data in domo. There is a Comscore connector available but that doesn't allow me to pull the files which I need. What are the other Domo connector options available to connect Comscore data through an API connection in Domo? Thanks in advance.
-
When alter columns can't change column type, what else can I try?
-
Ranking beastmode with fixed rankings
Has anyone been able to create a beastmode rank that does not recalculate when filtering? I know I can create a static rank in the dataflow, which I have done, but I'd like to figure out a way to mimic a fixed rank in beast mode for those times when I have to do a ranking on the fly and don't have time to run the dataflows…
-
Card Sharing
I am having an issue with a card on a dashboard not being visible to select users. I created the dashboard then subsequent cards and shared users to the dashboard Share Permissions Then after initial launch I added a card. I am getting users reporting that the card I added after the initial launch is not visible When I go…
-
3 Key Features Missing in Gantt Charts
Vertical Scroll Bar. Currently, when we have a lot of data to display, we are forced to have huge Gantt Charts so that the text is readable, or we are forced to keep the Gantt Charts smaller, but accept that text will not be readable. The ability to add additional columns to the left of the Gantt Bars. It should be…
-
How do I filter by most recent date?
We have a dataset that get multiple 'loan_id' entries recorded (shown below) However, when I go to remove duplicates on any of the columns, I generally get the wrong loan amounts. The correct loan amounts are always the ones with the latest 'time_stamp' I am hoping to remove any duplicate 'loan_id' based off the latest…
-
Using a simple case when function not working
Hi so I am trying to use an if-then statement in beast mode but it is not giving me the correct output. The field I am using in this code is product status and these are following values inside it. What I am trying to do is bucket the values into two buckets one which is repeat and one which is new. The code that I am…
-
Joining row data
Hi, I'm trying to combine several row data that have a similar dimension. For instance, i want to aggregate all of the lists_name's into one row next to 2024 Collection - Launch #4. so turn this… into this…
-
How do we hide/merge duplicate cells in a column in HTML table
Hi Domo team and users, I am using an HTML table for my card, because I need to implement some cell specific conditional formatting (not shown in this screenshot) and only HTML Card works out for this. But while using this visual, there is no option to consolidate the repeating vales in a column. Any insights on this is…
-
Create a pfilter to filter a Report Inventory on a different page
Hello, Our company has created a Report Inventory Card, Data Catalog Card, and Data Glossary Card. These cards are together on 1 dashboard (dashboard ID: 1212036684) and we have a filter on the dashboard to filter based on any dashboard ID which will then show all reports on the desired dashboard and all the definitions…
-
Allow users to collapse/hide columns in table cards
Our clients often ask if they can hide columns displayed on a pivot table. It would be good if there was a collapse button on the column header and if the state was remembered via a cookie or local storage so it remains hidden/shown when they visit the dashboard next time.
-
Domo metadata should be able to detect what SalesForce objects are being used in connections
It would be convenient if Domo was able to report on what SalesForce objects are being used the same way it can report on what fields are being used in datasets. I'd like to see a list of the objects being used across all of the SalesForce connections in my Domo instance.
-
DOMO PPT-Add In: Summary Number be Imported as PPT Text Box
In the current PPT Plug-in, you can import a card (i.e. chart) and it will also import the summary number (when available) as a text box in PPT. We love this functionality because it allows us to edit the font, size and color of the text. In the new PPT Add-in, if you load in the summary number, it is not an individual ppt…
-
How do I get started with MySQL Dataflows?
Hello all, I have roughly two years experience with creating Magic ETLs, but no experience with MySQL dataflows. I'm seeking to experiment with MySQL just for the sake of experimentation. Background: I've written thousands of Case When Statements for Beast Modes and calculated fields, but have very little actual SQL…
-
Disable the collapse option
Hi, Is there a way to disable the collapse option on a table so users cannot collapse a table. I want all rows to be visible. Thank you