Best Of
Re: Help With Creating % Of Total Column
@SLam The beast mode as you have it won't work because both the numerator and denominator will only be counting loans in each group. You will need to use the FIXED function in your denominator to get the total of everything:
https://domohelp.domo.com/hc/en-us/articles/4408174643607-Beast-Mode-FIXED-Functions
Re: Can someone help me with the syntax?
@damen You will want to do just a generic calculation and then use 'Delinquent Payment 2' as a column or series. Your beast mode would look like this:
SUM(1)/SUM(1)FIXED()
When you use this and a 'Delinquent Payment 2' column or series, Domo will do the grouping for you. The denominator of the beast mode will count the number of loans in each type of 'Delinquent Payment 2' and then the numerator will get the total number of loans in your timeframe.
Re: Can someone help me with the syntax?
You need to make 8 different beast modes, 1 for each line you have in your screenshot. Then drag those 8 beast modes into your table card.
Re: Descriptions in PPT and PDF Outputs
This needs to be addressed as our customers will all be exporting the charts to PDF and PowerPoint and the exports need to match what they are seeing on screen.
Jones01
Re: Beast Mode Manager shows deleted beast mode
Are the "ghost" beastmode calcluations saved to the dataset or to separate cards? I've noticed that if I have a beastmode added on only a card and then I use the "save as" option for the card, it will "duplicate" that beastmode with the same name but saved as different calculations on different cards.
Re: Beast Mode Manager shows deleted beast mode
Beastmode Manager has a delay. The best fix is to just wait a few hours. I'm not sure what the exact delay is.
Re: How to get last date
Use a group by tile to group on the name / ID and then take the maximum of your date field.
Re: How to get last date
@ageibe You can do this with the Group By tile in Magic ETL.
In section #1 (select what columns identify the grouping) put your name and patient Id columns in that section.
In section #2 enter the name you want to give the most recent date column
In section #3 choose the encounter date column and then choose maximum for the aggregation type.
This will give you the most recent encounter date for each patient.
Re: Calculating Headcount based on Labor Hour Report
Hi @gbrown try using COUNT(DISTINCT(`employee name`)) in a beast mode to count the number of unique employees.
Re: Copy an entire dashboard
building on @ST_-Superman-_ 's comment, there is a check box in the Save As dialog for "DUplicate All Cards" - if you leave this checked, then it will create new copies exactly as he outlined in his comment. If you uncheck this, then you will get a new dashboard, but with all of the original cards on it. So if you make changes on the original dashboard, then the new dashboard will also have those card changes, and you will not need to manage them separately. So just be mindful of that checkbox based on what your desired use case is.
mhouston