-
Import multiple files into single Dataset
Every day a new Excel file is dropped into a shared network folder. Every file is in the same format, and each file contains one day's data. Is there a way, using Workbench or any other method, to transport all Excel files from one local folder into a single Domo DataSet? Since a new file is added every day, every file…
-
Correlation Coefficient in Beastmode
Has anyone successfully calculated a Pearson Correlation Coefficient in Beastmode? My idea is to create a scatter plot that graphically displays the relationship between two fields in a dataset, and display the Correlation Coefficient for those two datasets as the Summary Number. For example, if the card is filtered for a…
-
Page Filter: set default value
I would like a page to load pre-filtered, but allow the user to change the filtering via a page filter. Currently I have a page filter for "Fiscal Year" like this: * FY20 * FY19 * FY18 * FY17 and 98% of the time a user wants to see FY20. Is there a way I can set "FY20" to "Checked" in this page filter, allowing the user to…
-
Remove text without removing decimals
Using an ETL, is it possible to remove text without removing decimals? For example, I have a dataset that includes values like this: 1.0 8.54578 N/A 7.49687587125516 ..... Using "Text Formatting" to "Only show numbers" results in the following output: 10 854578 749687587125516 How can I extract the numbers from a column…
-
Populate cards at the start of a new month
Some of my datasets are populated only once weekly or monthly. When a new month starts all of my "current month" cards show "No data in filtered range". Is there a way to specify "most recent month" rather than current month? The idea is to populate cards with the latest month, regardless of if this is also the most recent…
-
Recommended application for online forms & data collection
I would love a recommendation! I'm looking for an "off-the-shelf" application, preferrably web-based, for creating data input forms. Here's the kicker - I have around 800 users, and each needs to be presented with custom fields because they each track different metrics. For example, perhaps my team tracks metrics A, B, and…
-
Filter out junk data
There is a dataset I import using Workbench, then transform using Magic ETL. The data includes values between 1-10, but sometimes will contain a random junk value like 324568. I'd like to filter out all values that don't fall between 1-10, but can't find a way to do this wihtout specifying every possible junk value, ie.…
-
Remove secondary axis
I have set up a line + stacked bar card on a dataset in which all data is on the same scale. By default the line was placed on a secondary axis, but I would like the line and the bars to all show on the same axis. How can I remove the secondary axis? Thanks
-
Workbench Scheduler to Batch Run Jobs
First some background...there are 6 Jobs that I need to run in Workbench every day. The source data becomes available at different times and I need to manually format the sorce files for all 6 before upload, so I can't set a daily time schedule to automatically upload. The last of the 6 uploads triggers an ETL to run, so…
