-
Within an App, can I filter only one card & have it not affect (filter) the other cards in the app
Within an App, can I filter only one card & have it not affect the other cards in the app (they all use the same data source). Also can users add & save personalized filters in a card (shown below) by selecting + Add Filter, choosing one, and saving?
-
Cannot use Domo to create cards because field edit (pencil or drop down) does not work
Cannot use Domo to create cards because field edit (pencil or drop down) does not work. Same issue using Chrome or Edge. Still cannot navigate to multiple screens using taskbar thumbnails (I can navigate using ALT+TAB). Chrome pages take long to load. Seems like page gets stuck but loads if I click on URL bar. The 2 last…
-
How do I add a Field to the 'Card Title' or 'Description' even if it is not a card filter?
I have successfully added Year (2023) & Category (111, 123, 132, 134) to 'Description' to my card (screen shots) because they are user filters. Is there a way to add, for example, Current Page (also shown below), even if it is not a filter? Also, when the data is exported to excel, Year (2023) & Category (111, 123, 132,…
-
Workbench job that I created on 2/25 & set to append one day back, scheduled job ran multiple times
I built a workbench job on 2/25 & set it on a schedule to append with the logic at the bottom (appending one day in the past at a time). Even though I had it scheduled for once daily, for some reason the job the job ran twice as a "scheduled update". Any idea why this might happen, and is there any documentation of…
-
How Do I Resolve This Error: ERROR:Dataset row count does not match. Expected: 0, actual: 4899545
I removed some data (Deleted dataset updates back to 2/15) and am running an APPEND job, but getting this error, how do I resolve? The Domo server reported an error while performing analysis: 'ERROR:Dataset row count does not match. Expected: 0, actual: 4899545.
-
How to import date/time values in workbench exactly as 8/26/2024 9:00:49 AM, without any transform?
I am using the Domo workbench to import data that includes two fields, OrderDate and TransactionDate, which are in date/time format. My goal is to import these date/time values exactly as they are, without any modifications or timezone shifts. For example, if the OrderDate is 8/26/2024 9:00:49 AM, I want it to be imported…
-
Why are all of these dates (Due_Date, PO_Date, Print_Date, Ship_Date) returning the date - 1 day
When I run the following query in SQL Server, four date fields (Due_Date, PO_Date, Print_Date, Ship_Date) return the correct date, but when I run my query in the workbench, the resulting 4 dates are -1 day (Example: date when run in SQL Server = 2023-05-04-00.00.00.000000, the correct date, but when run in the workbench my…
-
Removing leading zeros from PO_Number, (using OPENQUERY)
I've tried the following 3 things to remove the leading zeros from PO_Number, (using OPENQUERY) in the workbench without success, any other suggestions please? Using CAST and LTRIM: SELECT * FROM OPENQUERY(ACME_CO_PRD, 'SELECT LTRIM(CAST(CAST(fd.PO_NO AS INT) AS VARCHAR)) AS PO_No, 2. Using PATINDEX and SUBSTRING: SELECT *…
-
I'm in Analyzer, how can I sum the totals for only some of my columns
I'm creating a card in Analyzer and currently using chart type "Table". Other than changing my chart type to Pivot Table, how else can I sum the totals for my columns……but not all, only some of them?
-
Why Is the Pivot Tile not Working as I Expected
I am trying to use the Pivot tile to accomplish the following (in my attached dataset), but am getting no results under the column I am creating (Weekend_Date_Pivot). Weekend Date should now be columns with Demand_Qty as the metric under each Weekend Date
-
Error in workbench, Dataset is currently locked and cannot be executed right now
I created a dataset with the following SQL query 6/1/24, and on 8/8/24 I began getting the following error: The dataset is currently locked and cannot be executed right now. The likely cause is the Job is open in the UI or has unsaved changes. I have confirmed that the job is not open in the UI and has no unsaved changes,…
-
in the Domo workbench, can't separate TransactionDate (date/time format) into 2 pieces
I have created a job in the Domo workbench with the following SQL query, but in my resulting dataset, "Transaction_Date" and "Transaction_Time" are not splitting into two columns, one with just the date (2021-09-02) and the other just the time (01:00:21.000)….I am still getting both (2021-09-02 01:00:21.000). I have also…
-
How to combine multiple values for one item separated by a coma
There are multiple lines (column titled: PO Number, one on each line) for a given item number in my data. I want to combine all of the results for PO Number so they appear on one line, separated by a comma (shown at the bottom). Item Number PO Number 63631 235084 63631 231656 63631 227775 63631 235084 63631 231656 63631…
