Best Of
Re: Re-order page filters
This is really needed. Alphabetical at a minimum is something that I could work with. I prefer the way page filtering works on the Domo app. IMO, filter cards are not easy to work with on the app.
Re: How do I count Not null values in beast mode
COUNT function will count the number of non null records
if you’re wanting to compare to not NULL then it’s the same as SQL
CASE WHEN `Name` IS NOT NULL THEN 'Not Null' ELSE 'Null' END
Re: Get MySQL on latest version
Aside from missing windows and JSON functions in MySQL 5.6 there are security flaws to consider. This is pretty sad that we are still stuck on MySQL version 5.6.37-82.2-82.2. While I realize that Magic ETL is all that there are still a lot of people who find the MySQL dataflows to be their preference.
So I drop my token in the basket to please upgrade MySQL when possible. Hopefully in 2023.
🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Re: Get MySQL on latest version
This really needs to move forward.. we need to be able to use CTE to optimize queries.
Lewis
Re: Dynamic Chart Height
This would be especially useful for scheduling reports off of dashboards since recipients cannot scroll. I often have to leave a significant amount of white space in the dashboard to avoid cutting off the table.
Re: Dynamic Chart Height
If there are a couple of tables in the dashboard and they have quite a lot of rows and you need to filter the data it becomes really complicated to navigate around the dashboard due to a lot of whitespaces.
Re: Accessing Dataset
@mroker if you authenticated in workbench after the dataset was already created under the other user, I think they will still be the owner on the dataset, and will need to either share it with you or change you to the owner.
mhouston
Re: DOMO Display Name reverting back
@WorldWarHulk that seems like odd behavior, I would put in a ticket with support to see if they can figure out what is going on.
Ashleigh
Beast Mode FIXED functions multi-field question
So we're all aware of FIXED Functions and how neat they are as outlined in domohelp.
But one example that I have not seen yet and I'm not entirely sure how to do is a multi-field FIXED function.
In this example I have a simple dataset that's Halloween themed
The question is: "Everybody always yells 'wherewolf' but nobody every asks 'How wolf?'.
So while everybody is writing beastmodes that describe:
AVG(AVG(`Score`) FIXED (FILTER ALLOW `Where Monster`))
How does one write a beastmode that essentially describes:
AVG(AVG(`Score`) FIXED (FILTER ALLOW `Where Monster` /*and also*/ `How Monster`))
G_Grey
Re: Add Left- and Right-Anti-Joins to JOIN Tile in Magic ETL 2.0.
@Highland This would be nice. I do want to point out that there is a simpler way to accomplish this without the formula tile in current state. All you would need to do is have a filter after the join to only include rows where the join key from Table B is null. Hopefully that makes a slightly easier work-around in the meantime!