Best Of
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
Re: New Customers/
Ok, you can utilize a Magic ETL and the Rank & Window tile to calculate the customer's order number. Make sure you sort on the order date and partition based on the customer identifier and calculate the row number. This will then get you a number for each customer's order with their first order having a value of 1. You can call it Order Count.
Then you can utilize the Order Count field in your visualization and filter for Order Count = 1 to only show the first orders for customers. Then you can also utilize a PoP chart to display the last year vs this year comparison.
Re: How do I format?
You can keep your y-axis as count, but change your chart type to the 100% stacked bar. It is found under the vertical bar chart type. This will get your items to add up to a 100%.
Disable Directory Groups
When we set up SSO we imported all of our Active Directory groups. Well there are way too many of them making it hard to manage groups in general so I would like ot get rid of them. I unchecked the box in SSO that says import Directory groups and remove the passing of directory groups in their actual SSO setup. The groups still show up though. Does anyone know how to remove these? Do I need to turn off SSO and turn it back on?
Ashleigh
New Customers/
Hello,
I'm working on visualizations that aim to show new customers within years. My database contains data from 2020 moving forward. I want to see new/unique customers that bought from us for the first team this year. If it is possibly want to compare it to 2021 too but struggle to filter that out or write a beast mode. Any recommendations? Was thinking of something like
(CASE
WHEN 'firstorder' date (that's the place where I don't know how to write it) > '01.01.2022' THEN 'New Customer 2022'
WHEN 'firstorder' date <'12.31.2021' AND 'firstorder' date '01.01.2021' THEN 'New Customer 2022'
ELSE 'old customer'
END
)
Any ideas how to handle that?
zuchu