-
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…