-
Re: Case statement with fixed by
Sbhatia, Domo provides a very good article on this topic: Sample Beast Mode Calculations: Period-over-Period Transforms (domo.com) Your formula will have to take the form of the following:1 -
Re: How do I count the values in a column using beast mode?
Grant's solution will work if you want to count the total full time. If you want a percentage, the following extension of Grant's formula will work: COUNT( CASE WHEN `Full-Time/Part-Time` = 'Full-Tim…1 -
Re: Can my output include projects that don't have a column value for a Split / Group
Hey PJG, Could you provide an example input and desired output? Thanks,1 -
Re: Beast mode question
If you want to exclude weekdays from the calculation, simply create a column to do so: case when day(`date_entered`) in (1,7) then 'Exclude' else 'Include' end Then, in the filters section of analyze…1 -
Re: Average Date Calculation
@damen I think that the average date will give you an incomplete or inaccurate result for this application. I suggest you compute each security's Macauly and Modified duration . This is the tradition…2