jaeW_at_Onyx Coach 
-
Re: Help with Magic ETL to calculate the distinct count of pickup numbers by plant
instead of materializing this using a bunch of CASE statements consider just building a pivot table card in Analyzer.1 -
Re: Microsoft SQL Server Partition Connector
@Chris_Wolman that's a shame. you can however use the Java-CLI to push your own partition tags. so if you must partition on non-date columns, the CLI may be your best choice.1 -
Re: Historic Timesheet Analysis
@mhouston you probably can't automate allocation. you could try building buisness logic. so like if the amount posted is negative then just subtract it from previous entries (so we operate on the ass…1 -
Re: Dividing two integer columns that contain 0 values causing incorrect percentage value display (CTR)
remember zero and null are not the same. assuming your beast mode is sum(values) / count(values) if you had 5 rows 0,0, null, 2 and 6, the average is 8/4 = 2 if you had 5 rows null, null, null, 2 and…2 -
Re: Calculating existing delays , Off delays and new delays on manufacturing data
+1 with @MarkSnodgrass there is no reason to calculate your metrics in beast modes, it would just be a slow card with difficult rules. You'll want to use a LAG or LEAD function which is explained her…1
