Best Of
Re: How to create 2 Output Dataset in DOMO (unable to load this dataset issue)
Can you screenshot where you are seeing "unable to load"? I am having trouble understanding where you are seeing an error if you are seeing everything as green and succesful.
mhouston
Re: MySQL Join Optimisation - 2 hours, for what should take seconds!!
Have you used an SQL transform to add indexes to your two tables on id, id2 and date fields?
Alternatively have you used the new MagicETL as that will be much faster.
Re: Quick Select Multiple Columns in "Select Column" ?
@jkuleszynski this would be good to submit as an idea in the ideas exchange
mhouston
Quick Select Multiple Columns in "Select Column" ?
I am wondering if there is a way to choose multiple columns quickly when using "Select Columns" in an ETL. I do not mean using Add All Columns. We do not know SQL, and we have massive DataSets with a large amount of columns (50+), but only need a mix of about half & half between 2 Datasets. Having to scroll through & choose each column one by one is VERY cumbersome. Is there a shortcut we can use to select multiple columns from the options to add all at once?
Example, I have 2 DataSets I have joined that together, contain about different 50 columns. I only want to add about 20 of them. Do I really have to pick them & add them one by one? Thank you!
EChaney
Re: Multiple measures in one card?
Hi @NateBI
You'll want to use a Magic ETL and Unpivot your data such that you have a column for the different types of clean and then use that column in your Pie Chart. The pie chart only supports a single value for the pie name.
Re: Smarttext showing actual dates used
It doesn't appear to be currently possible within the smart text on a title however you can utilize a notebook card and add a summary number to display the minimum or maximum values in your dataset.
https://domohelp.domo.com/hc/en-us/articles/360043430233-Adding-a-Notebook-Card#4.
I'd also recommend adding this as an idea to the idea exchange on the Dojo for product to look at.
Re: Smarttext showing actual dates used
@Jones01 You can customize your summary number by wrapping it in a CONCAT() function like the examples in this article: https://domohelp.domo.com/hc/en-us/articles/360043430093-Sample-Beast-Mode-Calculations-Card-Element-Transforms#4.
Here is an example of what that could look like:
CONCAT(DATE_FORMAT(MIN(`Date`),'%m/%d/%y'),' - ',DATE_FORMAT(MAX(`Date`),'%m/%d/%y'))
Re: Period over Period and global date selector
Yes as the data is filtered to that specific range and you no longer have access to the prior period data.
I recommend utilizing a custom period calendar date to allow you to still have the PoP values even if the data has been filtered to a specific time frame. I've written up on this before here: A more flexible way to do Period over Period comparisons
Re: why is greater than filter not working for date.....????
I believe there is a glitch right now with the filter tiles. The way I have gotten around it is to use the formula function in the filter and then wrap the date function around each item so that it sees them both as dates. Like this:
DATE(`mydatefield`) < DATE('6/30/2021')
