-
PDP issue on Dashboard with more than one dataset
I have a dashboard with 6 cards. 4 cards are on General Ledger Data Mart, 1 on Accounts Receivable Data Mart and 1 on SO Document Detail. All 3 datasets have identical PDP using the value of the 'Division' column. When looking at dashboards where only 1 of the above datasets are used, PDP works without issue. But when I am…
-
Input DataSet - Load New data
I am working on a new dataflow using Magic ETL. I have 11 input datasets. All are Workbench jobs with the Update method set to Append and they each have an assigned Upsert Key. I have configured each of the inputs to load New data. When I save my dataflow 3 of the 11 throw an error. "This data set does not support data…
-
Filtering Question
I have a mega table report that is displaying customer invoice data. One of my filters is for the Aging Range. I have been asked to modify the filter to include all invoices for a customer if any of their invoices are in the filtered range. Meaning that in the below dataset if they selected to filter 151-180 all invoices…
-
Partitioning for Dummies?
Can someone point me to a good step by step guide to setting up partitioning in Workbench 5.2? I have a very large dataset (currently 5.8 million rows) that gets updated daily with a full replace. As you can imagine it takes a HOT MINUTE to run. On average there are 12.5k new records and 100 records updated or deleted…
-
Any row is added alert issue
I have had an alert set on a view for the past several months that has been helping us track a bug with a vendor. Essentially we get daily flat files and randomly we will get files that are missing data and are their flagged as 'Problematic'. When I set up the alert 'Any row is added' was was a prebuilt option that I…
-
Removing Datasets
I have been in the process for the past 6ish months of revamping the underlying data structure that feeds into Domo. As part of this I have created new dataflows and datasets in Domo. I still have a handful of reports that are populated from the old dataflow. This dataflow is turned off and the dataset is stale, but we…
-
NULL value Handling
I'm a bit frustrated by this one. I have done everything along the path to ensure NULL values are being handled appropriately in my data. Starting from flat files and ending in a dataset (with several non-Domo steps in the middle). All of my data appears as expected in the dataset, but as soon as I add the column to a card…
-
GROUP_CONCAT function in Dataset View vs MySQL Dataflow
I have created a MySQL Dataflow where I was able to successfully use the GROUP_CONCAT function. It is preferred that I use a Dataset View in this circumstance since the underlying data is coming from AppDB and therefore updates every 15 minutes if there is new data. I have copied and pasted the exact query that is…
-
Displaying 1 to many records in a table
I have created a custom app for my users to be able to add notes to Invoices that are in collections. The relationship is 1 Invoice to many notes. Initially, my plan was to display the Invoice details in a table card ( Customer, Invoice #, Contact, Invoice Date, Invoiced Amount, Total Due, etc.) and the note data would…
