Best Of
Re: Beast Mode FIXED functions multi-field question
bonk Figured out the answer right after posting. Add multiple fields using a comma. 🧐
AVG(AVG(`Score`) FIXED (FILTER ALLOW `Where Monster`,`How Monster`))
Might be helpful to add an example like this to the domohelp article.
G_Grey
Re: Export All Names of Beast Mode Calculations
@newbee do you have dataset access? You can get this from the Domo Governance connector using the "Beast Modes"report - then you could create a view on top to filter by the dataset you are concerned with.
mhouston
Re: Ghost Beast Modes can not be viewed or archived in Beast Mode Manager
@DomoFaye I would get a support case started with the specifics on this issue so this can be investigated further.
BCorless
Re: Automating file load from dynamic file structure
The first thing that comes to mind is to use python to copy the file to a consistent directory for workbench to pull from. There is a python library called os that has a "walk" command that can traverse all subfolders and files in a directory and if they match the search criteria, you could have the file copied.
McSQL
Re: Sum multiple values for the same Invoices
I would use a formula tile in magic ETL. You would also need to group by the account number. If you want the same number on each row, so you still have multiple rows I would branch this logic out and then join itself back.
Byboth
Re: Help - Period over Period w/ Beast Mode Week Field
@Rak is it an option to change this globally across your domo instance? In the Admin > Company settings, there is a week display option that you can toggle between Week Number and Week dates:
This would be the easiest way to achieve it (without having to convert your dates using a beast mode).
mhouston