Best Of
Re: Transition from a regular PostgreSQL connector to PostgreSQL SSH connector
I think you're out of luck still on this one. Switching connector types requires a different type of credential / integration account and changing that in a dataset isn't really an accessible method. You could see if Support has any backend tricks to help accommodate...if you find out please let us know.
In the meantime if you go for a manual migration, just come up with a plan after doing an impact review using stats/governance datasets to get a checklist down. If any of those datasets to migrate have cards pointing directly at them or beast modes on them, it would be a good time to put in a prep layer transform and clean up any beasts too.
Billobi
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